Hi all!
After upgrade roundcube to 1.7.1 get error:
DB Error: [1054] Unknown column 'expires_at' in 'INSERT INTO' (SQL Query: INSERT INTO `session` (`sess_id`, `vars`, `ip`, `expires_at`) VALUES ('...', '...', '10.10.0.1', now() + INTERVAL 36000 SECOND)) in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db.php on line 553 (GET /mail/)
what type of column 'expires_at' I must insert to db?
Upgrade from ports in freebsd.
You need to update the Roundcube database, run the <RC root>/bin/updatedb.sh script.
Thanks, I did it same by adding
ALTER TABLE `session` ADD `expires_at` DATETIME;
Because in freebsd can't find updatedb.sh script.
And another error appear:
DB Error: [1146] Table 'roundcubemail.uploads' doesn't exist (SQL Query: SELECT * FROM `uploads` WHERE `session_id` = '...' AND `group` = '...' ORDER BY `created`) in /usr/local/www/roundcube/program/lib/Roundcube/rcube_db.php on line 553 (POST /mail/?_task=mail&_from=compose&_id=...&_uploadid=...&_action=upload)
and well, I find updatedb.sh - when run it, error:
ERROR: Database schema directory not specified (--dir)
running with --dir=SQL --package=roundcube, error:
ERROR: Specified database schema directory doesn't exist.
What is correct syntax for updatesb.sh ?
All solved. Syntax is correct:
./bin/updatedb.sh --dir=./SQL --package=roundcube