Images don't show up on product description page. HELP!!!!

[rosa_o_clifford]

Quote:
Originally Posted by rosa_o_clifford

Ok, I'm having a few problems; I can upload the images, sometimes, other times it just sits there for 10 minutes or so and attempts to upload it for the attributes and normally. Sometimes it takes me to an error code type thing but it isn't really a code its a bunch of stuff that doesn't make any since to me. But I haven't been able to replicate that problem for a few hours now. But no matter what I do the pictures won't display. I've checked under the configuration tab -- nothing works. It doesn't even display the "No Picture Available" graphic. It removes the entire area where the picture would be. I can't even add a picture normally to a product that has attributes applied to it, it just sits there attempting to load the page. Sometimes it even does it for products without attributes which is what really confused me. We have the most current version of Zen-Cart. I have modified the template a bit but only the colors and sizes. This is still a work in progress, heres the link rocpaperscissors. com /Shop
When you get there go under the "All Occasion" category. I haven't been able to get all of the pictures up yet but the ones that is having a problem that you can see is on the first page and is called "Java Joe's". The thumbnail is there but the it isn't on the product page.


Thanks,
Scott & Rosa

---------------------------------------------------------------------------
I finally got it to give me the error message again. This is what it says:


1064 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 'n Tag.jpg' where products_attributes_id = '1116'' at line 2
in:
[update ROCproducts_attributes set attributes_image = 'attributes/Bag 'n Tag.jpg' where products_attributes_id = '1116']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

I don't know what it means sooo....

Any help would be appreciated.

Thanks,
Scott & Rosa

[Get Em Fast]

Can't get there. You have the maintenance page up.

[rosa_o_clifford]

Are you sure? I isn't showing on any of my computers. Did you add the /Shop at the end. The main site has a construction page but the shop doesn't.

Scott & Rosa

[bunyip]

just a quick hint - don't use any blank spaces or special characters like apostrophes in your image filenames (eg in your example of Bag 'n Tag.jpg) ... that can cause all sorts of hard-to-track errors. Use of hypens instead of blanks is better - eg bag-n-tag.jpg
It's also a good idea to keep all characters lower-case - I've also seen mixed-case filenames cause quirks as well.

[rosa_o_clifford]

thanks I'll try that. I'll let you guys know if it works.

Scott & Rosa

[bunyip]

The java joe's image is not showing on the product info page because there's an apostrophe in the image filename that is breaking the javascript (one of the reasons not to use apostrophes)

You really need to do something about reducing the image filesizes - the thumbnail for java joe's on the listing page is 279kb - if all your image files are that large, your uploading issues are most likely script timeouts during the upload process.

[rosa_o_clifford]

That was it thanks a lot.

Scott & Rosa

[bunyip]

Suggested reading...first post on this thread