View Single Post
Old September 22nd, 2005, 06:56 AM   #1 (permalink)
jribz
Junior Member
Verified Customer
 
Join Date: Jan 2005
Posts: 14
Unknown table in where clause 5.14 vb 3.5rc3

I am getting emailed error reports similar to the following, version 5.14 pp with vb3.5 rc3, any ideas?

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,storeid,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,extra1,extra2,extra3,extra4,extra5,extra6,disporder,ipaddress,allowprint FROM pp_photos WHERE id=clear.gif

The query returned with an errorcode of:

Unknown table 'clear' in where clause


another example . . .

An error was encountered during execution of the query:

SELECT id,user,userid,cat,storecat,date,title,description,keywords,bigimage,width,height,filesize,views,medwidth,medheight,medsize,approved,rating,allowprint,numcom,lastposter FROM pp_photos WHERE userid=external.php ORDER BY disporder,date DESC

The query returned with an errorcode of:

Unknown table 'external' in where clause


Note: Edited to remove quote tags as they appear to mess the display of the forum. Actually, it appears that the forum is not set to wrap characters after a certain number, sorry for the scrollbars.

Last edited by jribz; September 22nd, 2005 at 06:58 AM.
jribz is offline   Reply With Quote