my board is down

[jfazio]

Hi, thanks in advance for any help you can offer. This is one of the many messages.

BODY {font-family="Arial"} TT {font-family="Courier New"} BLOCKQUOTE.CITE {padding-left:0.5em; margin-left:0; margin-right:0; margin-top:0; margin-bottom:0; border-left:"solid 2";} Database error in vBulletin 3.7.1:

Invalid SQL:

REPLACE INTO guest
(guestid, hostip, useragent, lastactive, spider, script, rdata)
VALUES
('12e8077bea90b0f1f6ba8239c61d434b', '74.6.8.95', 'Mozilla/5.0 (compatible; Yahoo! Slurp; http://help.yahoo.com/help/us/ysearch/slurp)', 1216162862, 'Yahoo! Slurp', 'showthread', 'a:7:{s:1:\"p\";s:4:\"1477\";s:6:\"postid\";i:1477;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 './yorkmain_vbb/guest' is marked as crashed and should be repaired
Error Number : 145
Request Date : Tuesday, July 15th 2008 @ 05:01:02 PM
Error Date : Tuesday, July 15th 2008 @ 05:01:02 PM
Script : http://www.thedachshundnetwork.com/v...ead.php?p=1477
Referrer :
IP Address : 74.6.8.95
Username : Unregistered
Classname : vb_database
MySQL Version :

I am downloading the newest patch, in the hope of that helping. If I need to upload my backed up database, how would I do that? Thank you. J

[Steve Machol]

There is no table named 'guest' in vB. That is from an add-on. Nonetheless you need to repair that tal.

To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors:

Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue

If you cannot access the Admin CP you can also use phpMyAdmin to repair tables.

Also please see these instructions for other available methods to repair a database:

http://dev.mysql.com/doc/refman/5.0/en/repair.html

[jfazio]

Hi, although the other "guest" problem's fixed, now this error message, which the repair doesn't seem to fix. thanks, again.

BODY {font-family="Arial"} TT {font-family="Courier New"} BLOCKQUOTE.CITE {padding-left:0.5em; margin-left:0; margin-right:0; margin-top:0; margin-bottom:0; border-left:"solid 2";} Database error in vBulletin 3.7.1:

Invalid SQL:

INSERT INTO taggregate_temp_1216220160
SELECT threadid, COUNT(*) AS views
FROM threadviews
GROUP BY threadid;

MySQL Error : Incorrect key file for table './yorkmain_vbb/threadviews'; try to repair it
Error Number : 126
Request Date : Wednesday, July 16th 2008 @ 08:57:24 AM
Error Date : Wednesday, July 16th 2008 @ 08:57:24 AM
Script : http://www.thedachshundnetwork.com/v...hp?rand=757357
Referrer : http://www.thedachshundnetwork.com/v...e&pp=20&page=1
IP Address : 98.14.127.57
Username : Unregistered
Classname : vb_database
MySQL Version :

[Steve Machol]

Same thing. You need to repair that table.

[jfazio]

Hi Steve:

Do you have any ideas as to what may have caused this? Thank you for your help.

[Steve Machol]

Table corruption is a server issue. If it keeps happening then this is an indication of a poorly maintained server.

[jfazio]

It is still happening despite the fact that everything now looks like it's been repaired/optimized at the cp.

Should I contact server?

[Steve Machol]

Yes, contact your host.