MySQL Error : Got error 127 from table handler

[hornstar6969]

This is my first error im getting, how do i fix this?

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT count(*) as num,floor((1142985599-dateline)/604800) as week FROM vb3_wwu002visitlog WHERE (userid=4101)AND(dateline>=1140566400) GROUP BY week ORDER BY week;

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

and im also getting this database error, so im unable to even access my site now.

atabase error in vBulletin :

mysql_connect(): User gamerzne_hornsta has already more than 'max_user_connections' active connections
/home/gamerzne/public_html/forums/includes/class_core.php on line 279

MySQL Error  :
Error Number :
 Date         : Tuesday, March 21st 2006 @ 05:21:40 PM

how do i fix this one?


Thanks















edit i tried to run repair/optimize tables but I got this error

Database error in vBulletin 3.5.4:

Invalid SQL:
OPTIMIZE TABLE `vb3_attachment`;

MySQL Error  : Lost connection to MySQL server during query
Error Number : 2013
Date         : Tuesday, March 21st 2006 @ 05:29:06 PM
Script       : http://www.gamerzneeds.net/forums/admincp/repair.php
Referrer     : http://www.gamerzneeds.net/forums/admincp/repair.php?do=list
IP Address   : 220.240.154.11
Username     : Hornstar6969
Classname    : vb_database

i got so many database errors, my hosting company suspended my site, but because i have a reseller account and it was not my default account, i was able to unsuspend myself, phew for that lol

now, i have gone back in, and it finally worked, i was able to run the table repair and i am not getting any errors currently.

I'm going to do a full backup and save it now, incase they suspend me, that would be too scary for that to happen.

[Wayne Luke]

Repair is how you fix the 127 error. Means the record file is crashed.

You can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result.

For too many connections make sure that you have persistant connections off in your config.php and you will just have to wait for it to go away. If you have your own dedicated server, you can increase this by creating or editing the mySQL configuration file. This is detailed here:

http://dev.mysql.com/doc/refman/4.1/en/too-many-connections.html

If you are on a shared server, asking your host might get this increased but you have little control over your connections on a shared server.

[Shelby]

Got error 127 from table handler

Invalid SQL:
SELECT COUNT(*) AS threads,
SUM(IF(thread.lastpost >= 1147518580 AND open <> 10, 1, 0)) AS newthread

FROM thread AS thread

WHERE forumid = 12
AND sticky = 0
AND visible = 1

AND thread.lastpost >= 1144926580;
MySQL Error : Got error 127 from table handler
Error Number : 1030
Date : Saturday, May 13th 2006 @ 04:09:40 AM
Script : http://www.warhammeralliance.com/for...splay.php?f=12
Referrer : http://www.warhammeralliance.com/forums/
IP Address : 70.57.17.252
Username : Unregistered
Classname : vb_database

Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
(1, 1, 'PlagueLord', 1151, '', '

Phantasy Star online only worked because its simple. WoW isnt and WAR shouldn\'t be on consoles because of its complexity. They wouldn\'t work on consoles without alot of dumbing down and i would hate to see a good thing go to waste just for it to be on consoles. I think they should keep it on PCs where it belongs.

\r\n\r\nFinal fantasy11 is also on the 360.', 0, 1, 57045, 2484, 1147518629, '86.41.219.222', 0);
MySQL Error : Duplicate entry '57219' for key 1
Error Number : 1062
Date : Saturday, May 13th 2006 @ 04:10:29 AM
Script : http://www.warhammeralliance.com/forums/newreply.php
Referrer : http://www.warhammeralliance.com/for...wreply&p=57045
IP Address : 86.41.219.222
Username : PlagueLord
Classname : vb_database

Okay now I was at least smart enough to do the repair table thing from the admin page and it fixes the symtoms. However, this is the second day in a row I've woken up to 1500 emails. What is the cause of this problem and how do I fix it?

[Steve Machol]

The first error is db corrunption and iuf this happens regularly, then this is an indication of a poorly maintained and optimized server. You will need to contact your host about this.

The second one is a common problem with some add-ons or hacks. You can remove these to see if the problems go away.