mysql 8

[ashrafalzyoud]

redmine@redmine:~/redmine-5.1$ bundle exec rake redmine:plugins:migrate RAILS_ENV=production
== 1 AddReadByUsersToJournals: migrating ======================================
-- add_column(:journals, :read_by_users, :text, {:default=>"{}", :null=>false})
rake aborted!
StandardError: An error has occurred, all later migrations canceled: (StandardError)

Mysql2::Error: BLOB, TEXT, GEOMETRY or JSON column 'read_by_users' can't have a default value
/home/redmine/redmine-5.1/plugins/redmine_advanced_messenger/db/migrate/001_add_read_by_users_to_journals.rb:5:in `change'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:482:in `up'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:518:in `migrate_plugin'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:455:in `migrate'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:469:in `block in migrate'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:468:in `each'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:468:in `migrate'
/home/redmine/redmine-5.1/lib/tasks/redmine.rake:151:in `block (3 levels) in <top (required)>'
/home/redmine/.rbenv/versions/3.2.4/bin/bundle:25:in `load'
/home/redmine/.rbenv/versions/3.2.4/bin/bundle:25:in `<main>'

Caused by:
ActiveRecord::StatementInvalid: Mysql2::Error: BLOB, TEXT, GEOMETRY or JSON column 'read_by_users' can't have a default value (ActiveRecord::StatementInvalid)
/home/redmine/redmine-5.1/plugins/redmine_advanced_messenger/db/migrate/001_add_read_by_users_to_journals.rb:5:in `change'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:482:in `up'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:518:in `migrate_plugin'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:455:in `migrate'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:469:in `block in migrate'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:468:in `each'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:468:in `migrate'
/home/redmine/redmine-5.1/lib/tasks/redmine.rake:151:in `block (3 levels) in <top (required)>'
/home/redmine/.rbenv/versions/3.2.4/bin/bundle:25:in `load'
/home/redmine/.rbenv/versions/3.2.4/bin/bundle:25:in `<main>'

Caused by:
Mysql2::Error: BLOB, TEXT, GEOMETRY or JSON column 'read_by_users' can't have a default value (Mysql2::Error)
/home/redmine/redmine-5.1/plugins/redmine_advanced_messenger/db/migrate/001_add_read_by_users_to_journals.rb:5:in `change'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:482:in `up'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:518:in `migrate_plugin'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:455:in `migrate'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:469:in `block in migrate'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:468:in `each'
/home/redmine/redmine-5.1/lib/redmine/plugin.rb:468:in `migrate'
/home/redmine/redmine-5.1/lib/tasks/redmine.rake:151:in `block (3 levels) in <top (required)>'
/home/redmine/.rbenv/versions/3.2.4/bin/bundle:25:in `load'
/home/redmine/.rbenv/versions/3.2.4/bin/bundle:25:in `<main>'
Tasks: TOP => redmine:plugins:migrate
(See full trace by running task with --trace)

[cristian-spiescu]

Unfortunately there is no support for MySQL. I updated the README.md to be more explanatory in this matter. We'd gladly review and accept PRs that would add such support.

[ashrafalzyoud]

Are there in your plan support mysql

Get Outlook for Androidhttps://aka.ms/AAb9ysg

---

From: Cristian Spiescu @.> Sent: Friday, September 13, 2024 3:26:10 PM To: famiprog/redmine_advanced_messenger @.> Cc: ashrafalzyoud @.>; Author @.> Subject: Re: [famiprog/redmine_advanced_messenger] mysql 8 (Issue #33)

Unfortunately there is no support for MySQL. I updated the README.md to be more explanatory in this matter. We'd gladly review and accept PRs that would add such support.

— Reply to this email directly, view it on GitHubhttps://github.com/famiprog/redmine_advanced_messenger/issues/33#issuecomment-2348834276, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AL7CU7347TRKPDWVPL67IFDZWLKWFAVCNFSM6AAAAABOFHF76KVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDGNBYHAZTIMRXGY. You are receiving this because you authored the thread.Message ID: @.***>

[cristian-spiescu]

For the moment no. This product is a tool that we've created primarily for us; however w/ an open-source mindset, including documentation. Supporting of other DBs implies tasks that exceed our budget of time that we have allocated for this project.