Ticket #266 (assigned enhancement)
MySQL strict mode
| Reported by: | Eugen Božić <bozic.eugen@…> | Owned by: | someotherguy |
|---|---|---|---|
| Priority: | minor | Milestone: | 2.0 |
| Component: | other | Version: | 2.0 Alpha 2 |
| Keywords: | mysql, strict mode | Cc: |
Description
Is Trellis Desk still depending on MySQL strict mode to be off?
I just started testing on my local server (Windows 7 on Zend Server CE - PHP 5.3.0 and MySQL 5.1.40) and when I try to add department I get the following error: 1364: Field "tickets_total" doesn"t have a default value in E:\Zend\Apache2\htdocs\helpdesk_2\includes\classes\class_mysql.php on line 91
Most of the production server have strict mode on, so it may be good idea to change this (al least for sake of better data consistency).
Change History
Note: See
TracTickets for help on using
tickets.