As I only run a Postgres server at home, I have been trying to get roundcube running on postgres.
However, I am not a coder, so what would take most of you guys no time at all took me all day! But I think I'm getting somewhere.
I've attached a patch which passes an extra argument into rcube_write_cache when it's been called from rcube_imap. All it does it makes sure the sess_id variable is set when it's trying to write the the cache, otherwise a foreign key constraint is violated. I guess we could have just got rid of the constraint, but it makes sense to leave them in to me.
This is more just getting rid of error messages, but there was a lot of them, which is annoying.
The patch is in CVS diff format, hope that's ok.
Also, in the postgres SQL schema file, a column is missing in the contacts table. However when I generated a diff against it with my change, it erased the whole file and then wrote it all again (making for a large patch, well, compared to the one line change). I suspect it has something to do with line endings.
The column definition is:
changed timestamptz NOT NULL DEFAULT now(),
Insert that at line 208.
Getting the address book and settings working is next, but that will probably take me another 2 days to figure out!
Any progress on a wiki? It'd make it much easier to ask questions.
Also, has anyone considered adding documentation tags to the code? Something like PHPDoc, to make generating a class/method/variable list easier.
- Jarl Nicolson