Issue on update and on POP 3 Fetching

[peopleinside_it]

Hi,
POP 3 Fetching are active but not work.. if i receve a new email a ticket is not opened.
So activated debug and when i run the pop fetching page php file i see this error log:

Impossibile eseguire 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 (SELECT `ID` FROM `hesk_statuses` WHERE `IsClosed` = 0) ) as `open_tickets` FROM `hesk_users` AS `t1` WHERE `t1`.`autoassign`='1' ORDER BY `open_tickets` ASC, RAND()

Errore MySQL:
Key 'statuses' doesn't exist in table 'hesk_tickets'

Also if i try to reinstall Hesk, unistall and reinstall it's impossibile because it will be blocked as the image below:


Please how can I fix?
Thanks.

[mkoch227]

The missing key issue is a known issue in Mods for HESK, and is expected to be fixed in 2.4.0. However, you can run the following SQL query to fix it:

Code: Select all

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

Where hesk_ is your database prefix.

In the screenshot, it looks like Mods for HESK is migrating any IP / Email bans that might be present. Is it getting stuck at "In Progress" forever, or does it ever change colors (such as to red, yellow, or green)?

[peopleinside_it]

Solved with database SQL.

Was in progress forever. However now i see in the settings i have the last edition 2.3.2 - Mods for HESK è aggiornato so maybe check if i will have issue on next update.