ShadowMage Posted March 29, 2019 Share Posted March 29, 2019 I'm trying to configure a new web server to migrate the company intranet, but I'm getting the following error: Server sent charset (255) unknown to the client. Please, report to the developers I did a little googling and it is supposedly a PHP bug that was fixed in version 7.0-ish. I am running MySQL 8.0.15 with PHP 7.3.3 (on Win Server 2019, if that matters) and still getting this error. I tried setting the character_set_server to 'UTF8MB4' but that didn't seem to do anything. Please help. Link to comment Share on other sites More sharing options...
justsomeguy Posted March 29, 2019 Share Posted March 29, 2019 It sounds like you need to set the character set to utf8 in MySQL. Link to comment Share on other sites More sharing options...
ShadowMage Posted March 29, 2019 Author Share Posted March 29, 2019 I did that, I think. That's what I meant by setting the character_set_server. I launched the MySQL command line and ran the following: set global character_set_server = 'UTF8MB4'; It gave me a warning if I set it to just 'UTF8'. Something about being ambiguous with UTF8MB3? Should I be setting this somewhere else? Link to comment Share on other sites More sharing options...
justsomeguy Posted March 29, 2019 Share Posted March 29, 2019 UTF8MB4 is what PHP doesn't understand. That isn't going to work. When I searched for that error message I saw people saying they fixed it by changing to regular utf8. Link to comment Share on other sites More sharing options...
ShadowMage Posted April 1, 2019 Author Share Posted April 1, 2019 Thanks, got it all figured out. Link to comment Share on other sites More sharing options...
ShadowMage Posted April 1, 2019 Author Share Posted April 1, 2019 Got a new problem now. I'm trying to connect to a Progress DB using OpenEdge 10.2A and getting this error: The specified DSN contains an architecture mismatch between the Driver and Application Clearly its complaining about the fact that I'm running 64-bit PHP and trying to use a 32-bit driver (that's the only driver available). I've enabled 32-bit applications in the app pool on IIS but it's still giving this error. Any ideas? Link to comment Share on other sites More sharing options...
justsomeguy Posted April 2, 2019 Share Posted April 2, 2019 Is the database server also 32 bit? Link to comment Share on other sites More sharing options...
ShadowMage Posted April 2, 2019 Author Share Posted April 2, 2019 The Progress DB? Yes, I believe so. I have no trouble connecting to it with the same driver on the current intranet (which is running 32-bit PHP 5.??) Link to comment Share on other sites More sharing options...
justsomeguy Posted April 2, 2019 Share Posted April 2, 2019 Are you connecting via ODBC? It sounds like they don't exactly keep their stuff up to date: A common PHP configuration in Windows environments uses IIS 5.1, PHP 5.1, and Microsoft SQL Server 2005. Link to comment Share on other sites More sharing options...
ShadowMage Posted April 3, 2019 Author Share Posted April 3, 2019 Yes, via ODBC. I set up the DSN in the 32-bit data source manager and a test connection succeeds there. Am I going to have to downgrade PHP and MySQL to 32-bit? Link to comment Share on other sites More sharing options...
justsomeguy Posted April 3, 2019 Share Posted April 3, 2019 If you're required to use Progress, it looks like you may need to use an older version of PHP. I would contact them and try to find out what their plans are for support. If it's difficult to get in touch, I wouldn't use them. Link to comment Share on other sites More sharing options...
ShadowMage Posted April 3, 2019 Author Share Posted April 3, 2019 Unfortunately, i am required to use Progress... I am in touch with Epicor to try to get drivers, otherwise I will revert PHP to an older version. Luckily, Epicor 10 (which we are planning to upgrade to this fall) has moved away from Progress and adopted MySQL so I won't have to deal with this anymore after that. Thanks for your help! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now