PHPJunkyard support forum

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.

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:
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)?

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.