Hi list,
I've just started playing with RoundCube, looks great so far..!
I can't see a list archive, so maybe some of this has already been discussed, but I'm seeing some issues using RoundCube with a pgsql database:
Some of the queries use backticks to quote column names - pgsql uses double quotes. Given that "default" is a bit of a tricky name to use for a column, is it worth renaming it, rather than doing lots of tricky code to make sure the quotes are right for the database? The same probably goes for column names like "language" and "reply-to".
My install of PostgreSQL (v8.0.1) doesn't have a function named unix_timestamp(). I hacked one up as: CREATE OR REPLACE FUNCTION unix_timestamp(TIMESTAMP WITH TIME ZONE) RETURNS INTEGER AS ' BEGIN RETURN round(EXTRACT( EPOCH FROM $1 )); END; ' LANGUAGE 'plpgsql';
I get errors if I leave caching enabled - I've just turned it off for now, but I'm guessing that the serialised data contains something that pgsql doesn't like.
Amongst the spam and assorted junk that is my inbox, I have a message with no Date header. RoundCube generated errors for that too. The following seems to do the trick:
--- program/include/main.inc.orig +++ program/include/main.inc @@ -890,7 +890,9 @@ { global $CONFIG, $sess_user_lang;
- if (is_numeric($date))
- if ($date == "")
- return "";
- elseif (is_numeric($date)) $ts = $date; else $ts = strtotime($date);
Cheers,
Steve Bennett