Postgresql error on edit user information
| Project: | User Maintenance |
| Version: | HEAD |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Hello,
I am using Drupal 6.9.
When I tried to edit user information the timezone field size is higher than what is defined in user.install. If you see the query, the timezone size is = 9 and in the user.install = 8. I don't know if the query was generated incorrectly or the size of this field is incorrect. Any ideas?
If I select NULL for timezone field on user edit page I can update the information without any problems.
The log below with some XXX to hide information about the server...
* warning: pg_query() [function.pg-query]: Query failed: ERROR: value too long for type character varying(8) in /XXX/drupal-6.9/includes/database.pgsql.inc on line 139.
* user warning: query: UPDATE users SET language = 'pt-br', theme = '', name = 'globalx', mail = 'XXX@XXX.com', status = '1', timezone = '140|-7200', timezone_name = 'America/Sao_Paulo', data = 'a:4:{s:7:"contact";i:1;s:14:"picture_delete";s:0:"";s:14:"picture_upload";s:0:"";s:13:"form_build_id";s:37:"form-e5f71146108141a0f1edf632c973578e";}' WHERE uid = 3 in /XXX/drupal-6.9/modules/user/user.module on line 247.
Bye,
Global