MySQL error 1146: Table 'MY_CRM.outbound_email' doesn't exist

📦 Install & Upgrade Help
1

hi all,
I am using SuiteCRM_Script(github) or " Running the CLI installer" to install suitecrm-8-7-1.zip.
And I have got the same error log in suitecrm.log:

Blockquote
ri Nov 22 14:18:28 2024 [1877][-none-][FATAL] Mysqli_query failed.
Fri Nov 22 14:18:28 2024 [1877][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘MY_CRM.outbound_email’ doesn’t exist
Fri Nov 22 14:18:28 2024 [1877][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Fri Nov 22 14:18:28 2024 [1877][-none-][FATAL] Mysqli_query failed.
Fri Nov 22 14:18:28 2024 [1877][-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 (‘84bc99aa-8317-6d7b-126c-674092d83b48’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘FZ_CRM.outbound_email’ doesn’t exist
Sun Nov 24 03:24:50 2024 [6296][-none-][FATAL] Mysqli_query failed.
Sun Nov 24 03:24:50 2024 [6296][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘MY_CRM.outbound_email’ doesn’t exist
Sun Nov 24 03:24:50 2024 [6296][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Sun Nov 24 03:24:50 2024 [6296][-none-][FATAL] Mysqli_query failed.
Sun Nov 24 03:24:50 2024 [6296][-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 (‘5db04f20-3dff-4d9d-63e5-67429ce9508a’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘MY_CRM.outbound_email’ doesn’t exist

So I don’t know where the root of this exception. And anyone can help me?

2
3

I had used your install script. s_crm_0.1.5.sh

4

You might have to set the folder permissions. Please make sure you have correct versions of PHP, Apache & MySQL and set permissions and configurations and re-install as per the followings.

  1. Delete public/legacy/config.php, public/legacy/config_si.php, public/legacy/config_override.php files.
  2. Create a new database
  3. Set the folder permissions again.
  4. Check if you have all the extensions like curl, zip, mysqli, etc. enabled in php.ini
  5. Set higher values for memory_limit, max_input_time,max_execution_time in php.ini file
  6. Check if the session folder path (session.save_path) is valid in php.ini file.
  7. Open the command line in administration mode or set the admin mode
  8. Check You have PHP.exe folder path set in your environment variables (path).
  9. Run the following command to re-install suite8.7.1 with the database create in step 2.

php bin/console suitecrm:app:install -u "admin" -p "admin" -U "dbadminuser" -P "dbpass" -H "127.0.0.1" -N "suite8db" -S "http://127.0.0.1/" -d "yes" -W "false"

5

Thanks. I had got the root of exception.
I have using PHP 8.3 not matched with Compatibility Matrix :: SuiteCRM Documentation.

1 Like
6

That’s good :smile:

SuiteCRM 8.7 uses PHP 8.1 or 8.2

They’re planning to release SuiteCRM 8.8 using PHP 8.3