Can't execute SQL: UPDATE

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
nh420
Posts: 3
Joined: Sun May 17, 2015 3:39 pm

Can't execute SQL: UPDATE

Post 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.
Klemen
Site Admin
Posts: 10145
Joined: Fri Feb 11, 2005 4:04 pm

Re: Can't execute SQL: UPDATE

Post 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.
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
nh420
Posts: 3
Joined: Sun May 17, 2015 3:39 pm

Re: Can't execute SQL: UPDATE

Post by nh420 »

really sorry about that -

just one quick question - is the update automatic?


sorry again and thanks for the update.
nh420
Posts: 3
Joined: Sun May 17, 2015 3:39 pm

Re: Can't execute SQL: UPDATE

Post by nh420 »

:D simple and easy fix.. Thanks Klemen...
Klemen
Site Admin
Posts: 10145
Joined: Fri Feb 11, 2005 4:04 pm

Re: Can't execute SQL: UPDATE

Post by Klemen »

Glad you got it working :wink:
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
Post Reply