Thread: Major Additions - DownloadsII
View Single Post
  #3720  
Old 07-01-2009, 12:39 PM
RS_Jelle RS_Jelle is offline
 
Join Date: Jul 2005
Posts: 1,276
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by chris82 View Post
Could u explain little more detail? Have not being able to find.
AdminCP -> Styles & Templates -> Style Manager -> Style dropdown menu of your style -> Main CSS

Quote:
Originally Posted by BozzaJos View Post
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
I can't tell you a lot more than the error says. If the table is crashed, you need to try repairing it. Try doing this with phpMyAdmin.

As the dl_downloads table is only a log table, you could drop it and recreate it (with all its fields).

Quote:
Originally Posted by paul41598 View Post
One other question. How secure is the file based version of this? My files are being stored on the host itself and not on the database. I can access my file and open it if I put in the path manually. I have classified information, and I'm thinking I should utilize the DB for this. Right?
DownloadsII isn't meant for classified information. It's just a community mod, not something for NASA
You could guess indeed the file url's.

Quote:
Originally Posted by SSG.D View Post
Hi! Thanks for the mod and your work.

I have a issue with adding to my .htaccess file: When I put
Code:
php_value upload_max_filesize 40M
php_value post_max_size 40M
in the file, my web site will not display, I get a server config error page.

This is what my .htaccess file looks like now
Code:
# -FrontPage-

IndexIgnore .htaccess */.??* *~ *# */HEADER* */README* */_vti*

<Limit GET POST>
#The next line modified by DenyIP
order allow,deny
#The next line modified by DenyIP
#deny from all
allow from all
</Limit>
<Limit PUT DELETE>
order deny,allow
deny from all
</Limit>
AuthName mysite.net
AuthUserFile /home/mysite/public_html/_vti_pvt/service.pwd
AuthGroupFile /home/mysite/public_html/_vti_pvt/service.grp

 
<Files 403.shtml>
order allow,deny
allow from all
</Files>
Can someone give me a hand? or give me a better example of a .htaccess file used in the forum root?
Thanks for any help
This could be due to your hosting configuration, so ask your webhosting company
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01113 seconds
  • Memory Usage 1,786KB
  • 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
  • (3)bbcode_code
  • (4)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