Welcome to WebmasterWorld Guest from

Forum Moderators: open

Message Too Old, No Replies

MySQL blob images not rendering in website

mysql blob not showing

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.
9:32 pm on Jun 13, 2010 (gmt 0)

5+ Year Member


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

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.


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

5+ Year Member


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

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


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.