Install Frustrations

:angry: I have been working through install issues all day and 1on1 doesn’t make it easy. However, I am now getting the following error that I can’t seem to resolve. Any help would be appreciated!

Fatal error: Uncaught Exception: Database failure. Please refer to suitecrm.log for details. in /homepages/45/d769467219/htdocs/SuiteCRM/include/utils.php:1777 Stack trace: #0 /homepages/45/d769467219/htdocs/SuiteCRM/include/database/DBManager.php(353): sugar_die(‘Database failur…’) #1 /homepages/45/d769467219/htdocs/SuiteCRM/include/database/DBManager.php(328): DBManager->registerError(‘Unable to retri…’, ‘Unable to retri…’, true) #2 /homepages/45/d769467219/htdocs/SuiteCRM/include/database/MysqliManager.php(179): DBManager->checkError(‘Unable to retri…’, true) #3 /homepages/45/d769467219/htdocs/SuiteCRM/modules/Administration/Administration.php(151): MysqliManager->query(‘SELECT category…’, true, ‘Unable to retri…’) #4 /homepages/45/d769467219/htdocs/SuiteCRM/include/entryPoint.php(198): Administration->retrieveSettings() #5 /homepages/45/d769467219/htdocs/SuiteCRM/index.php(47): require_once(’/homepages/45/d…’) #6 {main} thrown in /homepages/45/d769467219/htdocs/SuiteCRM/include/utils.php on line 1777 :angry:

The suitecrm.log states:

Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Mysqli_query failed.
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘dbs41016.currencies’ doesn’t exist
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Mysqli_query failed.
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Users’ AND deleted = 0: MySQL error 1146: Table ‘dbs41016.fields_meta_data’ doesn’t exist
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Mysqli_query failed.
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Employees’ AND deleted = 0: MySQL error 1146: Table ‘dbs41016.fields_meta_data’ doesn’t exist
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Mysqli_query failed.
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘UserPreferences’ AND deleted = 0: MySQL error 1146: Table ‘dbs41016.fields_meta_data’ doesn’t exist
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Mysqli_query failed.
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Administration’ AND deleted = 0: MySQL error 1146: Table ‘dbs41016.fields_meta_data’ doesn’t exist
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Mysqli_query failed.
Wed Apr 10 18:01:57 2019 [8600][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘dbs41016.config’ doesn’t exist

Sorry, no direct help. I see, most likely like you, the MySQL did not properly create the tables and fields.

Did you see my post from a few days ago?
https://suitecrm.com/suitecrm/forum/installation-upgrade-help/22425-build-install-doc-for-noobs
Can you install VMware Player (freebie) and then Ubuntu and follow the manual instructions above? That way you could compare a working/known state to the Ionos/1and1 version. Maybe something will pop-out.

Thanks. Unfortunately I haven’t found the magic pill yet. About to give up! :angry:

The magic pill I found was every time I get an error, delete the config.php file. When I did, everything started working perfectly.

I tried to delete config.php but it returns me to the first installation screen.

I am having problems updating the system and I start to think it is the fault of ionos.

check to see if your DB user has full permissions during install.

Also start a new topic with detailed errors that you face