PDA

View Full Version : MySQL Error


incurable
03-15-2006, 04:21 AM
Hello guys.. I'm sure this is my bad but could you help to tell me what i did wrong when upgrading vbbux?

Now i have this error when i click new post at my site.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT postid, visible, userid
FROM post AS post

WHERE threadid = 213
AND visible IN (1
,2
,0
)

ORDER BY dateline;

MySQL Error : Got error 127 from storage engine
Error Number : 1030
Date : Wednesday, March 15th 2006 @ 07:27:04 AM
Script : http://www.belleclique.com/showthread.php?t=213&goto=newpost
Referrer :
IP Address : 221.137.115.38
Username : tintin
Classname : vb_database


Thank you in advance!

Tintin

CMX_CMGSCCC
03-15-2006, 12:41 PM
WTF lol, no idea whats up with that, try the Maintenance to Repair/Optimize the database from the Admin CP near the bottom.

-CMX

incurable
03-15-2006, 02:15 PM
Now i get this by doing repairing.

post Check Error: Size of datafile is: 413660 Should be: 413880
post Check Error: Corrupt
postindex Check Error: Size of datafile is: 226850 Should be: 227019
postindex Check Error: Corrupt
word Check Error: Size of datafile is: 370755 Should be: 370865
word Check Error: Corrupt


What's wrong.. what can i do ? :(

Thank you .

Oh i repeated the process again and no error accurs now.. woww...Thank you CMX.. Gotta love ya!!!!!

Tintin

CMX_CMGSCCC
03-15-2006, 02:34 PM
Kool, yeah, usually if there are errors, the repair helps most of the time.

Thanx for supporting vbPlaza!

-CMX

incurable
03-15-2006, 02:44 PM
Thank you for the great plugin and support. :)

Tintin