Hi all
I just finished an installation of RC 0.2.1.
I am using postgres 7.4.1 ; db install went smoothly, according to docs.
I have this error on logs/errors when I connect for the first time:
==== [ cut here ] ======================================================
[05-May-2009 11:10:50 +0200] DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_pgsql_5b0929dec7663e6f88ca030599ba8a998e3b74a83 (text, text, tex t) AS INSERT INTO identities (user_id, del, standard, name, email) VALUES ($1, 0, 1, $2, $3)] [Native message: ERROR: column "user_id" is of type integer but expression is of type text HINT: You will need to rewrite or cast the expression.] in [path]/program/include/rcube_mdb2.php on line 255 (POST [path]/?_task=&_action=login)
==== [ cut here ] ======================================================
Subsequent logins succeed.
Maybe it's my fault but I am not sure of what went wrong.
I would appreciate your help. Thanks.
Manuel Giorgini wrote:
I just finished an installation of RC 0.2.1.
I am using postgres 7.4.1 ;
It's 5 years old and there were many updates in 7.4 line (7.4.25).
[05-May-2009 11:10:50 +0200] DB Error: _doQuery: [Error message: Could not execute statement] [Last executed query: PREPARE mdb2_statement_pgsql_5b0929dec7663e6f88ca030599ba8a998e3b74a83 (text, text, tex t) AS INSERT INTO identities (user_id, del, standard, name, email) VALUES ($1, 0, 1, $2, $3)] [Native message: ERROR: column "user_id" is of type integer but expression is of type text
Enable sql queries debuging (in DB or rc) and you'll see how looks real query. Works for me with postgres >=8.2.
[2009-05-05 11:41], A.L.E.C:
I am using postgres 7.4.1 ;
It's 5 years old and there were many updates in 7.4 line (7.4.25).
I am aware of that. Unfortunately it's not my machine and I can't do much about that.
[Native message: ERROR: column "user_id" is of type integer but expression
is of type text
Enable sql queries debuging (in DB or rc) and you'll see how looks real
query. Works for me with postgres >=8.2.
I cannot modify postgres' configuration on the fly, because this is a production machine. How can I activate query debugging on RoundCube?
Thanks a lot for your reply and your help.
[2009-05-05 11:41], A.L.E.C:
I am using postgres 7.4.1 ;
It's 5 years old and there were many updates in 7.4 line (7.4.25).
I am aware of that. Unfortunately it's not my machine and I can't do much about that.
[Native message: ERROR: column "user_id" is of type integer but expression is of type text
Enable sql queries debuging (in DB or rc) and you'll see how looks real query. Works for me with postgres >=8.2.
I cannot modify postgres' configuration on the fly, because this is a production machine. How can I activate query debugging on RoundCube?
Thanks a lot for your reply and your help.