Can't access to OpenEMR

I can’t access OpenEMR anymore, the browser outputs HTTP error 500 if I try to get localhost/openemr and apache error.log reports:

[Sat Mar 25 17:44:30.595610 2023] [php:error] [pid 2836:tid 1888] [client ::1:50629] PHP Fatal error:  Uncaught TypeError: mysqli_query(): Argument #1 ($mysql) must be of type mysqli, bool given in C:\\xampp\\htdocs\\openemr\\vendor\\adodb\\adodb-php\\drivers\\adodb-mysqli.inc.php:1150\nStack trace:\n#0 C:\\xampp\\htdocs\\openemr\\vendor\\adodb\\adodb-php\\drivers\\adodb-mysqli.inc.php(1150): mysqli_query(false, 'SET NAMES 'utf8...', 0)\n#1 C:\\xampp\\htdocs\\openemr\\vendor\\adodb\\adodb-php\\adodb.inc.php(1318): ADODB_mysqli->_query('SET NAMES 'utf8...', false)\n#2 C:\\xampp\\htdocs\\openemr\\vendor\\adodb\\adodb-php\\adodb.inc.php(1295): ADOConnection->_Execute('SET NAMES 'utf8...', false)\n#3 C:\\xampp\\htdocs\\openemr\\library\\ADODB_mysqli_log.php(60): ADOConnection->Execute('SET NAMES 'utf8...', false)\n#4 C:\\xampp\\htdocs\\openemr\\library\\sql.inc(66): ADODB_mysqli_log->ExecuteNoLog('SET NAMES 'utf8...')\n#5 C:\\xampp\\htdocs\\openemr\\interface\\globals.php(301): require_once('C:\\\\xampp\\\\htdocs...')\n#6 C:\\xampp\\htdocs\\openemr\\interface\\login\\login.php(38): require_once('C:\\\\xampp\\\\htdocs...')\n#7 {main}\n  thrown in C:\\xampp\\htdocs\\openemr\\vendor\\adodb\\adodb-php\\drivers\\adodb-mysqli.inc.php on line 1150

I’m using OpenEMR version 7 patch 2 with Microsoft Edge and Mozilla, on Windows 11. I was able to access OpenEMR till some days ago.

I noticed this is the same problem reported in this post, but no solution has been proposed.

I discovered that the problem was due corrupted MySQL tables, so I followed instructions detailed here and I solved.

1 Like