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.