Can not insert staff?

[ozgurerdogan]

After filling the adding staff forms and insert staff button, nothing changes like new staff does not get added.
What is the problem.

[supportskins]

Check your server error_log for any reported errors. My guess is you are having the MySQL "Out of range" issue which you can fix by editing the sql-mode.

[ozgurerdogan]

Originally Posted by supportskins

Check your server error_log for any reported errors. My guess is you are having the MySQL "Out of range" issue which you can fix by editing the sql-mode.

Well could you please more clear. I am using win2003 server and can not see any error in event viewer. What is Out of range" issue and how can I fix it.?
Thank you very much for your helps.

[ozgurerdogan]

ok I turned on display_error and found the following error:
Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \swift.php on line 252

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \swift.php on line 349

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \swift.php on line 350

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \includes\functions.php on line 1189

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \includes\functions.php on line 1981

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \includes\functions.php on line 1983

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in \includes\functions.php on line 2129

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in includes\functions.php on line 2236

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in includes\SmartyLight\class.template.php on line 717

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in includes\SmartyLight\class.template.php on line 785

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in modules\core\core.php on line 37

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in modules\core\admin_staff.php on line 188

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in modules\core\admin_staff.php on line 188

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in modules\core\admin_staff.php on line 338

Warning: Call-time pass-by-reference has been deprecated - argument passed by value; If you would like to pass it by reference, modify the declaration of [runtime function name](). If you would like to enable call-time pass-by-reference, you can set allow_call_time_pass_reference to true in your INI file. However, future versions may not support this any longer. in modules\core\admin_staff.php on line 338


And then I set allow_call_time_pass_reference = on and got no error on page but it still did not insert new staff.

if I set safe mode on I see following error:
\modules\core\admin_staff.php on line 338
Invalid SQL: INSERT INTO `swstaff` (`fullname`, `username`, `password`, `staffgroupid`, `email`, `mobilenumber`, `lastvisit`, `lastactivity`, `timezoneoffset`, `enabledst`, `startofweek`, `pmunread`, `groupassigns`, `enablepmalerts`, `enablepmjsalerts`) VALUES ('sadasdasd', 'sdsdsd', '2f3e9eccc22ee583cf7bad86c751d865', '2', 'destek@mail.com', 'asa', '1162288683', '1162288683', '99', '0', '', '0', '0', '1', '1'); (Out of range value adjusted for column 'startofweek' at row 1)
Warning: Cannot modify header information - headers already sent by (output started at \includes\SmartyLight\class.template.php:717) in \includes\functions_html.php on line 1371


any idea?

[Mahesh Slaria]

Originally Posted by ozgurerdogan

Well could you please more clear. I am using win2003 server and can not see any error in event viewer. What is Out of range" issue and how can I fix it.?
Thank you very much for your helps.

The "Out of range value adjusted for column ..." mysql errors are due to MySQL 5 running with a strict sql-mode.

You need to edit /etc/my.cnf and change sql-mode to something like:

sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

It cannot have any of the STRICT options or many of the "meta" modes like TRADITIONAL because that will also include STRICT semantics. See
http://dev.mysql.com/doc/refman/5.0/...-sql-mode.html
for more information.

If problem persists then please provide me admin access to your helpdesk at mahesh.slaria AT kayako.com

Thanks.

Regards,

[ozgurerdogan]

ok I sorted the problem but wondering if I may have any problem in future as I set the value in my.ini file to "NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"