Hi,
I have purchased a new V6 to upgrade my website from v4.8.8 to a new V6.

I was trying to fix that first in my local system so that it does not cause problems in the live server.

I downgrade my local php to 5.6 and using MySQL 8 as I am not able to use multiple MySQL servers.

While I am trying to run my project I am getting a few errors.

Fatal error: Uncaught exception 'Zend_Db_Adapter_Mysqli_Exception' with message 'Server sent charset unknown to the client. Please, report to the developers' 

Fatal error: Array and string offset access syntax with curly braces is no longer supported in

\application\libraries\Zend\Wildfire\Plugin\FirePhp.php on line 740

As I have 60 days of support also but they don't help for local system.

So Can you help me on this to give me any alternative apart from downgrading mysql to 5.6.

Thanks

PHP 5.6 is not compatible with UTF8 which is the default charset in MySQL 8. You can change the MySQL 8 charset back to UTF8 by editing your my.cnf file as follows:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

With regards to the "Array and string offset access syntax" error, I think 4.8.8 is very old and you are probably running a very old version of PHP to support it. You might need to upgrade to 5.0 or something and then 6.0 in order to get around this. Different versions of social engine are compatible with different versions of PHP.

You might want to see if FirePHP is a different file in version 5.0 to 4.8, and just copy that as a first way of trying to solve it.

abuk I change these in my.ini file of MYSQL for windows

[client]

default-character-set=utf8

[mysql] default-character-set=utf8

[mysqld]

collation-server = utf8_unicode_ci

character-set-server = utf8

But still, no luck getting the same error
Fatal error: Uncaught exception 'Zend_Db_Adapter_Mysqli_Exception' with message 'The server requested authentication method unknown to the client' in D:\xampp\htdocs\localcheck.com\application\libraries\Zend\Db\Adapter\Mysqli.php:352

That's not the same error. Your previous error was 

Server sent charset unknown to the client.

The new error is 

The server requested authentication method unknown to the client

This is because MySql changed the default authentication plugin. Change the default mysql authentication plugin by using this in your my.cnf file.

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

 Delete the above post please.

That's not the same error. Your previous error was 

Server sent charset unknown to the client.

The new error is 

The server requested authentication method unknown to the client

This is because MySql changed the default authentication plugin. Change the default mysql authentication plugin by using this in your my.cnf file.

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
default_authentication_plugin=sha256_password

 You may then recreate the database user that SocialEngine uses.

Sorry. wrong again. please delete above post.

That's not the same error. Your previous error was 

Server sent charset unknown to the client.

The new error is 

The server requested authentication method unknown to the client

This is because MySql changed the default authentication plugin. Change the default mysql authentication plugin by using this in your my.cnf file.

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8


[mysqld]
collation-server=utf8_unicode_ci
character-set-server=utf8
default_authentication_plugin=mysql_native_password

Use the bottom one. Cutting and pasting isn't working for me in this forum right now.

@abuk Not getting the option to delete that, meanwhile thank you very much that worked.

now I am getting some website-related error 

This site can’t be reached

localcheck.com refused to connect.

If this is a local site running on your own server, you need to configure a DNS entry for the site. Generally, on a local development server you use localhost as the domain name so you don't have to worry about setting up a local dns.