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
Revision history for this message
| mortheres (mortheres) wrote | #1 |
| Changed in ocsinventory-server: | |
| milestone: | none → 2.1.1 |
| status: | New → Fix Committed |
| importance: | Undecided → Medium |
| assignee: | nobody → mortheres (mortheres) |
| 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://
It will be released in 2.1.1 release :) :).
Kind regards,
--
Guillaume