[iKevin]

I apologize for spamming these threads, but sadly I have no clue what this is.

Basically, on my beta server I have inserted the SQL database and it worked out well, on the server, everything was cool. Then I fixed some bugs in the script, adjusted the credentials and put it to the main server. But when I inserted the SQL db content to the database on my host it returned this error which didn't return on the beta;

Код:

#1115 - Unknown character set: 'utf8mb4'

and the line is

Код:

 /*!40101 SET NAMES utf8mb4 */;

Hope someone can help. I'll rep++ him.

[theonethatownz]

Correct plugin for the server?

[Logic_]

MySQL R39-5.

[AndySedeyn]

This has nothing to do with the plugin nor the include. The MySQL version on your server doesn't support the characterset 'utf8mb4'. I seem to remember that you're using ultra-h, and they have MySQL 5.5 installed on their servers.

Supported character sets in MySQL 5.5 with the 'utf8mb4_' prefix:

Код:

utf8mb4_bin
utf8mb4_czech_ci
utf8mb4_danish_ci
utf8mb4_esperanto_ci
utf8mb4_general_ci
utf8mb4_hungarian_ci
utf8mb4_icelandic_ci
utf8mb4_latvian_ci
utf8mb4_lithuanian_ci
utf8mb4_persian_ci
utf8mb4_polish_ci
utf8mb4_roman_ci
utf8mb4_romanian_ci
utf8mb4_sinhala_ci
utf8mb4_slovak_ci
utf8mb4_slovenian_ci
utf8mb4_spanish2_ci
utf8mb4_spanish_ci
utf8mb4_swedish_ci
utf8mb4_turkish_ci
utf8mb4_unicode_ci

You can use utf8mb4_unicode_ci.

[Logic_]

Quote:

Originally Posted by AndySedeyn This has nothing to do with the plugin nor the include. The MySQL version on your server doesn't support the characterset 'utf8mb4'. I seem to remember that you're using ultra-h, and they have MySQL 5.5 installed on their servers. Supported character sets in MySQL 5.5 with the 'utf8mb4_' prefix: Код: utf8mb4_bin utf8mb4_czech_ci utf8mb4_danish_ci utf8mb4_esperanto_ci utf8mb4_general_ci utf8mb4_hungarian_ci utf8mb4_icelandic_ci utf8mb4_latvian_ci utf8mb4_lithuanian_ci utf8mb4_persian_ci utf8mb4_polish_ci utf8mb4_roman_ci utf8mb4_romanian_ci utf8mb4_sinhala_ci utf8mb4_slovak_ci utf8mb4_slovenian_ci utf8mb4_spanish2_ci utf8mb4_spanish_ci utf8mb4_swedish_ci utf8mb4_turkish_ci utf8mb4_unicode_ci You can use utf8mb4_unicode_ci.

Right now, As i believe Kevin has changed the MySQL db hosting server, we were using ultra-h for testing.

[iKevin]

Quote:

Originally Posted by AndySedeyn This has nothing to do with the plugin nor the include. The MySQL version on your server doesn't support the characterset 'utf8mb4'. I seem to remember that you're using ultra-h, and they have MySQL 5.5 installed on their servers. Supported character sets in MySQL 5.5 with the 'utf8mb4_' prefix: Код: utf8mb4_bin utf8mb4_czech_ci utf8mb4_danish_ci utf8mb4_esperanto_ci utf8mb4_general_ci utf8mb4_hungarian_ci utf8mb4_icelandic_ci utf8mb4_latvian_ci utf8mb4_lithuanian_ci utf8mb4_persian_ci utf8mb4_polish_ci utf8mb4_roman_ci utf8mb4_romanian_ci utf8mb4_sinhala_ci utf8mb4_slovak_ci utf8mb4_slovenian_ci utf8mb4_spanish2_ci utf8mb4_spanish_ci utf8mb4_swedish_ci utf8mb4_turkish_ci utf8mb4_unicode_ci You can use utf8mb4_unicode_ci.

I changed the host now, I'm on the main server, ultra-h was beta.

Код:

#1115 - Unknown character set: 'utf8mb4_unicode_ci'

Now this. I've got R39-3 plugin, and how do I check which version does the host use?

[AndySedeyn]

Quote:

Originally Posted by KevinExec I changed the host now, I'm on the main server, ultra-h was beta. Код: #1115 - Unknown character set: 'utf8mb4_unicode_ci' Now this. I've got R39-3 plugin, and how do I check which version does the host use?

You can change the collation in phpMyAdmin on the homepage. See attachment.

[iKevin]

Doesn't work..

[AndySedeyn]

I seem to be mistaken.

Change:

Код:

/*!40101 SET NAMES utf8mb4 */;

To:

Код:

/*!40101 SET NAMES utf8 */;

utf8mb4 is a superset of utf8.
A quick ****** search and I found this: http://stackoverflow.com/questions/2...f8mb4-in-mysql

[iKevin]

Код:

#1046 - No database selected

Now this error. What the fuck...