[v2.0] Can't execute SQL

MPH2008 · Post by **MPH2008** » Wed Mar 11, 2009 3:28 pm

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?

Post by **Klemen** » Wed Mar 11, 2009 6:35 pm

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.

MPH2008 · Post by **MPH2008** » Thu Mar 12, 2009 5:16 pm

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.

Post by **Klemen** » Thu Mar 12, 2009 5:48 pm

Try searching:
viewtopic.php?t=2338

MPH2008 · Post by **MPH2008** » Fri Mar 13, 2009 10:00 am

D'oh! Thanks Klemen.