Log in

View Full Version : 1500 emals reporting DB Error! Please help!


powerful_rogue
05-13-2009, 11:50 AM
Hi,
Ive just got home from work to check my emails and I have 1500 of them reporting database errors!

Database error in vBulletin 3.8.2:

Invalid SQL:

REPLACE INTO guest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('19aaa39166f01fdfc337ddfa343b1f25', '66.249.71.106', 'Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)', 1242131791, 'Google', 'showpost', 'a:8:{s:1:\"p\";s:5:\"30335\";s:9:\"postcount\";s: 1:\"1\";s:6:\"postid\";i:30335;s:1:\"s\";s:0:\"\"; s:8:\"threadid\";i:0;s:7:\"forumid\";s:2:\"12\";s: 6:\"pollid\";i:0;s:1:\"a\";s:0:\"\";}');

MySQL Error : Table './doverloc_doverlocals/guest' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, May 12th 2009 @ 01:36:31 PM
Error Date : Tuesday, May 12th 2009 @ 01:36:31 PM
Script : http://www.doverlocals.co.uk/showpos...35&postcount=1

Biker_GA
05-13-2009, 11:52 AM
Repair your tables.

Seven Skins
05-13-2009, 11:54 AM
You need to repair the tables. "Guests"

MySQL Error : Table './doverloc_doverlocals/guest' is marked as crashed and should be repaired

AdminCP > Maintenance > Repair / Optimize Tables

.

powerful_rogue
05-13-2009, 11:56 AM
Thanks people :)