Columns in mysql base

[Anatol_K]

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.

[SKaero]

You need to update the Roundcube database, run the <RC root>/bin/updatedb.sh script.

[Anatol_K]

Thanks, I did it same by adding

 ALTER TABLE `session` ADD `expires_at` DATETIME;

Because in freebsd can't find updatedb.sh script.

[Anatol_K]

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 ?

[Anatol_K]

All solved. Syntax is correct:

./bin/updatedb.sh --dir=./SQL --package=roundcube