Send private message

You must be logged in to send a private message.

Friends

No friends yet.

Group membership

Activity

  • Thanks a lot for your support! Unfortunately I'am stuck this that :-). I've created the DB from scratch using UTF8mb4 everywhere. Reinstalled the Elgg. But the problem persist only at my hosting. Not at local pc. In any browser.... view reply
  • Thank you @RvR and @iionly for your support! The problem is not only in the Calendar Event Plugin but in other components too. Now I've use the new database with the utf8 charset in it and receive the same error as in the previous db with... view reply
  • I am using Elgg 2.3.10 and Event Calendar plugin 2.3.2, but if I'tried to enter the Title in Cyrillic language the first symbol looks damaged. But not any Cyrillic symbol I've found only one which cause the...
    • The old thread you've linked refers to version 1.6 of Elgg. As far as I now, the DB encoding wasn't UTF8 by default back then. With a new installation of a recent version of Elgg (e.g. 2.3.x) this should no longer be a problem as the DB tables get created with UTF8 encoding.

      The problem in your case might be the encoding used by the browser. If it's not UTF8 (e.g. forced to some other encoding) there might be already a problem with the input getting saved correctly. For example the title input and also other inputs get filtered by Elgg to prevent malicious data/code getting saved in the database and displayed later on. The output of the filtered and then saved data is UTF8. But if the input was in some other encoding the conversion to UTF8 might already result in wrong characters getting saved. Or later on the browser tries to display the output (which might still be fully correct) in some other encoding and then fails to do so correctly with some characters. I would suggest to check the settings of your browser to see if there might be some encoding selected other than UTF8. Maybe changing this setting makes a difference.

    • Thanks a lot for your support! Unfortunately I'am stuck this that :-).

      I've created the DB from scratch using UTF8mb4 everywhere. Reinstalled the Elgg. But the problem persist only at my hosting. Not at local pc. In any browser. Also I've checked different code pages in Browser settings.

      And the problem only with one character 'И'. If I used 'И' anyplace at Elgg then received the two questions ?? in place. This is saved in database also as ?? and only in the place that correspond to 'И'. Placing two 'И' at any word - leads to elgg.js errors and such words did not saved.

      This is a sample of testing of Russian alphabet in both cases - https://www.awesomescreenshot.com/image/3829716/0fd60eace5e904aafb84e99b32693d9a

       

       

    • As I said in the previous reply: switching MySQL to utf8mb4 solved the same issue with russian symbols for me.

      During this error (e.g., typing красава) I got this PHP error:

      
      'DatabaseException' with message 'An exception occurred while executing 'INSERT INTO elgg_metastrings (string) VALUES (?)' with params ["\xd0\xba\xd1"]:
      
      SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'string' at row 1
      
      QUERY: INSERT INTO elgg_metastrings (string) VALUES (:string)
      
      PARAMS: Array
      (
          [:string] => РєС
      )
      ' in /vendor/elgg/elgg/engine/classes/Elgg/Database.php:446
      Stack trace:
      #0 /vendor/elgg/elgg/engine/classes/Elgg/Database.php(252): Elgg\Database->executeQuery('INSERT INTO elg...', Object(Doctrine\DBAL\Connection), Array)
      #1 /vendor/elgg/elgg/engine/classes/Elgg/Database/MetastringsTable.php(181): Elgg\Database->insertData('INSERT INTO elg...', Array)
      #2 /vendor/elgg/elgg/engine/classes/Elgg/Database/MetastringsTable.php(133): Elgg\Database\MetastringsTable->add('\xD0\xBA\xD1')

      So, in first, check your error log.

      If your error log similar on my log then your solution is utf8mb4.

      Check your configurations:

      1 - Database: Change Database default collation as utf8mb4:

      my.cnf:
      [client]
      default-character-set = utf8mb4
      [mysqld]
      character-set-server = utf8mb4
      collation-server = utf8mb4_unicode_ci
      [mysql]
      default-character-set = utf8mb4

      2 - Tables: Change table collation as CHARACTER SET utf8mb4 COLLATE utf8mb4_bin.

      Especially for these tables:

      elgg_metastrings
      elgg_objects_entity
      elgg_scraper_data //if it exist

      3 - Set utf8mb4 in database connection:

      $database_connection = new mysqli($server, $user, $password, $database_name);
      $database_connection->set_charset('utf8mb4');

      Finally, Google can help more.

      Reference: https://mathiasbynens.be/notes/mysql-utf8mb4

  • just4fun joined the group Event calendar
  • just4fun replied on the discussion topic Turkish translation
    Please let me know the actions which I need to perform after making the translation in Transiflex to bring the translated strings to the working site ?  view reply
  • just4fun replied on the discussion topic Large group icon files cause the error when loading
    Thank you very much RvR! This is worked!! view reply
  • Elgg version 2.3.10  - when trying to upload big photo (> 1 Mb) then received the Unresponse error. Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 20480 bytes) in...
  • Hopefully found the solution! Added the depends string to the sharemaps_gmaps_js     elgg_define_js('sharemaps_gmaps_js', array(        'deps' =>... view reply