error was encountered during execution of the query

[cnczone]

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?

A spider most likely.

[cnczone]

Thanks that's real helpful.

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.

[cnczone]

Anyone clicking on the picture is causing the error not a spider indexing the page.

[cnczone]

When the page loads their are errors on the page.

url please.

[cnczone]

http://cnczone.com/gallery

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?

[Chuck S]

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

// Main vBulletin Javascript Initialization
vBulletin_init();


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

<script type="text/javascript" src="clientscript/vbulletin_global.js"></script>
<script type="text/javascript" src="clientscript/vbulletin_menu.js"></script></head>


Alter that in your template file I meantioned and your java error will go away

[cnczone]

Look on the bottom left of your browser you will see a ! mark click on that and you will see the error.

As he said, that's the javascript error which is caused by not properly editing your vB.

That has NOTHING to do with the error message you started this thread with.

[cnczone]

So I need to change the clientscript to my path to that javascript lovation?

<script type="text/javascript" src="clientscript/vbulletin_global.js"></script>
<script type="text/javascript" src="clientscript/vbulletin_menu.js"></script></head>

That is correct, "clientscript/vbulletin_menu.js" is not a full path.