I will not bore you with the issue. The bottom line is that the database had be rebuild from about a 4.0.0 level due to lack of a working back up of mysql/data.
Eventually imported an old mysql back up structure (probably 4.0.0) into openemr. Extracted 5.0.0 but could not get the sql_upgrade to work so used 5.0.2 since the 5.0.0-5.0.1 issue (according to many posts here) seemed to have worked.
Copied documents folder over (should be noted that this is a newer copy as the openemr/sites/default/documents were from a working 5.0.0 version, put in the correct credentials in the openemr/sites/default/sqlconf.php file.
When running the sql_upgrade it stops cold with:
Notice: Undefined index: translate_no_safe_apostrophe in C:\xampp\htdocs\openemr\library\translation.inc.php on line 50
Notice: Undefined index: translate_no_safe_apostrophe in C:\xampp\htdocs\openemr\library\translation.inc.php on line 50
Fatal error: Uncaught PDOException: SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘openemr.version’ doesn’t exist in
C:\xampp\htdocs\openemr\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php:88 Stack trace: #0
C:\xampp\htdocs\openemr\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOConnection.php(88): PDO->query(‘SELECT t0.v_maj…’) #1
C:\xampp\htdocs\openemr\vendor\doctrine\dbal\lib\Doctrine\DBAL\Connection.php(908): Doctrine\DBAL\Driver\PDOConnection->query(‘SELECT t0.v_maj…’) #2
C:\xampp\htdocs\openemr\vendor\doctrine\orm\lib\Doctrine\ORM\Persisters\Entity\BasicEntityPersister.php(904): Doctrine\DBAL\Connection->executeQuery(‘SELECT t0.v_maj…’, Array, Array) #3
C:\xampp\htdocs\openemr\vendor\doctrine\orm\lib\Doctrine\ORM\EntityRepository.php(181): Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll(Array, NULL, NULL, NULL) #4
C:\xampp\htdocs\openemr\vendor\doctrine\orm\lib\Doctrine\ORM\EntityRepository.php(164): Doctrine\ORM\EntityRepository->findBy(Array) #5 C:\xampp\htdocs\open in
C:\xampp\htdocs\openemr\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\AbstractMySQLDriver.php on line 42
Obviously at this point I have no idea. If someone has a better plan please let me know or some idea how to get the sql_upgrade.php to execute I am all ears.
Thanks,
Clif