Error message when clicking on photos

[falcon]

When clicking on the photos of any of the ads at

http://www.australianinvestmentprope...ngs.php?pg=new

to see the large version of the photos these error messages show:

Notice: Query failed: 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 '' at line 1 SQL: SELECT id,pid,title,image FROM class_prodimages WHERE id > 0 AND pid = in /home/aip/public_html/includes/classes/database/mysql.php on line 0

Notice: Query failed: 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 '' at line 1 SQL: SELECT id,pid,title,image FROM class_prodimages WHERE id < 0 AND pid = in /home/aip/public_html/includes/classes/database/mysql.php on line 0


I am running version 3.1.7 and have already tried replacing the includes/init.php and the includes/classes/database/mysql.php
file with the latest versions from version 3.1.10

but the error messages still show. Please advise.

[Lhotch]

I think I remember seeing this error posted somewhere here before I will se if I can find it.

On a side note, I really dont recommend updating just one or two files from a newer release without doing the complete upgrade and running the upgrade script. It may work, and you may also totally trash things.

[falcon]

Thanks, I replaced the viewlisting.tpl and viewimage.tpl files and its working again now.