Installation completes successfully on my 7.11.13 suitecrm test instance (with no other third-party modules installed), but after installation, the CRM is broken (see screenshot). The errors in the log are always this:
Thu Jul 23 08:52:52 2020 [11876][1][FATAL] Query Failed: SELECT * FROM dt_gdpr WHERE deleted=0 LIMIT 0,1: MySQL error 1146: Table 'suitecrm.dt_gdpr' doesn't exist
Thu Jul 23 08:52:52 2020 [11876][1][FATAL] Exception handling in /var/www/html/include/MVC/Controller/SugarController.php:400
Thu Jul 23 08:52:52 2020 [11876][1][FATAL] Exception in Controller: Datenbank Fehler. Bitte sehen Sie in der Datei suitecrm.log nach.
Thu Jul 23 08:52:52 2020 [11876][1][FATAL] backtrace:
0 /var/www/html/include/database/DBManager.php(353): sugar_die('Datenbank Fehle...')
1 /var/www/html/include/database/DBManager.php(328): DBManager->registerError(' Query Failed: ...', ' Query Failed: ...', true)
2 /var/www/html/include/database/MysqliManager.php(179): DBManager->checkError(' Query Failed: ...', true)
3 /var/www/html/modules/DT_GDPR/gdpr_utils.php(371): MysqliManager->query('SELECT * FROM d...', true)
4 /var/www/html/modules/DT_GDPR/logic_hooks/display_action_button.php(11): isDataPrivacyManager('1')
5 /var/www/html/include/utils/LogicHook.php(274): DT_GDPRLogActionButton->DT_GDPRLogActionButtonProcess('after_ui_footer', NULL)
6 /var/www/html/include/utils/LogicHook.php(213): LogicHook->process_hooks(Array, 'after_ui_footer', NULL)
7 /var/www/html/include/MVC/View/SugarView.php(265): LogicHook->call_custom_logic('', 'after_ui_footer')
8 /var/www/html/include/MVC/Controller/SugarController.php(435): SugarView->process()
9 /var/www/html/include/MVC/Controller/SugarController.php(375): SugarController->processView()
10 /var/www/html/include/MVC/SugarApplication.php(113): SugarController->execute()
11 /var/www/html/index.php(52): SugarApplication->execute()
12
4 years ago
Dear christopherkunz, we will look into this and get back to you ASAP. We'll contact you here in case there are any questions from our side.
Thanks, diligent team
4 years ago
Hello christopherkunz,
we presume this to be a server configuration error. Most likely the database user couldn’t create the needed data table (as the error we are seeing relates to non existing tables, which should have been created at the installation time). Try increasing your database user permissions to cover creation of new tables within the datbase SuiteCRM uses.
If that still does not work, you can reach out to us and send us the install logs at support@dtbc.eu
Thanks, diligent team
4 years ago
Hello, I have checked the database permissions and they are fine. In fact, the table is not created at all, I have grepped through the installation log and found no CREATE TABLE statement for that table. I will send redacted installation logs via e-mail.
4 years ago
Hello christopherkunz,
we will gladly revist your case whenever it suits you. Our offer for a webmeeting as communicated via e-mail still stands.
Thanks, diligent Team