I am upgrading 5…0.0 to 6.0.0
I installed the newest xampp package.
xampp-windows-x64-8.0.0-2-VS16-installer.exe
Downloaded unzipped and copied the openemr 6.0.0 into htdocs, named it openemr
When I try to restore the database it fails:
I saved it thus:
C:>C:\xampp\mysql\bin\mysqldump -u root -p openemr > OEMRdump\dumpfile.sql
Enter password:
But fails to restore:
C:>C:\xampp\mysql\bin\mysql -u root -p openemr < OEMRdump\dumpfile.sql
Enter password:
ERROR 1049 (42000): Unknown database ‘openemr’
I am in serious trouble because I now have no EMR!
I also tried logging in to the system regardless of having restored my data:
Warning : mysqli_real_connect(): (HY000/1045): Access denied for user ‘openemr’@‘localhost’ (using password: YES) in C:\xampp\htdocs\openemr\library\ADODB_mysqli_log.php on line 191
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:788 Stack trace: #0 C:\xampp\htdocs\openemr\vendor\adodb\adodb-php\drivers\adodb-mysqli.inc.php(788): mysqli_query(false, 'SET NAMES ‘utf8…’, 0) #1 C:\xampp\htdocs\openemr\vendor\adodb\adodb-php\adodb.inc.php(1263): ADODB_mysqli->_query('SET NAMES ‘utf8…’, false) #2 C:\xampp\htdocs\openemr\vendor\adodb\adodb-php\adodb.inc.php(1241): ADOConnection->_Execute('SET NAMES ‘utf8…’, false) #3 C:\xampp\htdocs\openemr\library\ADODB_mysqli_log.php(60): ADOConnection->Execute('SET NAMES ‘utf8…’, false) #4 C:\xampp\htdocs\openemr\library\sql.inc(58): ADODB_mysqli_log->ExecuteNoLog('SET NAMES ‘utf8…’) #5 C:\xampp\htdocs\openemr\interface\globals.php(268): require_once(‘C:\xampp\htdocs…’) #6 C:\xampp\htdocs\openemr\interface\login\login.php(28): require_once(‘C:\xampp\htdocs…’) #7 {main} thrown in C:\xampp\htdocs\openemr\vendor\adodb\adodb-php\drivers\adodb-mysqli.inc.php on line 788
In desparation I restored my whole filesystem to before I tried the upgrade. When I try logging in I get:
“Site ID is missing from session data!”
I REALLY NEED SOME HELP - MY PRACTICE IS IN TROUBLE NOW!
So I also tried starting completely over, fresh installation.
came to:
Open up web-browser and point it to the installation script at http://localhost/openemr .
But all I got:
This page isn’t working
localhost is currently unable to handle this request.
HTTP ERROR 500
=============================================
After a number of hours, we were unable to get xampp 8 and openemr 6.0.0 to work
We did revive my original 5.0.0 by deleting all the cookies.