Error Opening Large Images

[sporthorsebreeder]

When viewing a listing if I click on the image to see the large image I receive the following error.


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 C:\Websites\tbdiaries\includes\classes\database\my sql.php on line 119

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 C:\Websites\tbdiaries\includes\classes\database\my sql.php on line 119


I carried out the fix recommended by Eric more large image errors
Here is the fix. Open the template file user/userlistinginfo.tpl.php and replace everything with this:

Which I did, but it has not made any difference.
I only replaced the text in the userlistinginfo.tpl.php file in the template I was using.
Do I need to replace the text in all of the userlistinginfo.tpl.php files in the other templates not being used?

If not any idea what else to change to fix it?
Thanks
Hugh

[frosty]

Hi Hugh - did you see this thread-->
Thumbnails in ads give popup window w/ error

I fought this one problem too and got it sorted out between the post you refered to and this one above.

[sporthorsebreeder]

Hello Frosty
Thanks for the info.
That was helpful.
Eric said

This is an easy fix.
First copy the stock viewimage template over to the new template directory.
Next copy all the images in the images/ directory and put them in templates/yourtemplate/images/ directory. I moved these out for v3.1 that way you could have different images for different templates.

I have copied the images from the image directory to my template images directory, but I cant find the "stock viewimage template" that Eric said to copy over to the new template.
Can anyone tell me which folder it is in?
Many thanks
Hugh

[sporthorsebreeder]

I have copied the images from the image directory to my template images directory, but I cant find the "stock viewimage template" that Eric said to copy over to the new template.
Can anyone tell me which folder it is in?

Eric
Can you tell me where to find the stock view image template?
Thanks
Hugh

[Eric Barnes]

In v3.1 it has the template editor. So just browse to the viewimage.tpl.php and click the compare button and it will show you the differences.