Database error
My database has had an error for some time now and it's held my site from being upgraded. I'm stuck at 11.0.2
I've been trying to fix my database and have made some progress.
Trying to change the collations I keep getting this error. The other errors I had I was able to correct but this one I cannot.
I've been told to post an image of the database structure.
Any help would be appreciated.
-
This is where I don't understand, the wiki module is what wreaked havoc on my database.
-
Hello Michael Newton !
When the table contains the date field (or other which format prevents to be converted) then try to change the collation for every field there except the "troubled" like DateStarts in your example.
-
I'm stuck here trying to change "default" to "As defined" by looking at another site that is working fine.
-
I think I've solved all my Collation problems.
Now with the final reason for fixing it; to update my albums module. It has not shown active in the Studio, it has not worked for years.
With all that done to fix the collation errors, this is the database error when trying to "activate" the albums module, I get this message.
Database error in Man of Teal | An OpenRCT2 Community
Query:
INSERT INTO `bx_timeline_handlers` SET `group`=?, `type`=?, `alert_unit`=?, `alert_action`=?, `content`=?, `privacy`=?Mysql error:
Duplicate entry 'bx_albums-added' for key 'alert'Location:
The error was found in query function in the file /home/manofteal/public_html/modules/base/notifications/classes/BxBaseModNotificationsDb.php at line 76.collation_connection:
utf8mb4_unicode_ci -
Hello Michael Newton !
Great that you solved the collation problem. About your albums issue, you may apply this solution https://una.io/page/cmts-view?sys=bx_forum&id=6383&cmt_id=29255 just use there the "bx_albums" word instead of "bx_ads".
-
Hello Michael Newton !
Great that you solved the collation problem. About your albums issue, you may apply this solution https://una.io/page/cmts-view?sys=bx_forum&id=6383&cmt_id=29255 just use there the "bx_albums" word instead of "bx_ads".
That did the trick! LeonidS, thank you! After all these years!
error9.jpg