Thread: Major Additions - DownloadsII
View Single Post
  #3716  
Old 06-30-2009, 02:51 PM
BozzaJos BozzaJos is offline
 
Join Date: Feb 2006
Posts: 174
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hey guys!

Been using the Downloads mod since the very beginning but unfortunately, I just encountered a huge database error. When someone tries to download a file, a new browser page opens and the following error is displayed:

Code:
Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT time 
FROM dl_downloads 
WHERE (`userid`=1 
OR `clientip`='xxx.xxx.xxx.xx')
ORDER BY `time` DESC LIMIT 0,1;

MySQL Error   : Table 'dl_downloads' is marked as crashed and should be repaired
Error Number  : 1194
Request Date  : Tuesday, June 30th 2009 @ 05:47:32 PM
Error Date    : Tuesday, June 30th 2009 @ 05:47:33 PM
Script        : http://url/downloads.php?do=file&id=2032&act=down
Referrer      : http://url/downloads.php?do=file&id=2032
IP Address    : not important
Username      : not important
Classname     : vB_Database
MySQL Version : 5.0.77-community
Can anyone please tell me what the error is about and how to solve it? Please note that I already followed the advise of the MySQL Error but repairing the table didn't solve it. MyPHPAdmin said that the table is already uptodate.

Thank you in advance for your reply. Please consider this message urgent because this mod is by far the most important feature of my site and being without it really cripples the site.

Regards,

Bozza
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03494 seconds
  • Memory Usage 1,771KB
  • 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