Unable to open social engine panel.

    • 17 posts
    June 15, 2023 1:17 PM EDT

    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

    • 265 posts
    June 15, 2023 3:54 PM EDT

    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.

    • 265 posts
    June 15, 2023 3:54 PM EDT

    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.

    • 265 posts
    June 16, 2023 5:53 AM EDT
    [url=/profile/abuk]abuk[/url] said:

    PHP 5.6 is not compatible with UTF8 which is the default charset in MySQL 8.


    I meant to write "UTF8MB4"!
    • 17 posts
    June 16, 2023 12:29 PM EDT

    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

    • 265 posts
    June 16, 2023 5:45 PM EDT

    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

     

    • 265 posts
    June 16, 2023 5:46 PM EDT

     Delete the above post please.

    • 265 posts
    June 16, 2023 5:47 PM EDT

    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.

    • 265 posts
    June 16, 2023 5:48 PM EDT

    Sorry. wrong again. please delete above post.

    • 265 posts
    June 16, 2023 5:49 PM EDT

    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
    • 265 posts
    June 16, 2023 5:50 PM EDT

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

    • 17 posts
    June 17, 2023 8:04 AM EDT

    @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.

    • 265 posts
    June 17, 2023 1:54 PM EDT

    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.