Bugs like this come and go?

[jcruise]

Any idea why I get these email error alerts in waves, flooding my email box in waves and then they go away only to return?


An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,date,title,description,ismature,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,votes,allowprint,numcom,lastposter FROM pp_photos WHERE userid= AND storecat=0 ORDER BY disporder,bigimage 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 storecat=0 ORDER BY disporder,bigimage DESC' at line 1

[Chuck S]

well I could not explain that error based on looking at the code

Basically that query is only located in one place in the program showgallery.php

Content visible to verified customers only.

It is the query to grab the photos and the where userid clause only is ran if is_numeric ppuser variable is found as shown. Therefore it would never be empty so I can not understand why your userid variable is empty.