Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 05 Nov 2012, 15:28
ECMatt90 ECMatt90 is offline
 
Join Date: Nov 2007
Database Error

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
Reply With Quote
  #2  
Old 05 Nov 2012, 15:37
kh99 kh99 is offline
 
Join Date: Aug 2009
Real name: Kevin
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.
Reply With Quote
  #3  
Old 05 Nov 2012, 15:42
ECMatt90 ECMatt90 is offline
 
Join Date: Nov 2007
Originally Posted by kh99 View Post
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 05 Nov 2012 at 15:53 ---------------

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

Thank you!

Matt

Last edited by ECMatt90; 05 Nov 2012 at 15:49.
Reply With Quote
  #4  
Old 05 Nov 2012, 17:12
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
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.
__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 03:03.

Layout Options | Width: Wide Color: