Some probleme with manual install

[edin]

Hello, any one get this errors ?
Tanks in avance !!

[2024-02-03 01:30:35] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'lead (id VARCHAR(17) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_...' at line 1
[2024-02-03 01:30:35] ERROR: Uncaught Exception RuntimeException: "System user is not found." at /home/demo.com/application/Espo/Core/ApplicationUser.php line 72 {"exception":"[object] (RuntimeException(code: 0): System user is not found. at /home/demo.com/application/Espo/Core/ApplicationUser.php:72)"}
[2024-02-03 01:30:36] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'lead (id VARCHAR(17) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_...' at line 1
[2024-02-03 01:30:36] ERROR: Uncaught Exception RuntimeException: "System user is not found." at /home/demo.com/application/Espo/Core/ApplicationUser.php line 72 {"exception":"[object] (RuntimeException(code: 0): System user is not found. at /home/demo.com/application/Espo/Core/ApplicationUser.php:72)"}
[2024-02-03 01:30:38] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'lead (id VARCHAR(17) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_...' at line 1
[2024-02-03 01:30:38] ERROR: Uncaught Exception RuntimeException: "System user is not found." at /home/demo.com/application/Espo/Core/ApplicationUser.php line 72 {"exception":"[object] (RuntimeException(code: 0): System user is not found. at /home/demo.com/application/Espo/Core/ApplicationUser.php:72)"}

[shalmaxb]

There is "System user is not found"

What does it mean "manual install"? Did you not install it in the recommended, normal way? Because if you do, the system user will be created.

[edin]

Hello,

Manual install like:
Unzip before upload via ftp then try to install.
Maybe my web hosting....im on infomaniak.com

[shalmaxb]

With so little information it is not possible to detect, what could be the reason. You can install espoCRM on shared webhosting, but it still will have to meet the pre-requisits.
Some PHP configuration must be set correctly.

And you can upload espoCRM via FTP to a subdomain. Configure an MySQL or MariaDB Databse. Then call the subdomain in the browser, which will let the installation start. During this process you will be asked the database cerdentials and configure some parameters. After that appears a table with all your server configuration. There everything should pass. If not, you will have to configure your server ans PHP correctly, repeat the verification process and when it passes, espoCRM will be installed. Durin that the system user will be created.

And read the documentation.

[GuillaumeM]

Hi,
I have the same problem.
I try to install on Infomaniak too.
I'm trying to change server configuration.
I'll come back at the end of my tests.

[GuillaumeM]

In my logs :
[2024-02-10 05:01:54] INFO: Schema, query: CREATE TABLE lead (id VARCHAR(17) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_ci`, deleted TINYINT(1) DEFAULT 0, salutation_name VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, first_name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, last_name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, title VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, status VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT 'New' COLLATE `utf8mb4_unicode_ci`, source VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, industry VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, opportunity_amount DOUBLE PRECISION DEFAULT NULL, website VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, address_street VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, address_city VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, address_state VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, address_country VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, address_postal_code VARCHAR(40) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, do_not_call TINYINT(1) DEFAULT 0 NOT NULL, description MEDIUMTEXT CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, converted_at DATETIME DEFAULT NULL, created_at DATETIME DEFAULT NULL, modified_at DATETIME DEFAULT NULL, account_name VARCHAR(255) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, middle_name VARCHAR(100) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, opportunity_amount_currency VARCHAR(3) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, created_by_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, modified_by_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, assigned_user_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, campaign_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, created_account_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, created_contact_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, created_opportunity_id VARCHAR(17) CHARACTER SET utf8mb4 DEFAULT NULL COLLATE `utf8mb4_unicode_ci`, INDEX IDX_FIRST_NAME (first_name, deleted), INDEX IDX_NAME (first_name, last_name), INDEX IDX_STATUS (status, deleted), INDEX IDX_CREATED_AT (created_at, deleted), INDEX IDX_CREATED_AT_STATUS (created_at, status), UNIQUE INDEX UNIQ_CREATED_AT_ID (created_at, id), INDEX IDX_ASSIGNED_USER (assigned_user_id, deleted), INDEX IDX_ASSIGNED_USER_STATUS (assigned_user_id, status), INDEX IDX_CREATED_BY_ID (created_by_id), INDEX IDX_MODIFIED_BY_ID (modified_by_id), INDEX IDX_ASSIGNED_USER_ID (assigned_user_id), INDEX IDX_CAMPAIGN_ID (campaign_id), INDEX IDX_CREATED_ACCOUNT_ID (created_account_id), INDEX IDX_CREATED_CONTACT_ID (created_contact_id), INDEX IDX_CREATED_OPPORTUNITY_ID (created_opportunity_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE `utf8_unicode_ci` ENGINE = InnoDB
[2024-02-10 05:01:54] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'lead (id VARCHAR(17) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_...' at line 1
[2024-02-10 05:01:54] ERROR: Uncaught Exception RuntimeException: "System user is not found." at xxxxxxxxxx/crm/application/Espo/Core/ApplicationUser.php line 72 {"exception":"[object] (RuntimeException(code: 0): System user is not found. at xxxxxxxxxx/crm/application/Espo/Core/ApplicationUser.php:72)"}

I made this install also in a XAMPP : I miss a table on Infomaniak server -> lead
And all tables are empty.

So I made the install on XAMPP, I export database (juste before adding user admin) et import in Infomaniak.
Then I finished the install on Infomaniak.
I works well.

I don't know what went wrong during database installation.

[MGat]

I'm facing the same issue. I managed to meet all the system requirements through the advanced options in Infomaniak, except for the max_input_time condition, which appears as "0". If I proceed with the installation, the log in data/log is as follows:




[2024-03-01 21:44:56] WARNING: E_WARNING: Attempt to read property "value" on null {"code":2,"message":"Attempt to read property "value" on null","file":"/home/clients/7cd0956c8b1b376481ca2314cac25bdd/web/ecrm/install/vendor/smarty/libs/sysplugins/smarty_internal_templatebase.php(143) : eval()'d code","line":4}
[2024-03-01 21:44:56] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'lead (id VARCHAR(17) CHARACTER SET utf8mb4 NOT NULL COLLATE `utf8mb4_unicode_...' at line 1
[2024-03-01 21:44:56] ERROR: Uncaught Exception RuntimeException: "System user is not found." at /home/clients/7cd0956c8b1b376481ca2314cac25bdd/web/ecrm/application/Espo/Core/ApplicationUser.php line 72 {"exception":"[object] (RuntimeException(code: 0): System user is not found. at /home/clients/7cd0956c8b1b376481ca2314cac25bdd/web/ecrm/application/Espo/Core/ApplicationUser.php:72)"}




My hypothesis is that since Infomaniak creates the user with read and write permissions in the databases with a prefix, and does not allow generating users or changing permissions in the database, EspoCRM cannot create the system user.