Upgrading from Version 4.1.2 to Version 5

Hello all

I have been trying to upgrade my Version 4.1.2 running on a XAMPP server on Windows 10. I get to the login screen but on entering user name and password am presented with: Failure during database access! Check server error log.

My apache error log:
[Sun Aug 20 16:09:51.583285 2017] [mpm_winnt:notice] [pid 2804:tid 704] AH00422: Parent: Received shutdown signal – Shutting down the server.
[Sun Aug 20 16:09:53.684254 2017] [mpm_winnt:notice] [pid 5512:tid 620] AH00364: Child: All worker threads have exited.
[Sun Aug 20 16:09:55.491540 2017] [mpm_winnt:notice] [pid 2804:tid 704] AH00430: Parent: Child process 5512 exited successfully.
[Sun Aug 20 16:47:55.785136 2017] [ssl:warn] [pid 16120:tid 772] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:47:56.685213 2017] [ssl:warn] [pid 16120:tid 772] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:47:59.338360 2017] [mpm_winnt:notice] [pid 16120:tid 772] AH00455: Apache/2.4.4 (Win32) OpenSSL/0.9.8y PHP/5.4.16 configured – resuming normal operations
[Sun Aug 20 16:47:59.338360 2017] [mpm_winnt:notice] [pid 16120:tid 772] AH00456: Server built: Feb 23 2013 13:07:34
[Sun Aug 20 16:47:59.338360 2017] [core:notice] [pid 16120:tid 772] AH00094: Command line: ‘C:\xampp\apache\bin\httpd.exe -d C:/xampp/apache’
[Sun Aug 20 16:47:59.363398 2017] [mpm_winnt:notice] [pid 16120:tid 772] AH00418: Parent: Created child process 2324
[Sun Aug 20 16:48:01.773505 2017] [ssl:warn] [pid 2324:tid 524] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:48:02.807150 2017] [ssl:warn] [pid 2324:tid 524] AH01909: RSA certificate configured for www.example.com:443 does NOT include an ID which matches the server name
[Sun Aug 20 16:48:02.993424 2017] [mpm_winnt:notice] [pid 2324:tid 524] AH00354: Child: Starting 150 worker threads.
[Sun Aug 20 17:06:45.117143 2017] [:error] [pid 2324:tid 2076] [client ::1:61066] script ‘C:/xampp/htdocs/openemr/interface/login/login_frame.php’ not found or unable to stat
[Sun Aug 20 19:38:37.509834 2017] [auth_basic:error] [pid 2324:tid 2056] [client ::1:62461] AH01618: user rayaz not found: /xampp/

My php error log:

[20-Aug-2017 07:27:46 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery

[20-Aug-2017 07:45:01 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery

[20-Aug-2017 07:54:06 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery

[20-Aug-2017 08:12:13 America/Los_Angeles] Executing as user:openemr Statement failed:select users.id,users.username,users_secure.password,users_secure.id FROM users,users_secure WHERE users.id = ? AND users.username=users_secure.username AND users.active=1:Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’==>C:\xampp\htdocs\openemr\library\auth.inc at 133:privQuery

Any help is appreciated

Regards

Update to my problem.

Now I can log in successfully and things seem to be going well.

I copied the auth.inc file from my 4.1.2 version to the 5 version and it worked!

I wonder what I am missing out though!

Regards

Hello Rayaz,
According to the php error log you have posted, the illegal mix of collations error has been fixed in the recent patch 3.
you can find the recent patch here http://www.open-emr.org/wiki/index.php/OpenEMR_Patches
We suggest that you shouldn’t replace the auth.inc file from lower version(4.1.2) to higher version (5.0) in OpenEMR.

Thanks,
ViSolve

Hi Visolveemr

Thanks for the input. The problem is I have already applied the patch and it did not work

So what now?

Regards

hi @Rayaz,
Looks like your database has different collations in it (utf8_general_ci and utf8_unicode_ci). Will need to standardize it to 1 throughout and then also ensure the default collation for your database is the same, so it uses this collation when add new database tables/columns.
-brady