MySQL weird error (again) [+REP]

MySQL weird error (again) [+REP] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL weird error (again) [+REP] (/showthread.php?tid=604470)

MySQL weird error (again) [+REP] - iKevin - 05.04.2016

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.

Re: MySQL weird error (again) [+REP] - theonethatownz - 05.04.2016

Correct plugin for the server?

Re: MySQL weird error (again) [+REP] - Logic_ - 05.04.2016

MySQL R39-5.

Re: MySQL weird error (again) [+REP] - AndySedeyn - 05.04.2016

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.

Re: MySQL weird error (again) [+REP] - Logic_ - 05.04.2016

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.

Re: MySQL weird error (again) [+REP] - iKevin - 05.04.2016

Quote:

Originally Posted by AndySedeyn

Код:

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?

Re: MySQL weird error (again) [+REP] - AndySedeyn - 05.04.2016

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.

Re: MySQL weird error (again) [+REP] - iKevin - 05.04.2016

Doesn't work..

Re: MySQL weird error (again) [+REP] - AndySedeyn - 05.04.2016

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

Re: MySQL weird error (again) [+REP] - iKevin - 05.04.2016

Код:

#1046 - No database selected

Now this error. What the fuck...