CKEditor, uploading media not work with PostgreSQL

[Bomere]

Hi,

I installed symfony-cmf and the bundle SimpleCms.

At start, I'm using SQLite as Database, just for testing. All working nice ! Now, I have migrated to PostgreSQL and everything seems to work well except images.

When I send an image with CKEditor, I get a success message. But when the image is displayed, it is problematic. Returning to the url of the image, I see the following error:

Someone would have an idea? Is there a special configuration for PostgreSQL ?

Thank's

[dbu]

first step: try to open that url directly and see if there is an error message by symfony instead of an image. maybe that will help you see what is wrong. if not, tell us what the error is.

[Bomere]

When I opened the url, I see the error message that is in my previous post. "L'image << ... >> ne peut être affichée car elle contient des erreurs." "Image can't be showed because it contains errors"

In the log file, nothing. Only info:

[2014-09-22 09:44:40] doctrine_phpcr.INFO: getNode {"params":["/cms/media/25d7df220f.jpg_ [...]"],"env":{"fetchDepth":0}} []
[2014-09-22 09:44:40] doctrine_phpcr.INFO: getNode {"params":["/cms/media/25d7df220f.jpg_ [...]"],"env":{"fetchDepth":0}} []
[2014-09-22 09:44:40] doctrine_phpcr.INFO: getNodes {"params":[{"/cms/media":"/cms/media","/cms/media/25d7df220f.jpg_1411045142_996953244.jpg/jcr:content":"/cms/media/25d7df220f.jpg_1411045142_996953244.jpg/jcr:content"}],"env":{"fetchDepth":0}} []
[2014-09-22 09:44:40] doctrine_phpcr.INFO: getNodes {"params":[{"/cms/media":"/cms/media","/cms/media/25d7df220f.jpg_1411045142_996953244.jpg/jcr:content":"/cms/media/25d7df220f.jpg_1411045142_996953244.jpg/jcr:content"}],"env":{"fetchDepth":0}} []
[2014-09-22 09:44:40] doctrine_phpcr.INFO: getBinaryStream {"params":["/cms/media/25d7df220f.jpg_ [...]"],"env":null} []
[2014-09-22 09:44:40] doctrine_phpcr.INFO: getBinaryStream {"params":["/cms/media/25d7df220f.jpg_ [...]"],"env":null} []
[2014-09-22 09:44:40] doctrine.DEBUG: SELECT id FROM phpcr_nodes WHERE path = ? AND workspace_name = ? ["/cms/media/25d7df220f.jpg_ [...]","default"] []
[2014-09-22 09:44:40] doctrine.DEBUG: SELECT data, idx FROM phpcr_binarydata WHERE node_id = ? AND property_name = ? AND workspace_name = ? [425,"jcr:data","default"] []

[Bomere]

It seems that this is the same problem of topic #109

[Bomere]

Now, I'm working on a linux with PostgreSQL and it works !

I think the problem is that I use a mac (libpq is an older version or anything else ... ?)