MonitorWare Knowledge Base

Everything was working fine until last week when my server crashed.

The syslogger is writing to the DB but I keep getting this error message when I log in.

~~~~~~~~~~
Warning: mysql_query(): Unable to save result set in c:\inetpub\wwwroot\logging\db-drv\mysql.php on line 99

Database error: Invalid query
mysql error: Got error 127 from storage engine
mysql error number: 1030
Date: 26.11.2006 @ 10:52
Script:
~~~~~~~~~~

I have repaired the tables and all my other Databases are working just fine.

The size of the table is when it stopped working was about 500Mb.

Thanks

This is more a mysql related issue than a phplogcon one.

I have done a quick search on this topic and most frequently the solution is to repair the tables as you have already done. Did you get any error during repair process? If you are using an older version of mysql maybe an update solve the problem. Otherwise you could backup the data and recreate the table. Hope this help.

Michael

I did not recieve an error during the repair process "Completed Successfully" I could even write to the DB just not pull.

Ended up deleting DB and than restored data. Than ran into this Error message "Fatal error: Maximum execution time of 30 seconds exceeded in wwwroot path

You have to make a change to the PHP.ini file, i changed mine to 120seconds just to be safe in the future as the DB grows even more.

Thanks for the Help