1 Topic by Anatol_K

  • Anatol_K
  • Member
  • Offline
  • Registered: 2022-04-20
  • Posts: 3

Topic: Column in rondcube

==== REQUIRED BASIC INFO OF YOUR IREDMAIL SERVER ====
- iRedMail version (check /etc/iredmail-release):
- Deployed with iRedMail Easy or the downloadable installer?
- Linux/BSD distribution name and version:
- Store mail accounts in which backend (LDAP/MySQL/PGSQL):
- Web server (Apache or Nginx):
- Manage mail accounts with iRedAdmin-Pro?
- [IMPORTANT] Related original log or error message is required if you're experiencing an issue.
====

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.

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2 Reply by Anatol_K

  • Anatol_K
  • Member
  • Offline
  • Registered: 2022-04-20
  • Posts: 3

Re: Column in rondcube

Solved by adding

ALTER TABLE `session` ADD `expires_at` DATETIME;