After installation, got 'http 500' error

SuiteCRM Forum - English Language Installation & Upgrade Help
#1

What I did:
Freshly new installation of SuiteCRM8.2.4, I made a mistake when I input db’s name during the installation. I input ‘suitecrm’ for the database name(the database I created in mysql was ‘suitecrm_db’). So after installation, I cannot open “http://localhost”(was installed locally) anymore. I reached to log files. It said database ‘suitecrm’ connection error. So I knew and created a ‘suitecrm’ database in mySQL. But, still I cannot open “http://localhost”.(seems db is empty and suitecrm cannot find what it needs)

What suitecrm.log says:

Blockquote
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘suitecrm.currencies’ doesn’t exist
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Users’ AND deleted = 0: MySQL error 1146: Table ‘suitecrm.fields_meta_data’ doesn’t exist
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Employees’ AND deleted = 0: MySQL error 1146: Table ‘suitecrm.fields_meta_data’ doesn’t exist
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘UserPreferences’ AND deleted = 0: MySQL error 1146: Table ‘suitecrm.fields_meta_data’ doesn’t exist
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Administration’ AND deleted = 0: MySQL error 1146: Table ‘suitecrm.fields_meta_data’ doesn’t exist
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:51 2023 [4904][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘suitecrm.config’ doesn’t exist
Thu Apr 6 08:54:54 2023 [3611][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:54 2023 [3611][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘suitecrm.currencies’ doesn’t exist
Thu Apr 6 08:54:54 2023 [3611][-none-][FATAL] Mysqli_query failed.
Thu Apr 6 08:54:54 2023 [3611][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘suitecrm.config’ doesn’t exist

What should I do?

#2

There is a file on the root of your installation called config.php. There you can enter your DB information.

#3

Thanks for replying.

微信图片_20230406125359
微信图片_20230406125359754×468 31.6 KB

But there is no such file.

#4

I got this.

I tried install once again using cmdline install, but it said ‘installer locked’. To solve this, go to /legacy/config.php, find ''installer_locked = true" changed it to “false”. And running cli install again. Then a bunch of permission denied. Had to ‘chmod -R 777’ for entire suiteCRM folder(it is unsafe, be sure to change it to proper permisson later). Then installation succeed and it can work properly now.

Have to figure out what exact permission it needs later. For now, at least I can try it out.

#5

The file you had trouble finding, config.php, is stored in public/legacy directory in SuiteCRM V8.

1 Like