Thumbnails in ads give popup window w/ error

[zman78]

VERSION 3.1.0

The Popup window wont display a larger image but reads this when i click thumbnails in ads:

"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 /home2/zach3/jamestownclassifieds-www/new/includes/classes/database/mysql.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 /home2/zach3/jamestownclassifieds-www/new/includes/classes/database/mysql.php on line 119"

ANY HELP?

Zack

[Lhotch]

I beleive the viewlisting.tpl.php file changed from 3.0.x to 3.1 so if you recently upgreaded but are using the 3.0.x template that may be causing your error. Goto admin and just select a different template to see if the problem goes away. If you havent modified the viewlisting.tpl.php file you should just be able to upload the new one to your template directory.

[zman78]

Thanks! Eric was the man and helped me out. He actually did it FOR me! Another example of how great these guys are!

Zack

[garysmith]

Larry I did not see this post and opened a similar post. Would you please show just a tad bit more detail about this fix? I am having the same issue.

gsmith

[Lhotch]

If im not mistaken the contents of some of the templates changed. What that means is if you are running a template from a version 3.0.1x that you have modified with version 3.1 it can cause some problems.

If you have a customized template your using, log into the admin side of your site and goto main settings, then select one of the other templates that came with V3.1 and see if you have the same problem. You may need to clear templates_c just to make sure.

If the problem goes away, copy the file viewlisting.tpl.php from your default template folder that came with V3.1 and place it in your custom template that you want to use. Then go ahead and change your template back in admin->main settings and I beleive that will fix your problem.

[garysmith]

Hummm?

Copied different viewlisting file into my custom template and am getting the same error?

Any other ideas?

See it here:
http://ms-fsbo.com/viewlisting.php?view=3

Something else...i have 4 photos there to show and the pop-up is only picking up 3 of the images. (I tried all of the "out of the box" templates and got the same response)?

If you have a customized template your using, log into the admin side of your site and goto main settings, then select one of the other templates that came with V3.1 and see if you have the same problem. You may need to clear templates_c just to make sure.

What does this mean please? Clear? Erase all the data in that file?

gsmith

[juven14]

Looks like you are using viewlisting2.tpl.php, please make sure that is the file you are replacing.

[garysmith]

Yes...I was very careful not to edit viewlisting2...

gsmith

[Lhotch]

Originally Posted by garysmith

Yes...I was very careful not to edit viewlisting2...

gsmith

What John meant was not only do you need to copy over viewlisting.tpl.php but since you are using viewlisting2.tpl.php copy that file over from 3.1 default template as well.

[garysmith]

Hummm? ok i copied each one from 3.1 to my template...

See: http://ms-fsbo.com/viewlisting.php?view=3

It snaps the image popup to very small and the viewlisting images of printer,etc. are not locating?

gsmith