Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th October 2009, 17:05
orion09 orion09 is offline
Junior Member
 
Join Date: Oct 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default ISP Config3 Reseller and Client problems

Hi,

Im new to ISP Config, I installed 3.0.1.2 and wasnt able to add Cutoms Rules or change to my language, so I upgraded to 3.0.1.4 the most recent one, it qorks like a charm on my CentOS installation, after the upgrade I managed to add the Custom Rules and change the language.

The thing is, when I did the upgrade I only made a .sql backup of the "mail_" tables, restored then nicely and the accounts are working, but now when logged in as a client i cannot check the "Use Antispam" in mailboxes, tried as Admin, goes fine, so I thought that it could be a Client restriction, decided to change clinte to Reseller, well when trying to edit the limits of the reseller it gives me this message:

Unknown column 'limit_cron' in 'field list'

Well, could not find any tables with "limit_cron" in it, can anyone help me?

Thanks
Reply With Quote
Sponsored Links
  #2  
Old 7th October 2009, 08:57
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
The thing is, when I did the upgrade I only made a .sql backup of the "mail_" tables, restored then nicely and the accounts are working
well, if you upgraded with included tool why did you restore backup?
IspConfig's database is not always same between versions, and as you noticed, one can not blindly restore tables to it from previous versions.

Quote:
Originally Posted by orion09 View Post
Unknown column 'limit_cron' in 'field list'
Well, could not find any tables with "limit_cron" in it, can anyone help me?

Thanks
there is no cron-related tables in mail_*, are you sure you did not restore something else too, like "client" and/or "client_template"?
Reply With Quote
  #3  
Old 7th October 2009, 18:28
orion09 orion09 is offline
Junior Member
 
Join Date: Oct 2009
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Well, we had to restore the mail_* databases cause we already had tons of mail accounts, but the versin of ISPConfig 3 we were using had no Mail Custom Rules working, and had no pt-br language, 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 ?
Reply With Quote
  #4  
Old 8th October 2009, 08: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
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Edit the creation pages (site, client, reseller) JaJunk Feature Requests 2 15th May 2007 22:49
Cannot create client, reseller and hosting plan crapufish Installation/Configuration 22 15th March 2007 10:27
link reseller to client entries NETabuse Installation/Configuration 2 20th February 2007 19:34
ISP Client Page Data nok Installation/Configuration 0 27th February 2006 22:41
isp manager - can't create reseller, client, hosting plan etc ahuen Installation/Configuration 13 2nd September 2005 20:49


All times are GMT +2. The time now is 09:46.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.