Thread: Newest Products
View Single Post
  #247  
Old 08-25-2008, 11:53 AM
  betty4's Avatar 
betty4 betty4 is offline
 

Advanced Member
  
Join Date: Aug 2006
Posts: 75
 

Default Re: Newest Products

Quote:
Originally Posted by JWait
Did you try clearing the variable templates cache?

Thanks again for your reply. Yes. I did that today. Cache now contains 0 files so it's clean. Still have INVALID SQL: 0 : pointing to a SELECT COUNT query failure performing FROM, WHERE, AND... top of page and returning "No new products have been listed within timeframe you specified".

Seems to me the query string needs tweaking in this instance. Probably as plain as the nose on my face, but I can't figure it out even with a clear head.

Backtrace : /include/func.php:121 /include/func.php:80 /newproducts.php:143 /newproducts.php:237

See Screenshot
Attached Thumbnails
Click image for larger version

Name:	invalid_sql.jpg
Views:	158
Size:	83.4 KB
ID:	1098  
Attached Files
File Type: php func.php (202.9 KB, 81 views)
File Type: php newproducts.php (12.5 KB, 134 views)
__________________
Was 4.0.17 Gold w/3rd party modules
Now 4.5.5 Gold with core modules

Last edited by betty4 : 08-25-2008 at 12:12 PM. Reason: Added pertinent files
Reply With Quote