ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'updated_on' in redmine 4.0.3

Added by Leon C 5 months ago

Hello, I'm trying to install redmine on Ubuntu 18.04 LTS using MariaDB and nginix following this guide
https://linuxize.com/post/how-to-install-and-configure-redmine-on-ubuntu-18-04/

nginix -t validates

When I access redmine site I get an error telling me to check log files. Nginix error log files give nothing. Redmine log files give:

ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'updated_on' in 'field list': SELECT MAX(updated_on) FROM `settings`):

When I check table i get:

MariaDB [redmine]> show columns from settings;
+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| name  | varchar(30) | NO   |     |         |                |
| value | text        | YES  |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

I'm using MariaDB 10.1.38-MariaDB-0ubuntu0.18.04.1

Is there some module I'm missing?

Replies (1)

RE: ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'updated_on' in redmine 4.0.3 - Added by Leon C 5 months ago

It works if I use mysql instead of MariaDB. What should be done differently if one is using MariaDB?

(1-1/1)