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

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2006, 01:46 PM
unenergizer unenergizer is offline
 
Join Date: Nov 2004
Location: Texas, YE HAW
Posts: 329
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default im getting a simple error... can u help?

My first one, on my homepage says:

Code:
Database error in vBulletin 3.5.2:

Invalid SQL:

				SELECT IF(votenum >= 1, votenum, 0) AS numbvote, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg,
				thread.threadid, post.title, thread.replycount, postusername, postuserid, thread.dateline AS postdateline, thread.lastposter, thread.lastpost, IF(views<=thread.replycount, thread.replycount+1, views) AS views, thread.forumid, post.postid, pagetext, allowsmilie, forum.title AS forumtitle
				
				,thread.iconid AS threadiconid, iconpath AS threadiconpath
				
				, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed 
				FROM ghthread AS thread
				LEFT JOIN ghforum AS forum USING (forumid)
				LEFT JOIN ghpost AS post ON (post.postid = thread.firstpostid)
				LEFT JOIN ghicon USING (iconid)
				
				
				
				 LEFT JOIN ghsubscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = '1')
				LEFT JOIN ghdeletionlog AS deletionlog ON (thread.threadid = deletionlog.primaryid AND type = 'thread')
				WHERE thread.threadid IN(263,260,239,217,189,164,148,139,136,130,129,128,126,117,115)
				
				GROUP BY post.postid
				ORDER BY thread.dateline DESC
				LIMIT 15;

MySQL Error  : Got error 28 from table handler
Error Number : 1030
Date         : Sunday, March 19th 2006 @ 09:36:59 AM
Script       : http://www.gamehaxs.com/
Referrer     : 
IP Address   : ********
Username     : ********
Classname    : vb_database
im getting this error on my cmps_index.php (vBadvanced CMPS)

and i get this error on my index.php page...

Code:
Database error in vBulletin 3.5.2:

Invalid SQL:
SELECT *
						FROM photoplog_fileuploads
						WHERE moderate = 0
						ORDER BY RAND()
						LIMIT 5;

MySQL Error  : Got error 28 from table handler
Error Number : 1030
Date         : Sunday, March 19th 2006 @ 09:38:02 AM
Script       : http://www.gamehaxs.com/index.php
Referrer     : 
IP Address   : *******
Username     : *******
Classname    : vb_database
I would appericiate it, if someone could help me out!

Thanks in advanced,
andrew
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 12:06 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.03525 seconds
  • Memory Usage 2,159KB
  • Queries Executed 13 (?)
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
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (2)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)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_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
  • 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