Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 12-28-2009, 02:46 AM
ExTincTi0N ExTincTi0N is offline
 
Join Date: Mar 2008
Location: Texas
Posts: 332
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Reply With Quote
Reply


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

Forum Jump


All times are GMT. The time now is 06:28 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.09654 seconds
  • Memory Usage 2,210KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (3)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)showthread_list
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_threadedmode.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids_threaded
  • showthread_threaded_construct_link
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete