I have a version of OpenEMR 4.1.0 on Windows xampp. I am able to do a mysqldump without an issue. I want to import the openemr mysql database into a new fresh install of OpenEMR 5.0.1 (fresh install via OpenEMR Cloud Express Plus in AWS).
Long story short, after I run " mysql -h 127.0.0.1 -u root -p openemr < openemr.sql", and try /sql_upgrade.php, the sql_upgrade.php page fails to load with a 500 error. Prior to the mysql import, I can at least load the page fine. The error I receive in the /var/log/apache2/error.log follows below:
PHP Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘t0.v_realpatch’ in ‘field list’ in /var/www/localhost/htdocs/openemr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:104\nStack trace:\n#0 /var/www/localhost/htdocs/openemr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(104): PDO->query(‘SELECT t0.v_maj…’)\n#1 /var/www/localhost/htdocs/openemr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php(852): Doctrine\DBAL\Driver\PDOConnection->query(‘SELECT t0.v_maj…’)\n#2 /var/www/localhost/htdocs/openemr/vendor/doctrine/orm/lib/Doctrine/ORM/Persisters/Entity/BasicEntityPersister.php(884): Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.v_maj…’, Array, Array)\n#3 /var/www/localhost/htdocs/openemr/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(181): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(Array, NULL, NULL, NULL)\n#4 /var/www/localhost/htdocs/openemr/vendor/doctrine/orm/lib/Doctrine/ORM/EntityRepository.php(164): Doctrine in /var/www/localhost/htdocs/openemr/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php on line 71
Is there anyone who can give me a clue about what to try next? Thanks, kindly.