View Single Post
  #4  
Old 8th October 2009, 09:28
Antennipasi Antennipasi is offline
ISPConfig Developer
 
Join Date: Dec 2008
Location: Finland
Posts: 67
Thanks: 6
Thanked 13 Times in 12 Posts
Default

Quote:
Originally Posted by orion09 View Post
so we upgraded it, and yes, tables with the resseler and client logins were restored also. Too many to be hand made.

So am I screwd ?
still, if you use update-function as described here:
http://www.howtoforge.com/forums/showthread.php?t=38795
data should already be there, no need to restore anything.
if really necessary to restore stuff, one should restore only values, not table-structure.

anyway, running these two commands should bring you back:
Code:
ALTER TABLE `client` ADD `limit_cron` INT( 11 ) NOT NULL DEFAULT '0' AFTER `limit_database` ,
ADD `limit_cron_type` ENUM( 'url', 'chrooted', 'full' ) NOT NULL DEFAULT 'url' AFTER `limit_cron` ,
ADD `limit_cron_frequency` INT( 11 ) NOT NULL DEFAULT '5' AFTER `limit_cron_type` ;

ALTER TABLE `client_template` ADD `limit_cron` INT( 11 ) NOT NULL DEFAULT '0' AFTER `limit_database` ,
ADD `limit_cron_type` ENUM( 'url', 'chrooted', 'full' ) NOT NULL DEFAULT 'url' AFTER `limit_cron` ,
ADD `limit_cron_frequency` INT( 11 ) NOT NULL DEFAULT '5' AFTER `limit_cron_type` ;
as always, make backups before executing commands on mysql.
you have table named "cron", right?
there can still be some minor jerks, if so, i have to check what else was changed in mysql between 3.0.1.2 and 3.0.1.4
Reply With Quote