Hi all,
I've been having a considerable deal of difficulty making the latest release of Roundcube play nice with PostgreSQL. After fixing up my own stuff ups with permissions (it kinda helps if the database user actually has permission to look at the table you want to select from ;-)), I found that postgres.initial.sql is missing the 'ip' column (from the 'session' table). Doing the below fixed this for me:
ALTER TABLE session ADD ip character varying(15) NOT NULL; ALTER TABLE session ALTER COLUMN ip SET DEFAULT ''::character varying;
However, it's still not working, and the current problem has got me stumped. I think it's due to the php being used, but my code-foo ain't that good. I receive this in the browser:
-----ooooo----- DB Error in /var/www/roundcubemail/program/include/rcube_db.inc (124): DB Error: unknown error DB Error in /var/www/roundcubemail/program/include/rcube_db.inc (210): DB Error: unknown error Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='74bfac980c44f3d2db46c4b0c49d22f0'
Fatal error: Call to a member function on a non-object in /var/www/roundcubemail/program/include/rcube_db.inc on line 202 -----ooooo-----
.and in the Postgres log I get this:
-----ooooo----- 2005-10-12 16:49:16 [15138] ERROR: function unix_timestamp(timestamp with time zone) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. -----ooooo-----
Um ... any ideas? Google hasn't been especially useful, save referring to PHP information that I don't pretend to understand. What other information can I provide that would be useful?
Many thanks.
~ z.