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

Quote:
Originally Posted by Fenriz View Post
Onec a day I get the next error (below). How can I fix it?
PHP Code:
Database error in vBulletin 3.8.4:

Invalid SQL:
SELECT dl_files.*,  dl_cats.name catname FROM dl_filesdl_cats WHERE  (OR dl_files.author LIKE '%Discr?tisations variationnelles de probl?mes aux limites elliptiques%' OR dl_files.name LIKE '%Discr?tisations variationnelles de probl?mes aux limites elliptiques%' OR dl_files.description LIKE '%Discr?tisations variationnelles de probl?mes aux limites elliptiques%'
                                                                        AND 
dl_files.category dl_cats.id
                                                                        ORDER BY catname
dl_files.name;

MySQL Error   Unknown column 'y' in 'where clause'
Error Number  1054
Request Date  
FridayOctober 30th 2009 03:39:39 AM
Error Date    
FridayOctober 30th 2009 03:39:39 AM
Script        
http://forum.com/downloads.php?do=search
Referrer      http://forum.com/downloads.php?do=search
IP Address    : ***
Username      Unregistered
Classname     
vB_Database_MySQLi
MySQL Version 

btw, MySQL database version 5.1.41
That's the search query, but it isn't executed every day. Rather every time someone does a search. There's nowhere an "y" in it, there's even no variable to get something in there.

Can you pm me your site url (and login information for the downloads section)?

Quote:
Originally Posted by Hovard View Post
After installation and run http://www.mysite.com/forum/downloads.php I see message


admin, you do not have permission to access this page. This could be due to one of several reasons:

1. Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
2. If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
You need to set your DownloadsII usergroup permissions to have access to the downloads section.

Quote:
Originally Posted by joyceleong View Post
Hi Welshy, I am still get a white page once I upload the image, and the image does not show up on the Download sections, but when I check the download folder on my hosting, it shows that the uploaded file is there.

I have checked on the Usergroup Permissions, I have got the option under Downloads II Permission "Can Upload Images" marked as Yes, any other options do I need to enable as well?

Thanks.
That seems to be a server issue. Can you pm me your site url (and login information for the downloads section)?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03000 seconds
  • Memory Usage 1,795KB
  • 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_php
  • (3)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