Install hangs on creating AOP_Case_Updates

📦 Install & Upgrade Help
1

Greetings!

I’m trying to install SuiteCRM 7.14.5 but the installation consistently gets stuck at “creating Relationship Meta for AOP_Case_Updates”. Last lines of install.log:

2024-08-28 20:38:37…processing table aod_indexevent
2024-08-28 20:38:41…creating table aod_indexevent
2024-08-28 20:38:41…creating Relationship Meta for AOD_IndexEvent
2024-08-28 20:38:41…processing table aod_index
2024-08-28 20:38:45…creating table aod_index
2024-08-28 20:38:45…creating Relationship Meta for AOD_Index
2024-08-28 20:38:45…processing table aop_case_events
2024-08-28 20:38:48…creating table aop_case_events
2024-08-28 20:38:48…creating Relationship Meta for AOP_Case_Events
2024-08-28 20:38:49…processing table aop_case_updates
2024-08-28 20:38:52…creating table aop_case_updates
2024-08-28 20:38:52…creating Relationship Meta for AOP_Case_Updates

On the installation GUI window, this translates to:

Creating the database suitecrm on localhost…done
…

… at which point nothing else happens.

If I attempt to reload the URL for my installation, it will then generate suitecrm.log with the following final entries. I presume the installation got stuck at something to do with outbound mail settings?

Wed Aug 28 20:49:32 2024 [532737][-none-][FATAL] Mysqli_query failed.
Wed Aug 28 20:49:32 2024 [532737][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘suitecrm.outbound_email’ doesn’t exist
Wed Aug 28 20:49:32 2024 [532737][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Wed Aug 28 20:49:32 2024 [532737][-none-][FATAL] Mysqli_query failed.
Wed Aug 28 20:49:32 2024 [532737][-none-][FATAL] Query Failed: INSERT INTO outbound_email (id,name,type,user_id,mail_sendtype,mail_smtptype,mail_smtpserver,mail_smtpport,mail_smtpuser,mail_smtppass,mail_smtpauth_req,mail_smtpssl) VALUES (‘9fa0d4b1-c51f-9c26-b7eb-66cf8db4c809’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘suitecrm.outbound_email’ doesn’t exist

Whereas my first few tries used localhost for SMTP (and therefore no user), I tried again using an external SMTP and providing login details just to make sure all the form fields are filled. Made no difference.

No idea why installation is not progressing beyond this point. Any ideas?

PHP version 8.3 (is this an issue?). No preflight check problems.

Thanks

2

Yes, this could be an issue. Change PHP to 8.1 or 8.2 and run your installation.

3

Yes, this seems to have done the trick - thank you.

Can’t believe what impact a minor PHP version would have… 8.3 isn’t even the latest either.

4

The following steps may help for PHP 8.3 (local and learning purpose, not recommended for production or live application)

  1. Set error_reporting=E_STRICT (or Off) , check if opcache.validate_timestamps=1 (it might have been set to 0 for performance).
  2. Drop the database that was created by the failed installation.
  3. Delete the config.php file created by the failed installation.
  4. Restart the server and open a new tab in the browser (clearing cache can help)
  5. Try installing again with all the required settings set in php.ini file and folders with write permissions.
  6. Provide correct DBMS admin username and password. (Select existing database admin user on 2nd screen and enter username & password).

Please note, this is for current and local development system with PHP 8.3 and learning purpose only.

5

Yes, PHP 8.3 is newer and SuiteCRM code does not support it yet.
You can tick on :white_check_mark: solution button, so it will help others in the future.