HESK 3.2.5 to 3.4.1 Upgrade issue Can't execute SQL:
Posted: Tue Jan 17, 2023 1:30 pm
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
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