SQL breaks Mysql-Replication
Bug #1315004 reported by
DerJoern
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
OCS Inventory: Server |
Fix Released
|
Medium
|
mortheres |
Bug Description
Hi!
While migrating to mysql 5.6 an error occurs which breaks mysql replication for the ocs database:
Last_SQL_Error: Error 'Column 'SINCE' cannot be null' on query. Default database: 'ocsweb'. Query: 'INSERT INTO locks(HARDWARE_ID, ID, SINCE) VALUES(
By changing Ocsinventory/
INSERT INTO locks(HARDWARE_ID, ID, SINCE) VALUES(?,?,NULL)
to
INSERT INTO locks(HARDWARE_ID, ID, SINCE) VALUES(?,?,NOW())
everything is fine now.
Best regards Jörn
Changed in ocsinventory-server: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Hi,
Thanks a lot for your report.
The fix has been commited in revison 725 of the stable-2.1 branch: http:// bazaar. launchpad. net/~ocsinvento ry-dev/ ocsinventory- server/ stable- 2.1/revision/ 725 .
It will be released in 2.1.1 release :) :).
Kind regards,
--
Guillaume