The XML Galleys and some older article pages were not loaded after upgrade to 184.108.40.206. It was because
there was an Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’ in
Collations in my old database were in utf8_unicode_ci and they should be in utf8_general_ci
I log in to my Hostgator cpanel, and used phpMyAdmin, click on database.
Firstly I changed the Table type from MyISAM to InnoDB.
I have used the following script:
SELECT CONCAT('ALTER TABLE ',TABLE_NAME,' ENGINE=InnoDB;')
AND table_schema = 'your-db-name';
and following exactly this procedure: How to change your MyISAM DB to InnoDB using phpMyAdmin
Press the submit query button to see a list of tables to alter to InnoDB
Click the “+Options” link above the results, choose the “Full texts” option, and press the “Go” button in the shaeded area at the lower right
Above the results, tick the “Show all” checkbox
Copy all the queries using the “Copy to clipboard” link in the “Query results operations” box below the results
Paste the result into a text editor and copy all the lines starting with “ALTER TABLE” to your clipboard
Click the SQL tab above the results
Paste the ALTER TABLE statements into the textarea and press the “Go” button in the lower right shaded area
Then I changed the collation for all tables and columns:
XML galleys start loading, and all some Article subpages start loading.
THIS PROBLEM WAS SOLVED
- eLife Lens Article Viewer: figures in the XML GALLEYS are not displayed
- XML galley publication date is -1 day, there is 27th of Feburary but it should be 28th of February
- Saving any file takes too long.
And Figures are not displayed in the XML galleys
[03-Mar-2021 10:10:17 America/Chicago] ojs2: 404 Not Found
Any idea how to solve this problem?