Quote:
Originally Posted by Fenriz
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_files, dl_cats WHERE (y 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 : Friday, October 30th 2009 @ 03:39:39 AM
Error Date : Friday, October 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
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
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)?