When attempting to update an issue in helpdesk DB, a
support agent is given an error stating:
UPDATE tbl_Issues SET
contact='2189',solution='ddd',location='dd',summary='dd',
description='dd',assignedto=10,detail=0,category=2,priority=6,
status=2,level=7 WHERE id=16
This could be because there is no valid connection, or
because the query is incorrect.
It will not update table with new updated issue
information.
What is the problem]? User is a support agent, should
he not
have access to update?