[LOCKED] Mods for HESK "archive" Thread

[coinwall]

I have this problem with clean install hesk 2.5.5 + mods 1.7.0 from github:

Code: Select all

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` FORCE KEY (`statuses`) WHERE `owner`=`t1`.`id` AND `status` IN ('0','1','2','4','5') ) as `open_tickets` FROM `hesk_users` AS `t1` WHERE `t1`.`autoassign`='1' ORDER BY `open_tickets` ASC, RAND()
MySQL said:
Key 'statuses' doesn't exist in table 'hesk_tickets'

Cheers

[mkoch227]

This issue will be fixed in 2.0.0. For now, execute this query:

Code: Select all

ALTER TABLE `hesk_tickets` ADD KEY `statuses` (`status`)

Where "hesk_" is your table prefix.