| 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.
|