Query was empty problem

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