Can't execute SQL

Forum dedicated to Mods for HESK created by Mike Koch

Moderator: mkoch227

Post Reply
untuned
Posts: 4
Joined: Wed Jun 20, 2018 5:57 pm

Can't execute SQL

Post by untuned »

Here's the debug statement I get:

Image

Any way to fix this?
mkoch227
Posts: 666
Joined: Wed Jul 04, 2012 3:37 pm

Re: Can't execute SQL

Post by mkoch227 »

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?
Mike, Lead Developer of Image HESK: A surprisingly simple, user-friendly and FREE help desk software with integrated knowledgebase.
untuned
Posts: 4
Joined: Wed Jun 20, 2018 5:57 pm

Re: Can't execute SQL

Post by untuned »

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?
Yes. Is that a problem?
untuned
Posts: 4
Joined: Wed Jun 20, 2018 5:57 pm

Re: Can't execute SQL

Post by untuned »

Also, this happened on a clean install.
untuned
Posts: 4
Joined: Wed Jun 20, 2018 5:57 pm

Re: Can't execute SQL

Post by untuned »

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`;
mkoch227
Posts: 666
Joined: Wed Jul 04, 2012 3:37 pm

Re: Can't execute SQL

Post by mkoch227 »

Ah, the stage tickets table..... I was thinking this was the regular tickets table. Well that's a bug then :P.
Mike, Lead Developer of Image HESK: A surprisingly simple, user-friendly and FREE help desk software with integrated knowledgebase.
Post Reply