Can't execute SQL
Posted: Wed Jun 20, 2018 5:59 pm
Here's the debug statement I get:
Any way to fix this?
Any way to fix this?
Page 1 of 1
Re: Can't execute SQL
Posted: Wed Jun 20, 2018 6:02 pm
Looks like you're missing the "assignedby" column, which was added in HESK 2.8. Did you update/install HESK 2.8.1 before installing/updating Mods for HESK?
Re: Can't execute SQL
Posted: Wed Jun 20, 2018 6:12 pm
Yes. Is that a problem?mkoch227 wrote: Wed Jun 20, 2018 6:02 pm Looks like you're missing the "assignedby" column, which was added in HESK 2.8. Did you update/install HESK 2.8.1 before installing/updating Mods for HESK?
Re: Can't execute SQL
Posted: Wed Jun 20, 2018 6:15 pm
Also, this happened on a clean install.
Re: Can't execute SQL
Posted: Wed Jun 20, 2018 6:40 pm
I was able to fix it by running this SQL query:
Code: Select all
ALTER TABLE `hesk_stage_tickets` ADD `assignedby` MEDIUMINT(8) NULL DEFAULT NULL AFTER `owner`;Re: Can't execute SQL
Posted: Wed Jun 20, 2018 6:57 pm
Ah, the stage tickets table..... I was thinking this was the regular tickets table. Well that's a bug then 
.
.