search

ladiaria / utopia-cms

Utopía is an open source platform for community based newsrooms to manage their subscriptions. Code repository for the CMS tool.
BSD 3-Clause "New" or "Revised" License
17 stars 6 forks source link

Minimum version of mariadb required #11

Open anibalpacheco opened 3 years ago

anibalpacheco commented 3 years ago

Check the minimum version needed of mariadb, (10.5.1 is ok)

yzeballos commented 3 years ago

MySql version 8.0.22 probably is not enough, because on main page load, an error like this will arise:

DatabaseError at / (1055, "Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'ldsocial_ene_2021.core_edition.date_published' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by")

Nevertheless there is a way to bypass this, set sql_mode (sql runtime variable) to blank: $ mysql -u root -p mysql> SET GLOBAL sql_mode = ''; This is not recommended of course (further information: https://codeascraft.com/2013/03/19/the-perils-of-sql_mode/)