Cannot Hard Rebuild

[bradaks]

When attempting a hard rebuild I am getting these errors:

[2023-09-07 19:30:11] ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] Connection refused" at /opt/bitnami/espocrm/application/Espo/ORM/PDO/MysqlPDOFactory.php line 73 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] Connection refused at /opt/bitnami/espocrm/application/Espo/ORM/PDO/MysqlPDOFactory.php:73)"}
[2023-09-07 19:35:21] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'parent_id' at row 20
[2023-09-07 19:35:21] ALERT: Rebuild database error: An exception occurred while executing a query: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'contact_id' at row 23


Any suggestions?

I have a lot of records and am having trouble locating the records causing these issues.

[item]

Hi,
make a backup first with hard rebuild ! (see recommandation for use this command on documentation)
certainly collation/charset issue in database

maybe : https://forum.espocrm.com/forum/inst...-after-upgrade

Edit : verify too in entity manager for length of field.

[bradaks]

item

I am doing this on a backup. Appreciate the warning.

All of the contact IDs in every table seem to be set up as utf8mb4_unicode_ci and varchar(17).

Where would I find the length of the field? I am assuming all of these are relationship connections so there shouldnt be a length in the settings.

[item]

here : https://docs.espocrm.com/development.../#app-recordid
my recordId.json :
{
"length": 17
}

i just see in my database sample : account_contact
accountId : length 17 collation and charset : utf8mb4_unicode_ci
contactId : length 17 collation and charset : utf8mb4_unicode_ci

[bradaks]

Actually, the user table is set up as mb3 and varchar(24)

[bradaks]

That is exactly what it is. Ran the mb4 conversion script and it is humming like an angel. item, thanks for the assist.

[khopper]

I'm getting the following error when trying to HARD REBUILD even though I am running command under SUDO as `sudo php /var/www/espocrm/command.php rebuild --hard`

[2024-10-16 01:33:58] ERROR: (0) Uncaught Exception RuntimeException: "Route collector cache file directory `data/cache/application` is not writable" at /var/www/espocrm/vendor/slim/slim/Slim/Routing/RouteCollector.php line 142 :: /var/www/espocrm/vendor/slim/slim/Slim/Routing/RouteCollector.php(142)

[khopper]

I could only get this to work by logging in as www-data first!

https://ubuntuforums.org/showthread.php?t=2280551

$ su
Password:
# su -s /bin/bash www-data