Open Dental Forum

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.

What version?

Sorry, Version 5.5.14

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.