21.01 Database does work in 23.04
cpbonamico opened this issue · 4 comments
I have a legacy 21.01 DCIM instance on Rocky 8.9. Created a new instance on rocky 8.9, installed 23.04 with the new PHP 8.0 and it runs fine with a empty Database. Once I upload my 21.01 mysqldump .sql file and login into the new Database on the 23.04, it goes directly to install.php but the page is blank. I have the AllowEncodedSlashes On in my conf file. What am I missing here please?
if it is showing a blank install.php then there is likely an error occuring on the server when it is trying to run the upgrade for the database. check your apache error logs to see what is up. I would also say to make sure you followed the RHEL8 install guide so you have all the modules installed that are needed. https://github.com/opendcim/openDCIM/wiki/RHEL#rhel-8-installation-instructions The rocky packages should be named the exact same.
This is all I could find..keeps repeating....
[01-Dec-2023 12:47:20 America/Denver] Newer version codebase than database, redirecting to installation script.
[01-Dec-2023 19:47:20 UTC] Applying database update from 23.02 to 23.03
[01-Dec-2023 19:47:20 UTC] PHP Fatal error: Uncaught PDOException: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'fac_Country' already exists in /opt/openDCIM/openDCIM-23.04/install.php:65
Stack trace:
#0 /opt/openDCIM/openDCIM-23.04/install.php(65): PDO->query()
#1 /opt/openDCIM/openDCIM-23.04/install.php(235): applyupdate()
#2 /opt/openDCIM/openDCIM-23.04/install.php(261): upgrade()
#3 {main}
thrown in /opt/openDCIM/openDCIM-23.04/install.php on line 65
You help is greatly appreciated
Chris B.
That was the trick! Thank You Scott and sorry to bug you....
Chris B