doctrine / dbal

Doctrine Database Abstraction Layer
https://www.doctrine-project.org/projects/dbal.html
MIT License
9.48k stars 1.34k forks source link

SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers #4371

Closed david1953 closed 4 years ago

david1953 commented 4 years ago

I am trying to install and use the latest version of PHPMaker 2021. So far, it fails frequently with references to vendor source code. So i don't know who i need to discuss this with. I am using MySql version 8 and PHP version 7.4 The default for MySql charset defaulted to utf8mb4. when that didn't work, i tried utf8, and that didn't work either.

any message, hint or assistance would be greatly appreciated.

this is the debug message I get:

Slim Application Error
Type: Doctrine\DBAL\Exception\DriverException
Code: 0
Message: An exception occurred in driver: SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers
File: C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php
Line: 128
Trace: #0 C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php(182): Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException('An exception oc...', Object(Doctrine\DBAL\Driver\PDO\Exception))
#1 C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\DBALException.php(169): Doctrine\DBAL\DBALException::wrapException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception), 'An exception oc...')
#2 C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOMySql\Driver.php(30): Doctrine\DBAL\DBALException::driverException(Object(Doctrine\DBAL\Driver\PDO\MySQL\Driver), Object(Doctrine\DBAL\Driver\PDO\Exception))
#3 C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(362): Doctrine\DBAL\Driver\PDOMySql\Driver->connect(Array, 'webaccess', 'Parsup-20', Array)
#4 C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(1853): Doctrine\DBAL\Connection->connect()
#5 C:\Users\Public\website\pstest\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(1241): Doctrine\DBAL\Connection->getWrappedConnection()
#6 C:\Users\Public\website\pstest\models\OrderDetails.php(500): Doctrine\DBAL\Connection->executeQuery('SELECT COUNT(*)...')
#7 C:\Users\Public\website\pstest\models\OrderDetails.php(600): PHPMaker2021\pstest\OrderDetails->getRecordCount('SELECT * FROM `...')
#8 C:\Users\Public\website\pstest\models\OrderDetailsList.php(939): PHPMaker2021\pstest\OrderDetails->listRecordCount()
greg0ire commented 4 years ago

I think you need to report this to the developers of the pdo_mysql driver.

david1953 commented 4 years ago

Ok. I wasn’t sure so I thought I’d try you first. Thanks.

Dave Dunbar Phoenix, AZ From my Surface Pro 3

From: Grégoire Paris notifications@github.com Sent: Tuesday, October 20, 2020 11:20 AM To: doctrine/dbal dbal@noreply.github.com Cc: david1953 dave.dunbar09@hotmail.com; Author author@noreply.github.com Subject: Re: [doctrine/dbal] SQLSTATE[HY000] [2054] Server sent charset unknown to the client. Please, report to the developers (#4371)

I think you need to report this to the developers of the pdo_mysql driver.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fdoctrine%2Fdbal%2Fissues%2F4371%23issuecomment-713048142&data=04%7C01%7C%7Cce853510968d45a6f28608d87524b2ae%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637388147753710772%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=jz25SEG%2F87ew4nZbBjrUYOGB6Datyy9lyg3aaBMso4Y%3D&reserved=0, or unsubscribehttps://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACEZ5GH4M5MJBDG6LOFFDJLSLXIDNANCNFSM4SYSHMCQ&data=04%7C01%7C%7Cce853510968d45a6f28608d87524b2ae%7C84df9e7fe9f640afb435aaaaaaaaaaaa%7C1%7C0%7C637388147753720755%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=sMA2bI5tnmz3e7HR797WBBwngzUQZtr88%2Fk5rGVmQOE%3D&reserved=0.

github-actions[bot] commented 2 years ago

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.