+- ispCP - Board - Support (http://www.isp-control.net/forum)
+-- Forum: ispCP Omega Development Area (/forum-1.html)
+--- Forum: General discussion (/forum-11.html)
+--- Thread: Query was empty problem (/thread-7573.html)
Query was empty problem - uwe - 08-22-2009 12:30 AM
Hello, i have the same problem described in http://isp-control.net/ispcp/ticket/1865 , where should i look for corrupted data? any suggestion to how to fix it ?
RE: Query was empty problem - joximu - 08-22-2009 06:50 AM
search the forum.
Did you update from an older release?
add the table subdomainaliases (or similar) manually.
/J
RE: Query was empty problem - uwe - 08-24-2009 05:32 AM
(08-22-2009 06:50 AM)joximu Wrote: search the forum.
Did you update from an older release?
add the table subdomainaliases (or similar) manually.
/J
Hello,
Thanks for response, i have the table subdomain_alias already there !(was not missing) i have two installations, i did a quick comparison, the tables are all the same (i have some diffrences due to hacks and test i tried on the "other" server, which is running fine)
Yes, i upgraded a while ago to 1.0.0 stable , would it be ok if i upgrade now on a not so well running installation ? i'm trying to hunt it down, i reached
generate_reseller_user_props call in /var/www/ispcp/gui/reseller/index.php ...
edit: the problem is when generate_user_traffic is called for one of the reseller accts (who actually has clients) , commenting that piece out makes things run but with many notices ...
EDIT !!!: i fixed it, table domain_traffic was marked as crashed , repaired by running "repair table domain_traffic ;" from mysql client ; there must be a way to check all tables somehow , myisamchk *.MYI is an option ( i did not try it) ; and one could defenetly list all tables, copy names, create check table statements and check them all ... just in case someone else finds a similar problem ...
is it possible/desired to implement something that can catch and meaningfully report such issue ? if yes, how would it look like/be ? exception handling or something else ?
Hi, - William1 - 08-26-2009 08:09 PM
Dear I'm also facing this trouble. And i wanted a good salutation of this program..!
RE: Query was empty problem - uwe - 09-01-2009 11:31 PM
i'll suggest to get a list of all table names, then using vi, sed or excel sheet create statements like:
check table <table1_name>;
check table <table2_name>;
check table <table3_name>;
check table <table4_name>;
...
and run it in mysql , and take a look at the output ... just in case the reason for the error is that a table is currupted ... maybe its a missing table !
good luck
RE: Query was empty problem - joximu - 09-01-2009 11:41 PM
phpMyAdmin is easier...
/J
RE: Query was empty problem - GlendonSheldon - 08-23-2010 11:42 AM
Everybody's comments are right.
__________________________________________________
Cadillac shocks and struts
Chevrolet shocks and struts
Shock absorber