Error Upgrading EspoCRM 8.4

[babyjayden]

Data Log:
[2024-09-04 01:20:30] ERROR: Failed to rebuild database schema. Details: There is no column with name "delete_id" on table "user". at /home2/plannig2/i.malaysiaeasy.com/l/vendor/doctrine/dbal/src/Schema/Exception/ColumnDoesNotExist.php:16
[2024-09-04 01:20:30] ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details..
[2024-09-04 01:20:35] ERROR: (500) Error occurred while EspoCRM rebuild. Please see the log for more detail. :: POST /Admin/action/runUpgrade :: /home2/plannig2/i.malaysiaeasy.com/l/application/Espo/Core/Upgrades/Actions/Base.php(176)

Table Structure

id	varchar(17)	NO	PRI	NULL
	deleted	tinyint(1)	YES		0
	user_name	varchar(50)	YES	MUL	NULL
	type	varchar(24)	YES	MUL	regular
	password	varchar(150)	YES		NULL
	auth_method	varchar(24)	YES		NULL
	api_key	varchar(100)	YES		NULL
	salutation_name	varchar(255)	YES		NULL
	first_name	varchar(100)	YES		NULL
	last_name	varchar(100)	YES		NULL
	is_active	tinyint(1)	NO		1
	title	varchar(100)	YES		NULL
	gender	varchar(255)	YES		NULL
	created_at	datetime	YES		NULL
	modified_at	datetime	YES		NULL
	delete_id	varchar(17)	NO		0
	middle_name	varchar(100)	YES		NULL
	default_team_id	varchar(17)	YES	MUL	NULL
	contact_id	varchar(17)	YES	MUL	NULL
	avatar_id	varchar(17)	YES		NULL
	created_by_id	varchar(17)	YES	MUL	NULL
	dashboard_template_id	varchar(17)	YES	MUL	NULL
	working_time_calendar_id	varchar(17)	YES	MUL	NULL
	layout_set_id	varchar(17)	YES	MUL	NULL
	avatar_color	varchar(7)	YES		NULL

Thanks

[yuri]

The upgrade should work fine if run from CLI. Do you have CLI access?

[babyjayden]

my hoster not allow CLI, ip updating through the administration upgrading page.thanks

[yuri]

Wait for v8.4.1 release. It might support upgrade from the UI.

[serqet]

I get similar when upgrading from 8.3.6 to 8.4.0;

ERROR: Failed to rebuild database schema. Details: There is no column with name "delete_id" on table "user". at /var/www/vhosts/*****.com.tr/httpdocs/vendor/doctrine/dbal/src/Schema/Exception/ColumnDoesNotExist.php:16 [2024-09-11 06:54:06] ERROR: Database rebuild failure, details: Error while rebuilding database. See log file for details..

CLI response;
[root@srv2 httpdocs]#/opt/plesk/php/8.0/bin/php command.php upgrade PHP Parse error: syntax error, unexpected identifier "Config", expecting variable in /var/www/vhosts/***. com.tr/httpdocs/application/Espo/Core/Log/LogLoader.php on line 52

[victor]

The first bug will be fixed in 8.4.1 (as yuri said in a previous post).
Regarding the second error, you should check your php version using the command

php -v

It looks like you are using php 8.0, which was dropped in EspoCRM 8.1.0: https://github.com/espocrm/espocrm/releases/tag/8.1.0.

[serqet]

Thanks victor, I was able to upgrade via CLI after upgrading PHP version to 8.3.11.

[yuri]

Likely it's not because of PHP version but because of disabled PHP cache or now PHP can run subprocesses.

[yuri]

> The first bug will be fixed in 8.4.1

There was no bug. Upgrade via UI is not guaranteed for every version. "Bug" is a bad word.