homepage Welcome to WebmasterWorld Guest from 107.21.163.227
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Subscribe and Support WebmasterWorld
Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
MySQL blob images not rendering in website
mysql blob not showing
mtlhd




msg:4150783
 9:00 pm on Jun 10, 2010 (gmt 0)

Hey all.
I hope someone here has encountered this before, because this is horrifically aggravating.

The web developer before me used MySQL blob columns for the web site's images, so needless to say, the headache began there.

I am in the process of a server move; moving from a Slackware 9.1 machine to a Debian 5.04 machine.

Most of the site moved over without a hitch, and the few things that were missing, PHP told me what it was.

After installing PEAR almost everything was fixed (XML support and such) except one nagging problem.
The images stored in MySQL will not display.
I have the site reading them, and it displays the broken image icon.

I installed imagemagick hoping that was the fix, but I go nothing. I looked for ways to configure it, but I can not find an answer.

To see the working site (still on the Slackware 9.1 machine) go here:
[leathergallery.com ]

The site was built on the smarty platform.

I am pretty sure it is a MySQL setting I missed.....
or perhaps APACHE server MOD I don't know about or PHP.ini file that needs turned on that I have not found.

Thanks in advance.

 

Little_G




msg:4152061
 9:32 pm on Jun 13, 2010 (gmt 0)

Hi,

What do you see when you visit the url of your image script directly in your browser?

Andrew

mtlhd




msg:4152304
 1:18 pm on Jun 14, 2010 (gmt 0)

First off, thank you so much for the reply.

It depends on the browser, in Chrome and IE, they display the broken image icon, in FF, it displays the link to the picture, but as an image.
It's crazy.

-Thanks,

mtlhd

Little_G




msg:4152369
 3:06 pm on Jun 14, 2010 (gmt 0)

Hi,

Ok, I assume your sending a Content-Type header in the PHP script, try commenting that out and see what the output is then.

Andrew

mtlhd




msg:4152424
 4:58 pm on Jun 14, 2010 (gmt 0)

THANK YOU SO MUCH!

When I commented that line out, it displayed one of the many, many, many functions was looking for a directory that did not exist!

Thank you for the idea, I don't know if I would have ever seen that otherwise.

-CHEERS!

-mtlhd

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved