Page 1 of 1
[v2.0] Can't execute SQL
Posted: Wed Mar 11, 2009 3:28 pm
by MPH2008
Hi folks,
I'm trying to add users to Hesk as an administrator but am getting the above message on submission. I'm not too hot with SQL - is it this to do with permissions?
Posted: Wed Mar 11, 2009 6:35 pm
by Klemen
Turn on the debug mode in settings and try again. Than compare the error message you get with similar error messages (and solutions) on the forum.
Posted: Thu Mar 12, 2009 5:16 pm
by MPH2008
Can't execute SQL: INSERT INTO `hesk_users` (`user`,`pass`,`isadmin`,`name`,`email`,`signature`,`categories`,`heskprivileges`) VALUES ('','7c9c32a35c441053e73171151492943f3befccf5','0','','','','1,','can_view_tickets,can_reply_tickets,can_change_cat,')
MySQL said:
Field 'ratingneg' doesn't have a default value
I've editted out some of the password/user details, but that is the debugged error in it's entirety. I'm assuming something about the technician/helper/feedback rating is causing this on initial account creation.
Posted: Thu Mar 12, 2009 5:48 pm
by Klemen
Posted: Fri Mar 13, 2009 10:00 am
by MPH2008
D'oh! Thanks Klemen.
