Installing 8.7 on Shared Hosting

📦 Install & Upgrade Help
21

In config_php you have site_url and host_name

These can be overwritten in config_override.php

But what exactly are these curl calls you’re discussing? Which addresses are they using?

22

It’s the SuiteCRM Pre-Installation Checklist. To see what I’m talking about, visit https://digmembers.ditsquad.work/install.php

23

I think you can installed it since those are warnings:

Just make sure you have these PHP modules installed:

24

This seems to be the code:

core/backend/Install/Service/InstallPreChecks.php

You can check how it is forming the URL there

25

I clicked on “Ignore Warnings and Proceed”. Now, I’m getting a database failure message. the suitecrm.log file shows this:
Thu Oct 24 18:39:55 2024 [460638][-none-][FATAL] Mysqli_query failed.
Thu Oct 24 18:39:55 2024 [460638][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist
Thu Oct 24 18:39:55 2024 [460638][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Thu Oct 24 18:39:55 2024 [460638][-none-][FATAL] Mysqli_query failed.
Thu Oct 24 18:39:55 2024 [460638][-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 (‘8d7e767a-fab6-445a-6e16-671a86dd3648’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist

Looks like the Installation PHP code isn’t creating all the tables and columns.

I wish the logfiles show where it’s called from.

26

Have you create database for your SuiteCRM.

You can check database configueation in config.php file and .env.local file in root directory.

This table looks weird. If you don’t have any have data in it. You can drop that table.

27

Created database? Yes, I created an empty database. I had to in order to have the database name, user and password.

Table ‘digdiggers-353035393faf.outbound_email’

Database name is digdiggers-353035393faf
Table name is outbound_email

That table does not exist in the database.

The installation code DID create a bunch of other tables …just not the outbound_email one.

28

if database is empty
just delete .env.local from suitecrm root directory

and from
public/legacy
config.php
config_override.php
config_si.php

important: your database password should not contain any special characters, letters and digits only

29

Thank you!

I did this and was able to get back to the Pre-Installation Checklist. My hosting company wanted to see the cURL warnings.

I changed the database password – it had special characters. I like using special characters to make the password stronger.

30

ROUTE ACCESS CHECK :warning:

Curl Request on Main Page:

  • The SuiteCRM Title cannot be found. This is not a valid SuiteCRM Page.
  • The url used for the call was: http://website.com
  • The result of the call was:
  • Empty

Curl Request on Api:

  • The result of the curl call to the graphql page was empty.
  • The url used for the call was: http://website.com/api/graphql
  • The result of the call was:
  • Empty
31

I tried adding a line of code to set another curl option to false but that didn’t work.
CURL_SSL_VERIFYSTATUS

So, I “hardcoded” the $baseUrL with the https://(address) and that took care of the 2 cURL warnings.

So, I’m now in the next phase of the install. Configuration. I put in the database fields (host, name, passwrod, user). and clicked "Proceed button. It came back with an error message. “LBL_ACTION_ERROR” I have NO clue what the error message is

I’m quitting for the evening.

32

Do not use special characters in the password while installing it.

You can check the errors in the log file.

Also, check your db config in .env.local file or config.php file.

Make sure it is correct.

33

Thank you. However, I responded previously that I changed the db password because it had special characters. Now, it only has letters and digits.

After fixing that, and restarted the install , it did proceed to the next step. The env.local file has the db connection string and the app secret key. I know the db info is correct because it did create the database.
I checked the suitecrm.log file and it points to the missing table outbound_email. Looks like the database setup SQL file is missing the outbound_email table definition and did not create it.

From the suitecrm.log file
Sun Oct 27 02:28:06 2024 [2711130][-none-][FATAL] Mysqli_query failed.
Sun Oct 27 02:28:06 2024 [2711130][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist
Sun Oct 27 02:28:06 2024 [2711130][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Sun Oct 27 02:28:06 2024 [2711130][-none-][FATAL] Mysqli_query failed.
Sun Oct 27 02:28:06 2024 [2711130][-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 (‘19159315-22aa-c67a-c86e-671da512dd70’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist
Sun Oct 27 02:29:13 2024 [2712767][-none-][FATAL] Mysqli_query failed.
Sun Oct 27 02:29:13 2024 [2712767][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist
Sun Oct 27 02:29:13 2024 [2712767][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Sun Oct 27 02:29:13 2024 [2712767][-none-][FATAL] Mysqli_query failed.
Sun Oct 27 02:29:13 2024 [2712767][-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 (‘1d8d59c4-7199-afbb-97bf-671da5e6ebed’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist
Sun Oct 27 13:35:06 2024 [3744329][-none-][FATAL] Mysqli_query failed.
Sun Oct 27 13:35:06 2024 [3744329][-none-][FATAL] Query Failed: SELECT id FROM outbound_email WHERE type = ‘system’ AND deleted = 0: MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist
Sun Oct 27 13:35:06 2024 [3744329][-none-][SECURITY] OutboundEmail::checkSavePermissions - not logged in - skipping check
Sun Oct 27 13:35:06 2024 [3744329][-none-][FATAL] Mysqli_query failed.
Sun Oct 27 13:35:06 2024 [3744329][-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 (‘bdd59f47-da77-bb33-1ffa-671e417cfacf’,‘system’,‘system’,‘1’,‘SMTP’,‘other’,‘’,25,‘’,‘’,1,0): MySQL error 1146: Table ‘digdiggers-353035393faf.outbound_email’ doesn’t exist

I will attempt to create that missing tablee using the direct SQL statements I see in the log file.

34

The outbound_email table SQL code:

outbound_email.zip (1005 Bytes)

You can run this SQL query and create that table in DB.

35

If you had a failed installation, it’s better to repeat it and solve any problems, rather than attempting to piece it together manually. You don’t know what else is missing, and you might only find out later that something else is broken…

36

You are correct and that is a true statement. My point is that this is the SECOND time I did the install from the beginning. Both times failed with the missing outbound_email table. I looked at the code, and it’s clear to me, that it’s writing entries to the log files …but which logfile it is writing to is the problem. and they’re not all in ONE folder. This makes troublshooting a bit more difficult.

Thank you for the SQL file.

I’m not sure why this is not working for me and works just fine for others.

37

Yeah, even I am curious, why it is not running for you. Maybe in this attempt, you can download installation zip again from the website and run it.

38

That outbound_email SQL file fixed the last issue.

Now, I can’t log in. I even looked in the config.si.php file and made sure I"m using the correct username and password. the suitecrm.log file showed a FATAL error – missing bean file modules/users/user.php. but the file is there.

I’m going to start over. I have to put this on the back burner for now.

39

Set permission and owneship correct

clear symfony cache or delete cache/prod

Check in config.php file

‘site_url’