SuiteCRM 7.X installer throwing SQL errors

📦 Install & Upgrade Help
1

Hey, so I am trying to install the latest version of 7 (8 can’t run on our environment due to missing PHP modules).

Here’s what happens:

  • Environment Check everything ok
  • Database tables seem to be created
  • Installation stuck
  • Following Errors in the log

Anybody any Idea what I am doing wrong?

Wed Oct 29 16:21:01 2025 [652031][-none-][FATAL] Mysqli_query failed.
Wed Oct 29 16:21:01 2025 [652031][-none-][FATAL]  Query Failed: SELECT id FROM outbound_email WHERE type = 'system' AND deleted = 0: MySQL error 1146: Table 'd04531be.outbound_email' doesn't exist
Wed Oct 29 16:21:01 2025 [652031][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Wed Oct 29 16:21:01 2025 [652031][-none-][FATAL] Mysqli_query failed.
Wed Oct 29 16:21:01 2025 [652031][-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 ('65413df4-8bf9-8d07-c3ec-690230bef1e6','system','system','1','SMTP','other','',25,'','',1,0): MySQL error 1146: Table 'd04531be.outbound_email' doesn't exist
Wed Oct 29 16:21:02 2025 [652031][-none-][FATAL] Mysqli_query failed.
Wed Oct 29 16:21:02 2025 [652031][-none-][FATAL]  Query Failed: SELECT id FROM outbound_email WHERE type = 'system' AND deleted = 0: MySQL error 1146: Table 'd04531be.outbound_email' doesn't exist
Wed Oct 29 16:21:02 2025 [652031][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Wed Oct 29 16:21:02 2025 [652031][-none-][FATAL] Mysqli_query failed.
Wed Oct 29 16:21:02 2025 [652031][-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 ('d4532209-abd7-7fa1-68a7-6902305bc70b','system','system','1','SMTP','other','',25,'','',1,0): MySQL error 1146: Table 'd04531be.outbound_email' doesn't exist
2

Hello,

That sounds overall like issues around the server.
If you just like to test the CRM, you can test it online:

If you want to setup your CRM for the future of your company, invest 5 - 10 USD mothly into a VPS and get a proper environment setup. Suite 8 works as well and you’re set for the future.

Just today I’ve helped a customer - he tried for 3 weeks on some shared web hosting and it wouldn’t work. The VPS + LAMP server + CRM ran within a few hours, smoothly and stable.

If you still need to get it working on your current environment, could you compare your environment to the documentation?

And then, best to wipe everything clean again and retry.

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

Here, you’re already in a odd situation where some tables haven’t been created.
Could be maximum execution time or memory issues - might be all related to the “wrong” server / environment for your CRM.

3

Hey Bastian,

Saw you on Reddit, looks like you are all over SuiteCRM :wink:

Yes, I am considering that.

Do you have any idea what 2-3 users, 200.000 leads and blasting out mails would need server requirement wise?

4

:smiley:

I like to aim for 8GB RAM, 4 CPU cores - but 2 - 3 users can work on way less, 2 cores, 2GB or similar.

Is SuiteCRM the right choice here? If your focus is email campaigns, maybe Mautic might be a better fit.
If you have more processes around sales, SuiteCRM might still be a good fit. Depending on the specifics maybe even both + integration?

Check out my videos on the integration, maybe that’s an option: