Page 1 of 1

Can't execute SQL: UPDATE

Posted: Sun May 17, 2015 3:50 pm
by nh420
Sorry if i'm posting in the incorrect forum!

New user of hesk so be patient please.. :)

When I enable autoclose feature of the helpdesk, I cannot login to the helpdesk - when i disable it, I can. When in debug mode, I receive the following error -

Can't execute SQL: UPDATE `pwp_tickets` SET `status`='3', `closedat`=NOW(), `closedby`='-1', `history`=CONCAT(`history`,'
17-05-2015 16:35:05 | closed by (automatically)') WHERE `status` = '2' AND `lastchange` <= '2015-05-09 16:35:05'

MySQL said:
Out of range value for column 'closedby' at row 1


Please Help! I've left that feature off so I can login as far as fixing the issue - I've drawn a blank.

Re: Can't execute SQL: UPDATE

Posted: Sun May 17, 2015 6:32 pm
by Klemen
Please don't post here AND send me a private message.

That said, this issue has been fixed in an update 2 months ago. Go to your settings page, click "Check for updates" and apply the available update.

Re: Can't execute SQL: UPDATE

Posted: Sun May 17, 2015 6:42 pm
by nh420
really sorry about that -

just one quick question - is the update automatic?


sorry again and thanks for the update.

Re: Can't execute SQL: UPDATE

Posted: Sun May 17, 2015 7:09 pm
by nh420
:D simple and easy fix.. Thanks Klemen...

Re: Can't execute SQL: UPDATE

Posted: Mon May 18, 2015 1:41 pm
by Klemen
Glad you got it working :wink: