Cannot execute SQL msg on password change

[plc]

Trying to change a users password (not admin) and getting: Error Can't execute SQL.

HESK version
3.2.2 - Update available
Update HESK
PHP version
7.3.31 (MySQLi)
MySQL version
10.1.48-MariaDB
/hesk_settings.inc.php
Exists, Writable
/Jfkg1reSdifneDkdo
Exists, Writable
/cache
Exists, Writable

[Klemen]

If you turn Debug mode ON in Admin > Settings > Help desk > Features then try again, what does the error say?

[plc]

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

[Klemen]

See this: viewtopic.php?f=13&t=6771

[plc]

Did that

Upgraded from Mods for Hesk in the past, I presume?

Try this:
1. backup existing database
2. run this on your database in phpMyAdmin (your host should have it):
CODE: SELECT ALL

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

Got this

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0353 seconds.)
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 can confirm I did have mods for hesk and removed it some time ago per the directions provided.

[Klemen]

Does changing the password work now?

[plc]

Well well, yes it does! I've never been very good at reading SQL output lol Thanks!