HESK upgrade from 2.3 to 2.4.1

[tbtSRMC]

I attempted to upgrade from version 2.3 to 2.4 and saw there were some on going bugs, so I waited until the release of 2.4.1. The 2.4.1 upgrade appears to be successful. But when administrative settings are saved, resulting in the following:

Error:
Tables not found:
hesk_pipe_loops

Non logged in users landings on the home page get the following:

Error:
Can't execute SQL
Please notify webmaster at

Nor can administrators create new tickets, which result in the same message as the home page. Though existing tickets can be accessed and edit.

[Klemen]

Looks like your database wasn't updated to 2.4.1.

Did you run the install/upgrade script as instructed in step-by-step guide?

[tbtSRMC]

Did you run the install/upgrade script as instructed in step-by-step guide?

Yes, steps 1-7. Although I would occasionally forget to delete/rename the install directory before clicking the 'Click here to login automatically' button and would get the 'Please delete the install folder from your server for security reasons then refresh this page!' message. Deleting/removing the install directory after attempting to login, is too late to get the upgrade to complete successfully.

Upon following that IMPORTANT step, which is there in bold red letters, it appears to working. Maybe some logic can be added to prevent that before proceeding to the login.

[tbtSRMC]

Klemen, turns out the problem was a permission issue with the user mysql and /tmp, so all is well now.

The debug info:

Can't execute SQL: SELECT `t1`.`id`,`t1`.`user`,`t1`.`name`, `t1`.`email`, `t1`.`language`, `t1`.`isadmin`, `t1`.`categories`, `t1`.`notify_assigned`, `t1`.`heskprivileges`, (SELECT COUNT(*) FROM `hesk_tickets` WHERE `owner`=`t1`.`id` AND `status` != '3') as `open_tickets` FROM `hesk_users` AS `t1` WHERE `t1`.`autoassign`='1' ORDER BY `open_tickets` ASC, RAND()

MySQL said:
Can't create/write to file '/tmp/#sql_723_0.MYI' (Errcode: 13)

For those getting 'Can't execute SQL', check to make sure your mysql user has the correct permissions:

chmod 1777 /tmp

--
tbt

[Klemen]

Glad to hear you fixed it!