Top Menu

Jump to content
Home
    Modules
      • Projects
      • Activity
      • Work packages
      • Gantt charts
      • Calendars
      • Team planners
      • Boards
      • News
    • Getting started
    • Introduction video
      Welcome to OpenProject Community
      Get a quick overview of project management and team collaboration with OpenProject. You can restart this video from the help menu.

    • Help and support
    • Upgrade to Enterprise edition
    • User guides
    • Videos
    • Shortcuts
    • Community forum
    • Enterprise support

    • Additional resources
    • Data privacy and security policy
    • Digital accessibility (DE)
    • OpenProject website
    • Security alerts / Newsletter
    • OpenProject blog
    • Release notes
    • Report a bug
    • Development roadmap
    • Add and edit translations
    • API documentation
  • Sign in
      Forgot your password?

      or sign in with your existing account

      Google

Side Menu

  • Overview
  • Activity
    Activity
  • Roadmap
  • Work packages
    Work packages
  • Gantt charts
    Gantt charts
  • Calendars
    Calendars
  • Team planners
    Team planners
  • Boards
    Boards
  • News
  • Forums

Content

General discussion
  1. OpenProject
  2. Forums
  3. General discussion
  4. Polish letters - Internal error: An error occurred on the page you were trying to access.

Polish letters - Internal error: An error occurred on the page you were trying to access.

Added by Marcin Sq almost 8 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)

RE: Polish letters - Internal error: An error occurred on the page you were trying to access. - Added by Jens Ulferts almost 8 years ago

Seems to be the same as

RE: Polish letters - Internal error: An error occurred on the page you were trying to access. - Added by Marcin Sq almost 8 years ago

Thanks Jens!

That is! I’ve repair this error by converting database and each of tables from latin1_… to utf8.

1. Log into MySQL

mysql -u root - p

2. Make sure what is default character set of database

show create database openproject;

how to check the names of databeses:

show databases; 

how to check (short) list of tables:

show tables from openproject;

3. Make sure what is char set of columns

show table status from openproject;

4. Change database char set to utf8

alter database openproject default character set utf8 collate utf8_unicode_ci;

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)

alter table openproject.<name of table> convert to character set utf8 collate utf8_general_ci;

Final effect is that everything works! Despite this this bug needs to be solved in next version of OP.

Good luck!

RE: RE: Polish letters - Internal error: An error occurred on the page you were trying to access. - Added by Jens Ulferts almost 8 years ago

Glad to hear that Marcin and thanks for detailing the solution so that other users can benefit from your findings.

  • (1 - 3/3)
Loading...