PHPJunkyard support forum

Script URL: https://helpcenterhq.com
Version of script: 3.4.2
Hosting company: Hetzner
URL of phpinfo.php: https://helpcenterhq.com/phpinfo.php
URL of session_test.php: https://helpcenterhq.com/session_test.php
What terms did you try when SEARCHING for a solution: notify_overdue_my.

Write your message below:

Hello - hope you're all well.

I love Hesk and have been using it for years (along with Mods for Hesk).

I'm trying to add a new user and keep getting this message:

- - -
Error
Can't execute SQL: INSERT INTO `hesk_users` ( `user`, `pass`, `isadmin`, `name`, `email`, `signature`, `categories`, `autoassign`, `heskprivileges`, `afterreply`, `autostart`, `autoreload`, `notify_customer_new`, `notify_customer_reply`, `show_suggested`, `notify_new_unassigned`, `notify_overdue_unassigned`, `notify_new_my`, `notify_overdue_my`, `notify_reply_unassigned`, `notify_reply_my`, `notify_assigned`, `notify_pm`, `notify_note` ) VALUES ( 'John', '$2y$10$PviNerZ4mlyukPLO4oAzl.zQj45VpO4iUK3fAYeZDweGKx5DQZWhe', '1', 'John', 'john[at]email.com', '', '', '0', '', '0' , '1' , '30' , '1' , '1' , '1' , '1' , '0', '1' , '0' , '0' , '0' , '0' , '0', '0' )

MySQL said:
Unknown column 'notify_overdue_my' in 'field list'
- - -

I went to PHPMyAdmin, found the table hesk_users and ran the following:

ALTER TABLE `hesk_users` ADD COLUMN `notify_overdue_my` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' AFTER `notify_overdue_unassigned`

I got this response:

MySQL said: Documentation

#1054 - Unknown column 'notify_overdue_unassigned' in 'hesk_users'

I tried again and the issue persists.

Any idea what I may be doing wrong?

Regards,

George

Did you recently upgrade the help desk? From what version? Did you run the update script?

Hi, Klemen

I tried to add the user today. Once I got the error, I researched the issue. I upgraded to the latest version of Hesk today, using the script process found here: https://www.hesk.com/update.php?v=3.2.5. So, I had version 3.2.5.

Thanks,

George

This usually happens when the database was upgraded to "Mods for Hesk" in the past, then the mods are not completely uninstalled.

Look at your hesk_tickets table. Does it have a "html_message" column?
Look at your hesk_replies table. Does it have a "html_message" column?

If both of the above is "Yes", try running this code: If not, I'll need to see the full table structure, as I don't know what else is missing.

Klemen, I have sent you a PM.

Thanks.