Query was empty problem

[uwe]

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 ?

[joximu]

search the forum.
Did you update from an older release?
add the table subdomainaliases (or similar) manually.

/J

[uwe]

(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 ?

[William1]

Dear I'm also facing this trouble. And i wanted a good salutation of this program..!

[uwe]

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

[joximu]

phpMyAdmin is easier...

/J

[GlendonSheldon]

Everybody's comments are right.
__________________________________________________
Cadillac shocks and struts
Chevrolet shocks and struts
Shock absorber