IspConfig3 Sites tab

Hi everybody,

it's about two days that in my IspConfig3 "Sites" tab shows a strange message on top ( and on top of every sub-tabs ):

the message is:
#0 db->query(SELECT sys_datalog.error, sys_log.tstamp FROM sys_datalog, sys_log WHERE sys_datalog.dbtable = 'web_domain' AND sys_datalog.dbidx = 'domain_id:26' AND sys_datalog.datalog_id = sys_log.datalog_id AND sys_log.message = CONCAT('Processed datalog_id ',sys_log.datalog_id) ORDER BY sys_datalog.tstamp DESC) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:172] #1 db->queryOneRecord(SELECT sys_datalog.error, sys_log.tstamp FROM sys_datalog, sys_log WHERE sys_datalog.dbtable = 'web_domain' AND sys_datalog.dbidx = 'domain_id:26' AND sys_datalog.datalog_id = sys_log.datalog_id AND sys_log.message = CONCAT('Processed datalog_id ',sys_log.datalog_id) ORDER BY sys_datalog.tstamp DESC) called at [/usr/local/ispconfig/interface/web/sites/web_domain_edit.php:453] #2 page_action->onShowEnd() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:513] #3 tform_actions->onShow() called at [/usr/local/ispconfig/interface/lib/classes/tform_actions.inc.php:70] #4 tform_actions->onLoad() called at [/usr/local/ispconfig/interface/web/sites/web_domain_edit.php:995]

Now, my system is a Ubuntu 10.04 LTS x64 on a OVH dedicated server, using Apache / Courier / Postfix ( setup according to Howtoforge perfect server setup steps.

Here follows the image:



Please help me!

Thank You

Masterbyte

 

Hi Till,

just done what you advised, but without success: the error remains the same as before.
Should I have to do anything more after repairing db tables?

Thank you

Masterbyte

 

Hi everyone,

First, sorry for my bad english.

I haved exact the same problem.
I think, the update script not creating this tables, and after upgrade, the tables are missing.

But i have able to fix it with a creating 3 missing tables on dbispconfig, here is how:

add this SQL manualy on phpmyadmin dbispconfig main table:

ALTER TABLE `sys_datalog` ADD `error` MEDIUMTEXT NOT NULL ;
ALTER TABLE `web_domain` ADD `last_quota_notification` DATE NULL DEFAULT NULL ;
ALTER TABLE `web_domain` ADD `rewrite_rules` MEDIUMTEXT DEFAULT NOT NULL ;

Hope this help you.

Regards from Switzerland.

Joe

 

This is not part of the latest stable release as far as I remember.
What versions are you using?

 

Hi

I use:

IspConfig 3.0.5.3 (updated)
Fedora server 15 (Lovelock) - setup according to Howtoforge perfect server setup steps
.. and my own created web server, in my home.

That's it.

For me, worked (i have created the tables manualy, not with ALTER TABLE... but, i tryed to reproduce the easy steps with a input SQL command here, i think, this will work for other people who have this problem, but, you can try manualy to add this 3 missed tables (or whatever database table you missed from the original one in setup .sql file), and, it should work after)

This error are generated if the script doesn't find the given database tables, and you should look, what for tables are still missed from the errors.

Thanks

Regards

 

I'm still quite puzzled how these columns can be missing?
You did not use the update.php script from ISPConfig to update to 3.0.5.3?

 

Excuse-me all, but due to illness I was away from my pc till now.

I checked Silwanyx answer and I have to say it worked for me too.

Croydon, as Silwanyx did, I updated my ispconfig version via the update script ( ispconfig_update.sh ) using the "stable" release.

Thanks a lot to all.

Masterbyte

 

Did you have any SVN (stable or trunk) version installed before? That would be the only explanation I could imagine.

 

Actually no.
It was installed more than two years ago according to HowToForge perfect server Ubuntu 10.04 , it was installed first time using tar.gz package and then using update_ispconfig.sh script