I Got Hundreds of "SQL ERROR" emails ......

[miltboogie]

--------------------------------------------------------------------------

68.161.61.122 -- July 26, 2004, 10:30:42 am -- CREATE TABLE IF NOT EXISTS default_stats ( time_str DATETIME, remote_host TEXT, request TEXT, referer TEXT, user_agent TEXT )



????

my web host temporarily suspended my account !!!!! HELP !!!!

[MjrGaelic]

Have you installed any mods - if so which?

[RealtyOne]

CREATE TABLE IF NOT EXISTS default_stats ( time_str DATETIME, remote_host TEXT, request TEXT, referer TEXT, user_agent TEXT )
The problem is with your stats mod allthough what mod you use i dont know this post should be in the thread of the mod used then we all know what is going on.

your system is attempting to create a table on page open is my guess so you need to fiind the query and remove it to stop the errors.

[miltboogie]

i am using full mod

and how do i find the query and delete it

i can live with deleting the stats mod n the web site if that does the trick

please help cuz these emails are driving me nuts and i am getin em eveytime i get an aopne page i guess !!!

[the_sandking]

The DB table "default_stats" has either become too large or has become corrupted.

Erase the contents of this table and you will stop getting these errors.

The stats MOD can consume a lot of table space, and since it does not have an index, can be corrupted more easily.

[miltboogie]

The DB table "default_stats" has either become too large or has become corrupted.

Erase the contents of this table and you will stop getting these errors.

The stats MOD can consume a lot of table space, and since it does not have an index, can be corrupted more easily.


so how can i delete it all together

[the_sandking]

so how can i delete it all together I am assuming you wish to remove the STATS MOD altogether..

Since I am not familiar with how the full MOD is setup to use STATS, I am also assuming that the code that triggers the STATS in located in your "user_bottom.html" at or near the bottom of the file.

Look for, and remove the code that looks like this:


// Statistics
include($config['basepath'] ."/include/stat_func.php");
logstats();
You would then need to delete the DB table "default_stats" using PHPMyAdmin or whatever your host offers.

To re-enable the STATS at some later date, just put the code you removed above back into "user_bottom.html" and the next time someone visits your site the DB table will be automatically created.

[miltboogie]

did it ! thanks !!!!!