Page 1 of 1
Cannot execute SQL msg on password change
Posted: Thu Oct 14, 2021 12:32 pm
by 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
Re: Cannot execute SQL msg on password change
Posted: Thu Oct 14, 2021 4:04 pm
by Klemen
If you turn Debug mode ON in Admin > Settings > Help desk > Features then try again, what does the error say?
Re: Cannot execute SQL msg on password change
Posted: Thu Oct 14, 2021 7:11 pm
by plc
MySQL said:
Unknown column 'notify_overdue_my' in 'field list'
Re: Cannot execute SQL msg on password change
Posted: Fri Oct 15, 2021 5:46 am
by Klemen
Re: Cannot execute SQL msg on password change
Posted: Fri Oct 15, 2021 5:54 pm
by 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.
Re: Cannot execute SQL msg on password change
Posted: Fri Oct 15, 2021 5:56 pm
by Klemen
Does changing the password work now?
Re: Cannot execute SQL msg on password change
Posted: Sat Oct 16, 2021 1:17 am
by plc
Well well, yes it does! I've never been very good at reading SQL output lol Thanks!