Database question regarding collation latin1 vs utf8 vs utf8mb4

[Mr B]

Of course Glenn Vergara , there are no scroll functionality and the "Post" button are grayed out when trying to reply a message. Sending new messages are broken also. The Google Chrome Console...

[Mr B]

Glenn Vergara , we found one issue with the temporary solution. The "Post" button in Message Center/chat do not work on the mobile. Maybe there is a separate template for that? The chat opens...

[Mr B]

Thanks Glenn Vergara ! Your temporary solution seems to work for us.

We are going to migrate the DB to UTF-8 (utf8mb4) but we are facing different type of problems in our test environment...

[Mr B]

Where can i verify if we have a support contract or not? And how do i purchase it if we do not already have it? I cant find the info in "My Account", "Purchase", "Renewals / New...

[Mr B]

But it worked in version 5.4.4 of vBulletin. It stopped working after the upgrade to 5.4.5......

[Mr B]

Thanks for the fast reply.

Where have you attached the scripts needed for converting the database, tables and columns from latin1 to utf8mb4? Can you post them again or give a link to them?...

[Mr B]

We got several unresolved issues with vBulletin 5.4.5 (mostly issues related to special characters like едц in the swedish language) and the support here have suggested us to convert the MySQL database...

[Mr B]

I got a password for a user who have the problem and logged is as him. The username is "nappafцrbцveln" and the following two images shows the script errors on our forum home page. Both username...

[Mr B]

How can i find the JSON that you need? For example a user called Gцsta experience problems. Will put up a test account with special characters on our site tomorrow.

Something have changed...

[Mr B]

Sorry for that, i discovered this new issue today. Will dig in to it deeper tomorrow morning and will update the other thread with info....

[Mr B]

Do you have version 5.4.5 installed and users with special characters in their usernames?...

[Mr B]

Wayne Luke , can you or other person from the support look at this problem?

[Mr B]

Ok, same here! Do you have language pack installed? I have a swedish one which is partially translated.

It must have slipped in new bugs in 5.4.5. I also had problems with page pagination...

[Mr B]

I think that we got the same issue on our site. Last days three different users (all with special characters like едц in their user names) have really strange problems... Im at home today but will check...

[Mr B]

I have now tested on three different mobiles and one computer with different browsers and the problem seems to be solved. Page pagination works and no errors in the Google Chrome Console. Thanks!
...

[Mr B]

This was really strange. I removed the translation as you suggested and cleared system cache and the problem was gone. I have only tested on mobile device at the moment and will test on a computer tomorrow....

[Mr B]

I have tried that one in vBulletin 5.4.4 and the ad appears IN the first post. Not after. Would be great to have an option to add the ad between post 1 and post 2....

[Mr B]

The following entry in the JavaScript code in the header template was missing so i added that. I have not removed it so it must have been missed in the upgrade.
"user_editorstate": "{vb:var...

[Mr B]

The problem is that the pagination doesnt work when not logged in (when logged in it works). It worked in 5.4.4 but not in 5.4.5. The 3 images have comments on them that shows which works and which does...

[Mr B]

One of my users reported that the topic page pagination is not working correctly after upgrade to vBulletin 5.4.5. I can recreate the issue and it works if the user is logged in but not when the user...