Datetime format issues preventing objects from being saved

[Aline (OpenERP)]

trunk, web, firefox, french db, install crm

Cannot create a phone call because of the date format (invalid).

[claude dunnigan (claudedunnigan)]

rc2, unbuntu server 11 lts, french language
outbound works fine
inbound on web , trying to writhe the date twice, works on gtk client

[Xavier (Open ERP) (xmo-deactivatedaccount)]

@claude:
Ubuntu Server 11 LTS? Don't you mean 10.4? As far as I know the LTS releases so far are 6.06, 8.04 and 10.04, there is no LTS in the 11.x series (in fact, there is no 11.x series release yet)

[Vadim - Enapps LTD (vadim-enapps)]

guys, tell me please where is the fix released, so I can update and give feedback

[Xavier (Open ERP) (xmo-deactivatedaccount)]

On the Open ERP server

[Vadim - Enapps LTD (vadim-enapps)]

updated the server, client and webclient and exactly the same thing.

[Xavier (Open ERP) (xmo-deactivatedaccount)]

Did you create a *new* database after updating the server?

[Vadim - Enapps LTD (vadim-enapps)]

nope, sorry. I will do that. Will updating the base module fix this for existing databases?

[Aline (OpenERP) (apr-tinyerp)]

Works for me now, after creating a new database

[pitititi (pitititi)]

how can we do to update an existing database ?
make a sql command or only the module ?

[Vadim - Enapps LTD (vadim-enapps)]

yep, with a new database it works for me as well. I also managed to get it working on an existing instal by changing the res_lang setting - thanks.

[OpenBMS JSC (openbmsjsc)]

Still have problems with it (see attachment)

addons/ : <email address hidden> 4234
addons-community/ : <email address hidden> 295
addons-extra/ : launchpad_translations_on_behalf_of_openerp-commiter-20110113051127-wt1kd3lzj27dyt0y 5158
client/ : launchpad_translations_on_behalf_of_openerp-20110113044104-b4wuyrgyelfv1mx4 1772
server/ : launchpad_translations_on_behalf_of_openerp-20110113044043-ezsi3rqpbxq13pu2 3256
web/ : <email address hidden> 4321

[OpenBMS JSC (openbmsjsc)]

I think this should marked as Critical/Blocker as a lot of people cannot move on with any fields of type dates

[Naresh(OpenERP) (nch-openerp)]

Hello Phong,

we would like to know that after updating server, did you create new database ? because according to the screenshot you provided in comment #13 the time format has %T shown and which has been fixed at server in the recent revisions but for that you need to create new database.

secondly which locale have you installed ?

Thanks,

[Naresh(OpenERP) (nch-openerp)]

and one more thing
can you tell what is the date and time format shown in your administration/Translation/Language and the language that you have selected for your user.

Thanks,

[Olivier Dony (Odoo) (odo-openerp)]

For the record, this was fixed in the server to remove unsupported format pattern during the installation of a new language.
The correction was introduced in server revision 3238 <email address hidden>, and further improved in revision 3250 <email address hidden>.

For existing databases, please first update to a server revision after 3250, then modify your existing language entries by making sure that the date format and time format fields only contain allowed directives (%H, %M, etc.).
The allowed directives are displayed on the form view, and the server will not allow you to save your language with a format that uses unsupported directives.

If you are unsure how to correct your current formats, you can create a new database and look at the format that is now being used for your language. Alternatively you can also refer to the technical manual of the strftime function, to see the equivalence of your current directives with the allowed ones: http://bit.ly/g3d8dk for example %T => %H:%M:%S

After correcting all res.lang entries, please restart the server and all your clients, and you should be fine.

[Olivier Dony (Odoo) (odo-openerp)]

When I say "modify your existing language entries" in previous comment, I mean go to Administration>Translations>Languages, where you can edit the languages that are installed in your database.

[Naresh(OpenERP) (nch-openerp)]

Hello phong,

Please follow the steps as mentioned in the comments of Olivier and me.
I would close this bug and you still face the problem do not hesitate to reopen the bug.

Thanks,

[OpenBMS JSC (openbmsjsc)]

I updated the res_lang table (time_format) and it's ok. Thanks