Thread: Major Additions - Links and Downloads Manager
View Single Post
  #1763  
Old 03-28-2009, 06:16 PM
sparklywater sparklywater is offline
 
Join Date: Jun 2008
Posts: 248
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hello Andrew,

I sometimes get these database errors when trying to access LDM pages. I don't know what exactly is causing these errors. Here is an example of one of these error-messages:

Code:
Database error in vBulletin 3.7.2:
 
Invalid SQL:
 
		SELECT
			link.linkid AS linkid, link.linkname AS linkname, link.linkdoi AS linkdoi,
			link.linkuserid AS linkuserid, link.linkusername AS linkusername,
			link.linkurl AS linkurl, link.linkimg AS linkimg,
			link.linkimgthumb AS linkimgthumb, link.linkimgthumbsize AS linkimgthumbsize, link.linkforum AS linkforum,
			link.linkdesc AS linkdesc, link.numrate AS numrate, link.totrate AS totrate,
			link.linkhits AS linkhits, link.linksize AS linksize, link.linkstatus AS linkstatus,
			link.linkdate AS linkdate, link.linkmoderate AS linkmoderate, link.linkmoddate AS linkmoddate,
			link.linkreviewfreq AS linkreviewfreq,
			ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder
			, user.*, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight
			
			
			, lkeys.keyword AS linkkey
			FROM local_linkslink AS link
			LEFT JOIN local_linksltoc AS ltoc ON link.linkid = ltoc.linkid
			LEFT JOIN user AS user ON (user.userid = link.linkuserid)
			LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
			LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
	
			LEFT JOIN local_linksltok AS ltok
			ON link.linkid = ltok.linkid
			LEFT JOIN local_linkskeys AS lkeys
			ON ltok.keyid = lkeys.keyid
		 WHERE link.linkforum NOT IN (0)  AND ltoc.catid = '2'  AND link.linkmoderate = 0 
			ORDER BY linkdorder ASC,   linkname ASC,  linkcatid ASC;
 
MySQL Error   : Got error -1 from storage engine
Error Number  : 1030
Request Date  : Saturday, March 28th 2009 @ 12:18:05 PM
Error Date    : Saturday, March 28th 2009 @ 12:18:06 PM
Script        : http://www.sparklywater.com/category/2.html
Referrer      : http://www.sparklywater.com/
IP Address    : 69.117.150.25
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01173 seconds
  • Memory Usage 1,769KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete