Errors 1203, 1030, and 1016

[Don Maddox]

I've never had any errors with my forum until today when all of the sudden I received about 20 error e-mails from the forum. Here is a bit of information:

1. http://www.warfarehq.com/forums/index.php
2. PHP version: 4.1.2
3. MySQL Client API version: 3.23.39
4. Apache/1.3.26 (Unix) FrontPage/5.0.2.25102001 i686 unknown
5. Hacks?: NO

Here are the errors I received:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error: User [email protected] has already more than 'max_user_connections' active connections

mysql error number: 1203

Date: Wednesday 04th of September 2002 12:52:47 PM
Script: /forums/index.php
Referer:

Also this one.

Database error in vBulletin 2.2.6:

Invalid SQL: INSERT IGNORE INTO word (wordid,title) VALUES (NULL,'sequences'),(NULL,'elem'),(NULL,'klimov'),(NULL,'fled'),(NULL,'remembers'),(NULL,'v olga'),(NULL,'hooks'),(NULL,'einsatzgruppen'),(NULL,'unwatchable'),(NULL,'punches'),(NULL, 'subjective'),(NULL,'muffled'),(NULL,'audible'),(NULL,'ringing'),(NULL,'deafened'),(NULL,' imperceptibly'),(NULL,'kino'),(NULL,'revamped'),(NULL,'2disc'),(NULL,'recommened'),(NULL,' unjustly'),(NULL,'bible'),(NULL,'revelation'),(NULL,'divine'),(NULL,'chap'),(NULL,'verse') ,(NULL,'thunder'),(NULL,'see.')
mysql error: Got error 28 from table handler

mysql error number: 1030

Date: Wednesday 04th of September 2002 12:52:48 PM
Script: http://www.warfarehq.com/forums/forums/newreply.php
Referer: http://www.warfarehq.com/forums/newr...ly&postid=1713

And...

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('hey','','this','has','been','here','for','a','bit','but','i','was','wondering','if','you ','found','an','opponent','','','i','have','yet','to','play','my','first','email','game',' so','i','think','i','qualify','as','a','newbie','','','im','up','for','a','game','of','ea' ,'if','you','are','still','looking','','','cheers','','brig')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

Date: Wednesday 04th of September 2002 01:09:46 PM
Script: http://www.warfarehq.com/forums/forums/newreply.php
Referer: http://www.warfarehq.com/forums/newr...y&threadid=172

And...

Database error in vBulletin 2.2.6:

Invalid SQL: SELECT wordid,title FROM word WHERE title IN ('steel','beasts','is','a','superb','sim','ive','designed','many','scenarios','for','sb',' andd','am','proud','to','be','on','the','sb2','scenario','design','team','','heres','by',' far','the','best','way','to','hook','up','with','opponents/teammates','for','multiplayer','the','site','is','being','reconstructed','but','use','the' ,'links','to','both','the','forums','and','the','chatroom','','','','url','http//www.steelbeasts.com/','/url','','','','this','is','the','official','fansite','its','very','popular','and','you','w ill','need','to','look','no','further','','ice')
mysql error: Can't open file: 'word.MYD'. (errno: 145)

mysql error number: 1016

Date: Wednesday 04th of September 2002 01:15:45 PM
Script: http://www.warfarehq.com/forums/forums/newreply.php
Referer: http://www.warfarehq.com/forums/newr...y&threadid=257

There are several more error messages with the same MySQL error numbers. Any help would be appreciated.

[Steve Machol]

All different errors. The biggest problem is error 28. This means that the partition with the MySQL databases has run out of space. You should close your forums immediately and contact your host before any more corruption occurs. They need o free up some space.

After they've done that, upload repair.php (it's in the 'extras' folder of the zip file) to your admin directory. Then run it from your browser with this syntax:

repair.php?html=1&check=1

If everything reports 'Ok' then reopen your forums. If not, then run it again. The second time everything should report Ok. See if this fixes the problem.

Note that you are also using more MySQL connections than your host allows. You can try turning persistent connections off in your config.php:

// use persistant connections to the database
// 0 = don't use
// 1 = use
$usepconnect = 0; 

But if you still have problems after that, all you can do is ask your host to raise the maximum number of connections they allow.

[hornstar6969]

Problem with this is tht you cant close the forums because i get the database error message when I go to options in the admincp

MySQL Error : Got error 28 from table handler
Error Number : 1030

[Steve Machol]

Error code 28: No space left on device

One or more partitions on your server is out of space or doesn't have enough space to complete this operation. Shutdown your forums (if you can) and contact your host immediately. You or your host will need to find out which partition is low on space and free up some more space.

Here is an explanation of the error on the MySQL site:

http://www.mysql.com/news-and-events...000000249.html