Database Error

[ECMatt90]

Hoping someone can help me with this. I'm not super "savvy" with VBulletin so please try to help me in basic terms. I have a Database Error and this is the email message I got.

Domain name is www.TheBurningReel.com

Database error in vBulletin 3.7.1:

Invalid SQL:

REPLACE INTO guest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('1e57e486accaf5a901b4163e823f3df0', '157.55.33.98', 'Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)', 1352131914, '', 'showpost', 'a:8:{s:1:\"p\";s:5:\"25851\";s:9:\"postcount\";s: 1:\"2\";s:6:\"postid\";i:25851;s:1:\"s\";s:0:\"\"; s:8:\"threadid\";i:0;s:7:\"forumid\";s:2:\"60\";s: 6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Table './ecmatt901/guest' is marked as crashed and last (automatic?) repair failed
Error Number : 144
Request Date : Monday, November 5th 2012 @ 09:11:54 AM
Error Date : Monday, November 5th 2012 @ 09:11:54 AM
Script : http://www.theburningreel.com/forums/25851-post2.html
Referrer :
IP Address : 157.55.33.98
Username : Unregistered
Classname : vB_Database
MySQL Version

[kh99]

That error says that there is a problem with the "guest" table, and that it needs to be repaired. If you have access to your database through phpMyAdmin, here's a page that describes how to repair a table: http://php.about.com/od/mysqladminis...pair_mysql.htm

If that doesn't work you might be able to truncate the table, but vbulletin has no table named "guest" so I have to assume that's a mod, and so I don't what the affect would be.

[ECMatt90]

Originally Posted by kh99

That error says that there is a problem with the "guest" table, and that it needs to be repaired. If you have access to your database through phpMyAdmin, here's a page that describes how to repair a table: http://php.about.com/od/mysqladminis...pair_mysql.htm

If that doesn't work you might be able to truncate the table, but vbulletin has no table named "guest" so I have to assume that's a mod, and so I don't what the affect would be.

Yeah, so I don't really know what that means...

Is phpMyAdmin a free option to use?

Is there anyone out there than can fix it for me?

--------------- Added [DATE]1352134428[/DATE] at [TIME]1352134428[/TIME] ---------------

Wow.. Got luckly.. Just disable a mod called "Guest Tracking" and it fixed it...

Thank you!

Matt

[Simon Lloyd]

In answer to your question phpmyadmin is free to use but it depends on what your host has loaded, whichever database management/manipulation software you have it should have an option to repair or optimise your table(s), this is what KH99 is talking about, either by using built in software or using ssh to repair the guest table, if you do this you can turn that mod back on and all wil be well

It's not the fault of the mod, turning it off alieviated the problem because it calls on the guest table.