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

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
trainyoucan
Posts: 8
Joined: Fri Apr 29, 2016 10:56 am

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

Post 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
Ezra Steenkamp
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

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

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply