Page 1 of 1

HESK 3.2.5 to 3.4.1 Upgrade issue Can't execute SQL:

Posted: Tue Jan 17, 2023 1:30 pm
by trainyoucan
I tried to skips some updates and jump directly from 3.2.5 to 3.4.1 and every time got an error. It is clear that there is some database changes from 3.2 to 3.4 where the table for users was changed. We tried to change it manually to store longer data, but was not able to rectify the issue.

We managed to revert to the backup for now.

Error
Can't execute SQL: UPDATE hesk04_users SET pass='$2y$10$MR/5Mh8vNoDr08vwRdIedux4/6pwbP3oYZwXwz6Kd94c7B24yqAbS' WHERE id=5

MySQL said:
Data too long for column 'pass' at row 1

Re: HESK 3.2.5 to 3.4.1 Upgrade issue Can't execute SQL:

Posted: Tue Jan 17, 2023 3:49 pm
by Klemen
The pass field gets updated to 255 chars in the "Updating 3.2.x to 3.3.0" section of the /install/update.php script.

Make sure you delete all non-3.2.5 tables from the database before updating or the update script will detect the wrong version being installed.