View Full Version : error was encountered during execution of the query
July 21st, 2004, 08:43 PM
SELECT id,bigimage,cat,userid,approved,storecat FROM photos WHERE cat='' AND userid= AND approved='1' ORDER BY disporder,lastpost DESC
The query returned with an errorcode of:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND approved='1' ORDER BY disporder,lastpost DESC' at line 1
What is causing this?
July 22nd, 2004, 10:06 AM
A spider most likely.
July 22nd, 2004, 10:17 AM
Thanks that's real helpful.
July 22nd, 2004, 10:19 AM
There are many threads here which discuss the exact same thing. There is no userID in the query, thus the query failed. The best we can determine it's a spider which caused the error message.
Not much else I can say. Nothing we can stop.
July 22nd, 2004, 10:55 AM
Anyone clicking on the picture is causing the error not a spider indexing the page.
July 22nd, 2004, 10:56 AM
When the page loads their are errors on the page.
July 22nd, 2004, 11:29 AM
July 22nd, 2004, 12:12 PM
July 22nd, 2004, 05:40 PM
Looking at several pic's on your site, and no error. Could you give me a link to an image which does produce this error?
July 22nd, 2004, 06:06 PM
I get no image errors
The errors on your page are do to the fact that when you altered everything per the VB FAQ on relative paths you left out a step
Your error comes from line 1244 of your code which is your VB footer
It is caused because in your header include template you have not altered the relative paths for the java script. That can easily be seen by viewing the source of your page
Alter that in your template file I meantioned and your java error will go away
July 22nd, 2004, 10:39 PM
Look on the bottom left of your browser you will see a ! mark click on that and you will see the error.
July 23rd, 2004, 01:08 AM
That has NOTHING to do with the error message you started this thread with.
July 23rd, 2004, 07:06 AM
July 24th, 2004, 11:19 AM
That is correct, "clientscript/vbulletin_menu.js" is not a full path.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.