ActiveRecord::StatementInvalid (Mysql2::Error: Unknown column 'updated_on' in redmine 4.0.3
Added by Leon C over 5 years 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 over 5 years ago
It works if I use mysql instead of MariaDB. What should be done differently if one is using MariaDB?