Circular replication was broken with the following code:
080314 14:07:57 [ERROR] Slave: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1',BaseUnits = '0',SubstitutionCode = '',SubstOnlyIf = '0' WHERE CodeNum = '183'' at line 1' on query. Default database: 'opendental'. Query: 'UPDATE procedurecode SET descript = 'malar and/or isting = '1',BaseUnits = '0',SubstitutionCode = '',SubstOnlyIf = '0' WHERE CodeNum = '183'&', Error_code: 1064
080314 14:07:57 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000023' position 165925385
This has happened twice. Please check.
Report: Error code breaking circular replication
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: Report: Error code breaking circular replication
What version?
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com
Re: Report: Error code breaking circular replication
Sorry, Version 5.5.14
- jordansparks
- Site Admin
- Posts: 5770
- Joined: Sun Jun 17, 2007 3:59 pm
- Location: Salem, Oregon
- Contact:
Re: Report: Error code breaking circular replication
I wish I could see the whole query because it looks fine other than that strange character after the 183. Look to see if you have any duplicate ProcCode entries related to CodeNum 183, like maybe same ProcCode on each db, but with two different CodeNums. I'm not really sure. Let me know what you find out.
Jordan Sparks, DMD
http://www.opendental.com
http://www.opendental.com