vb.org Archive - Database error

Okay, my clients site is getting a db error whenever you go to a certian forum, same for when you click on a members name.

At first i thought it was vbseo for vb 4 but after doing a fresh install and turning the plugin off it still happens.

Also the site was using a different version of vb untill her old webmaster upgraded it to 4.

Forum db error:

Code:

Database error in vBulletin 4.0.0:



Invalid SQL:



                SELECT 

                        IF(votenum >= 1, votenum, 0) AS votenum,

                        IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,

                 post.pagetext AS preview,

                        thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,

                        thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,

                        thread.prefixid, thread.taglist, hiddencount, deletedcount,

                        user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend

                        

                        , deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

                        , threadread.readtime AS threadread

                        , threadredirect.expires

                        

                FROM thread AS thread

                        LEFT JOIN user AS user ON (user.userid = thread.lastposterid)

                        LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 5495)

                        LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')

                        

                         LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 5495)

                        LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

                        

                        LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

                        

                WHERE thread.threadid IN (0,41147,38358,24113,41161,40981,41093,41159,40872,41158,41136,41080,41140,38931,40236,40752,40839,41095,41102,40694,41096,40988,41112,41105,40419,41135,37125,6366,10102,31219,8093,41164) 

                ORDER BY sticky DESC, lastpost DESC;



MySQL Error   : Table './cotille_forum/post' is marked as crashed and last (automatic?) repair failed

Error Number  : 144

Request Date  : Sunday, December 27th 2009 @ 11:39:39 PM

Error Date    : Sunday, December 27th 2009 @ 11:39:39 PM

Script        : http://www.cotilleando.com/forumdisplay.php?f=6

Referrer      : http://www.cotilleando.com/

IP Address    : 74.47.173.149

Username      : ExT

Classname     : vB_Database

MySQL Version : 5.0.85-community

Member name db error:

Code:

Database error in vBulletin 4.0.0:



Invalid SQL:



                        SELECT COUNT(*) AS count

                        FROM infraction AS infraction

                        LEFT JOIN post AS post ON (infraction.postid = post.postid)

                        LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)

                        WHERE infraction.userid = 2;



MySQL Error   : Table './cotille_forum/post' is marked as crashed and last (automatic?) repair failed

Error Number  : 144

Request Date  : Sunday, December 27th 2009 @ 11:44:54 PM

Error Date    : Sunday, December 27th 2009 @ 11:44:55 PM

Script        : http://www.cotilleando.com/member.php?u=2

Referrer      : http://www.cotilleando.com/

IP Address    : 74.47.173.149

Username      : ExT

Classname     : vB_Database

MySQL Version : 5.0.85-community

Edit:
whoops forgot the one in the admincp index.php

Code:

Database error in vBulletin 4.0.0:



Invalid SQL:

SELECT COUNT(*) AS count FROM post WHERE dateline >= 1261890000;



MySQL Error   : Table './cotille_forum/post' is marked as crashed and last (automatic?) repair failed

Error Number  : 144

Request Date  : Sunday, December 27th 2009 @ 11:47:14 PM

Error Date    : Sunday, December 27th 2009 @ 11:47:14 PM

Script        : http://www.cotilleando.com/admincp/index.php?do=home

Referrer      : http://www.cotilleando.com/admincp/index.php

IP Address    : 74.47.173.149

Username      : ExT

Classname     : vB_Database

MySQL Version : 5.0.85-community

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02028 seconds Memory Usage 1,744KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: