View Single Post
  #1089  
Old 05-16-2005, 08:44 AM
Slave's Avatar
Slave Slave is offline
 
Join Date: Nov 2001
Posts: 439
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

++++ .. I was happily adding links to my db and I suddenly get the following error message ..

Code:
Database error in vBulletin 3.0.3:

Invalid SQL: 
		SELECT DISTINCT link.linkid AS linkid, link.linkname AS linkname, link.linkuserid AS linkuserid,
			link.linkusername AS linkusername, link.linkurl AS linkurl, link.linkimg AS linkimg, link.linkdesc AS linkdesc,
			link.linkhits AS linkhits, link.linkstatus AS linkstatus, link.linkdate AS linkdate,
			link.linkmoderate AS linkmoderate,
			ltoc.catid AS linkcatid, ltoc.displayorder AS linkdorder, ltoc2.catid AS linkcatid2
		FROM (local_linkslink AS link
		LEFT JOIN local_linksltoc AS ltoc
		ON link.linkid = ltoc.linkid)
		LEFT JOIN local_linksltoc AS ltoc2
		ON link.linkid = ltoc2.linkid
		WHERE
			ltoc.catid = '6' 
			AND link.linkforum NOT IN (0)
		
		ORDER BY linkdorder ASC, linkname ASC,  linkcatid ASC
		
mysql error: Can't open file: 'local_linkslink.MYD'. (errno: 145)

mysql error number: 1016

Date: Monday 16th of May 2005 10:40:41 AM
Script: /local_links.php?catid=6
Referer: /local_links.php?action=links&catid=-1
Username: Slave
IP Address: 81.433.23.12
So I go and have a look at the local_linkslink table within the db and it's empty! and semingly corrupted ..



So a quick reminder to peeps to keep things backed up .. just in case! Luckily I've got a backup from a few days ago I think so it's not too bad ..

AndrewD .. anything in the code that would cause this? .. or have you heard anything like that before?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01325 seconds
  • Memory Usage 1,766KB
  • 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