Thread: Major Additions - Links and Downloads Manager
View Single Post
  #848  
Old 12-14-2006, 10:05 PM
Mr_Devlin Mr_Devlin is offline
 
Join Date: Nov 2005
Posts: 84
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Searched this forum but didn't find a solution or hint on an error.
When trying to access ldm I will get this error message:


Quote:
Datenbankfehler in vBulletin 3.6.4:

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.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,
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

, COUNT(lhits.linkid) AS linkrecenthits

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_linksdownloads AS lhits
ON link.linkid = lhits.linkid
WHERE lhits.usertime>=1163547774
GROUP BY linkid, linkcatid

ORDER BY linkhits DESC;

MySQL-Fehler : Got error 28 from storage engine
Fehler-Nr. : 1030
Datum : Thursday, December 14th 2006 @ 06:42:54 PM
Skript : http://www.*****.com/forum/local_links.php?
Referrer : http://www.*****.com/forum/showthrea...3082#post13082
IP-Adresse : **.***.***.***
Benutzername : ******
Klassenname : vb_database
ldm version: 2.2.6
MySQL: 4.1.10a
PHP: 4.4.3

Changing MySQL or PHP is not possible,
Any suggestions how to solve this problem?

#################

EDIT: OK, Problem solved by repairing tables...
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01879 seconds
  • Memory Usage 1,770KB
  • 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_quote
  • (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