Problem after change server

[Mark.B]

I think you're referring to "Trevor Hannant", who is very much male, just for information.

[DamYan]

Please talk with my in ticket system, thank you ☺️

[DamYan]

I have 2 database with utf8mb4 and Old database without utf8mb4. I sometimes talk with Hannah, next Day with Joe and next Day with you.
Hannah needed database before concert to utf8mb4 and i write to ticket database2 and password.
On 2 database topics and posts not found. After change script from 4.2.5 to new vb5. Hannah reply 1 Times per week and i talk with her 1-2monts about problems

[Wayne Luke]

That doesn't answer my question... This is why your issue is drawn out. You don't answer the questions that are asked.

If you just change your database tables and fields to utf8mb without regard to the contents, then you will destroy your database. The reason being is that before utf8mb4, a UTF-8 character can be 1-4 bytes in length. We have no way of knowing where one character starts or ends in the data stream. With the previous MySQL character set, we would be told which character was which.

After utf8mb4, each character takes 4 bytes, always. If the characters weren't explictly changed using the scripts we provide, then we don't know what the data is to display it correctly.

A conversion to UTF8MB4 should never be done on a vBulletin 3 or vBulletin 4 database. They have no understanding of UTF-8 and don't even store characters in that format.

[DamYan]

Hannah told me if need database before change convert to utf-8. Second database is in w utf8mb4, please check ticket system and reply.

[Wayne Luke]

Actually, your forum software works fine. What is broken is old text that doesn't appear to have been properly converted to UTF-8. How did you change your tables to utf8mb4? Did you use our provided scripts? This isn't something we normally do on the server.

What happens with new created content in your language?

[DamYan]

Wayne Luke Support not reply again on my ticket, i waiting few days, forum not working, i lost users and money. I paid for upgrade and now i have broken forum. Hannah Trevor broken my forum.

[Wayne Luke]

We have many customers. We'll get to your ticket as soon as possible. If the issues were the result of a paid upgrade, you should have followed up in that pre-existing ticket.

[DamYan]

Hello Wayne Luke why support not reply about my problems with forum. "Topics and posts not found" i have info, when i check my section.
HAnnah Trevor upgrade my forum for money and not working good.

[Wayne Luke]

You will need to open a support ticket so we can review the server and the vBulletin configuration. Obviously something is misconfigured somewhere.

I am guessing it is an unmanaged server so you don't actually get support with your money. Do you know how to configure your operating system of choice? If changes are needed for the server, you'll need to make them.

[DamYan]

All section, only show me information "Topic not found" and thread have more posts, but i see nothing ;c

[Wayne Luke]

You'll need to be more specific. The question is too vague and impossible to answer. Show where?

[DamYan]

Okey, thank you

Why topics and posts dont show after upgrade??

[Wayne Luke]

You will need to turn on the innodb_large_prefix setting. Newer versions of MySQL have deprecated this value so it is enabled at all times. You can find more information here:

https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html#sysvar_innodb_large_prefix

If you don't have permission to edit your MySQL settings, you will need to discuss this with your hosting provider.

[DamYan]

i have problem with that articles

" 0 => 'SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.', 1 table has 1.2gb
"