Andy Burns wrote:
Sorry to list mods, previous reply was from "wrong" account ...
I couldn't see any changes to the cache table, it seems that between the value parameters passed to the insert statement and the table defaults all columns are being provided with a value, the only other constraint I can see is the reference to the session table, did I miss something else?
I decided to clean out the cache and session tables to see if that helped, it didn't fix the error, but it allowed me to see that there are no entries being added to the session table when a user logs in, so presumably that explains the constraint error ...
I've installed/upgraded my pear components to have MDB2beta6 and that hasn't helped, I now notice that many (all?) of the save operarations when editing preferences/addressbook give the error
Fatal error: Call to undefined function: affectedrows() in /var/www/roundcubecvs/roundcubemail/program/include/rcube_mdb2.inc on line 189
Does that shed any more light?