Re: [UPDATED Jan-05-2015] Mods for HESK v1.7.0
Posted: Wed Jan 28, 2015 9:33 pm
I have this problem with clean install hesk 2.5.5 + mods 1.7.0 from github:
Cheers
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'