Error when adding staff

[joshopkins]

This is a fresh install on a win2k3 server updated to MS standards. Currently installed php 4.4.4, mysql 5, and I am using IIS 6.0. I have not had to many problems getting everything setup at least none with MySQL. Until now. I have configured just about everything that needed to be configured. I was waiting to add the staff until the base was up and running stable. Everything seemed to be fine, we are receiving tickets, sending replies, all under the admin account for testing. Since the testing looked good i was getting starting to setup new staff in the system. When trying to setup the first staff member I filled out all required information and hit the submit button and I received the following error at the top of the confirmation webpage:

Invalid SQL: INSERT INTO ‘swstaff’ (‘fullname’ , ‘username’ , ‘password’ , ‘staffgroupid’ , ‘email’ , ‘mobilenumber’ , ‘lastvisit’ , ‘lastactivity’ , ‘timezoneoffset’ , ‘enabledst’ , ‘startofweek’ , ‘pmunread’ , ‘groupassign’ , ‘enablepmalerts’ , ‘enablepmjsalerts’) VALUES (‘josh’,’jhopkins’,’fc26a25b41496f0f05eca5ded01021 8f’,’1’,’jhopkins@domain.com’,’’,’156914291’,15691 4291’,’99’,’0’,’’,’0’,’,0’,’1’,’1’);(Out of range value adjusted for column ‘startofweek’ at row 1)

I can edit the admin account and make changes to it just fine. Are there custom setting that i need to apply when using MySQL 5. I am not getting any other sql errors.

[Raghav Arora]

Originally Posted by joshopkins

This is a fresh install on a win2k3 server updated to MS standards. Currently installed php 4.4.4, mysql 5, and I am using IIS 6.0. I have not had to many problems getting everything setup at least none with MySQL. Until now. I have configured just about everything that needed to be configured. I was waiting to add the staff until the base was up and running stable. Everything seemed to be fine, we are receiving tickets, sending replies, all under the admin account for testing. Since the testing looked good i was getting starting to setup new staff in the system. When trying to setup the first staff member I filled out all required information and hit the submit button and I received the following error at the top of the confirmation webpage:

Invalid SQL: INSERT INTO ‘swstaff’ (‘fullname’ , ‘username’ , ‘password’ , ‘staffgroupid’ , ‘email’ , ‘mobilenumber’ , ‘lastvisit’ , ‘lastactivity’ , ‘timezoneoffset’ , ‘enabledst’ , ‘startofweek’ , ‘pmunread’ , ‘groupassign’ , ‘enablepmalerts’ , ‘enablepmjsalerts’) VALUES (‘josh’,’jhopkins’,’fc26a25b41496f0f05eca5ded01021 8f’,’1’,’jhopkins@domain.com’,’’,’156914291’,15691 4291’,’99’,’0’,’’,’0’,’,0’,’1’,’1’);(Out of range value adjusted for column ‘startofweek’ at row 1)

I can edit the admin account and make changes to it just fine. Are there custom setting that i need to apply when using MySQL 5. I am not getting any other sql errors.

Hi,
You need to change your MySQL ini and set:
sql-mode = ""

Once set restart your MySQL server and it shall fix the issue.

Regards,

Raghav Arora

[joshopkins]

is that refering to strict mode?

[joshopkins]

That did fix my problem. Thanks for the help. And to answer my own question yes that is the setting that is refering to (sql-mode = "") strict mode for MySQL in the my.ini

[markduffield]

This worked for me as well.