Images not getting loaded openerp webclient with postgres 9.1 in windows

same problem , to be more specific ,

I installed openerp 6.1 with 32 bit 9.1.5 postgresql on a AWS 64Bit windows 2008 Virtual machine.

Tried 64bit postgres ,

Tried restore db from postgres version of another machine where db backed up is working fine ,i.e. image
can display properly.

all not working.

Hi kalmenchia,

Can you please tell me which version of postgres DB you backed up and restored on which version. I am trying to restore a DB backed up from postgres 9.1.5 on Ubuntu server to Postgres 9.1.5 on windows 2008 server. I tried both 32 bit and 64 bit version of postgres. But doesnt works..!

Hi Rashikep.

I have tested from windows 2003 , PostgresSQL 9.1.5 to AWS windows 2008 , PostgresSQL 9.1.5 ,
i t has the same problem .

~ i have tested both 32 bit and 64 bit of postgressql on 64bit AWS windows 2008 , SAME PROBLEM
~ i have tested edit the field ,in the ir.menu table , it is also not working .

However, i can quite sure that after insllation or restore of db , the database saved into the
ir.menu fields is not correct ,

My suspect to this issue when i use Chrome to display and confirm my thoughts ,

1. data:image/png;base64,x6956424f5277304b47... , it cannot display properly.

2. data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAGQAAABkCAMAAABHPGV .... , THIS is from the working
    version which display the same image icon , SALES

as you can see that the data after BASE64 is different , so
i went to the postgresSQL field and check the content of the field ir_ui_menu.web_icon_data , and copy the
data in the field and tested it and confirmed that it restored correctly and the data CAN display the image.

so i can quite sure that OPENERP when it trying to display the content , it somehow miss interpreted the base64
image to something else.

and created bug report #1051754 , pls follow up from there.

Hi,

Go to postgresql.conf and replace the line

#bytea_output = 'hex' # hex, escape

with:
bytea_output = 'escape' # hex, escape

Regards,
-Mario

Thank you for this solution Mario, has worked fine.