Content
You are here:
Polish letters - Internal error: An error occurred on the page you were trying to access.
Added by Marcin Sq over 7 years ago
Hello,
I’ve problem with using OpenProject using polish letters. When I try to write anything with polish letters and save it, I’ve got error message:
Internal error
An error occurred on the page you were trying to access.
If you continue to experience problems please contact your OpenProject administrator for assistance.
If you are the OpenProject administrator, check your log files for details about the error.
———————————————————————
There is such information in production.log: W, [2017-07-24T16:04:35.066448 #27847] WARN -- : You are setting a key that conflicts with a built-in method OmniAuth::Strategy::Options#display defined in Kernel. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method. W, [2017-07-24T16:04:35.067659 #27847] WARN -- : You are setting a key that conflicts with a built-in method OmniAuth::Strategy::Options#display defined in Kernel. This can cause unexpected behavior when accessing the key via as a property. You can still access the key via the #[] method. F, [2017-07-24T16:04:35.110384 #27847] FATAL -- : F, [2017-07-24T16:04:35.110511 #27847] FATAL -- : ActiveRecord::StatementInvalid (Mysql2::Error: Incorrect string value: '\xC5\x9Blani...' for column 'name' at row 1: UPDATE `statuses` SET `name` = 'W trakcie określania' WHERE `statuses`.`id` = 2): F, [2017-07-24T16:04:35.110559 #27847] FATAL -- : F, [2017-07-24T16:04:35.110624 #27847] FATAL -- : app/controllers/statuses_controller.rb:69:in `update' app/middleware/reset_current_user.rb:47:in `call'
Can anybody tell me how can I fix it?
Regards
Marcin
Replies (3)
Seems to be the same as
Thanks Jens!
That is! I’ve repair this error by converting database and each of tables from latin1_… to utf8.
1. Log into MySQL
2. Make sure what is default character set of database
how to check the names of databeses:
how to check (short) list of tables:
3. Make sure what is char set of columns
4. Change database char set to utf8
5. Change each of tables charakter set to utf8
(I’ve made it not in the fastest, but easiest way by changing name of tables - I’ve used MS Excel to produce lines of instructions and later put them into console comand line)
Final effect is that everything works! Despite this this bug needs to be solved in next version of OP.
Good luck!
Glad to hear that Marcin and thanks for detailing the solution so that other users can benefit from your findings.