Hi all,
Hope someone may have some ideas on how I could proceed with a sticky one. I am helping out with a crashed server that had an operational 7.2.2 version running. The DB resides on a separate MSSQL box so the data survived intact. My plan was to build the same environment as per the crashed server then restore.
Windows 2008R2 SP1
IIS 7.5
SuiteCRM 7.2.2
PHP 7.2
I was hoping to then run the installer and create an install, then restore the DB but I cannot get the SuiteCRM installer to complete correctly.
Basically I get most of the process complete and it says its done but it doesnt create the full DB structure. I wondered if there was an issue with the SQL connection to the remote server so installed SQL Express on the same box as the SuiteCRM to test as localhost but get the same result.
The installer confirmation page shows everything is OK at step 7 but seems to hang on the final page 8. Trying to access this system results in a āDatabase failure. Please refer to sugarcrm.log for details.ā which shows a bunch of ODBC errors about incorrect fields. See below.
Any help would be much appreciated.
Fri Oct 25 10:45:32 2019 [3156][-none-][FATAL] Query Failed:SELECT * FROM fields_meta_data WHERE custom_module=NāUsersā AND deleted = 0::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name āfields_meta_dataā.
Fri Oct 25 10:45:32 2019 [3156][-none-][FATAL] Query Failed:SELECT * FROM fields_meta_data WHERE custom_module=NāEmployeesā AND deleted = 0::: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid object name āfields_meta_dataā.