Open Dental Forum

Replication in version 11.0 was broken with the following error: Error 'Duplicate entry '0' for key 'PRIMARY'' on query. Default database: 'opendental'. Query: 'INSERT INTO tempused SELECT patplan.PatPlanNum, SUM(IFNULL(claimproc.InsPayAmt,0)) FROM claimproc LEFT JOIN patplan ON patplan.PatNum = cla...

I tried it yesterday and it worked! I clicked the scan photo button on the image screen. First, I was asked to choose the TWAIN driver (equipment). Then, I got an error message from Open Dental saying that the equipment is not compatible. I closed that and was transferred to the TWAIN driver (Sirona...

Can Open Dental acquire image from digital X-ray equipment and store it in the patient's image folder if that equipment has a Twain driver (Sirona)? If not, what is the different between that and acquiring images from scanner? If it can, what is the procedure to acquire the image if the driver has b...

We are doing replication between offices and interested in setting up Web Services to deal with possible server outage at one office. Can each office have a web service running on the local database? How is updating going to work with replication running? The data folders are also on real times wind...

Can we get out of using random key to use key range for servers featured in version 6.8.? Is there any advantage to do so if it is possible to switch to using key range?

Thank you Dr. Sparks.

We recently updated from 6.4 to 6.6. Since then, we have experienced two breaks in our daisy chain servers. It appears to be related to aging activity and specifically creating or deleting temporary tables. The MySQL error log from the down stream server (the server not running the aging activities)...

You can set up a circular replicating servers system. If one server goes down then connect to the other server to continue to work.

I thought the model was that a MySQL database capable of being connected directly from any Windows workstation as well as ANY web service server. Then, any work station can connect to any Web Service Server. Am I mistaken?

In a Linux MySQL server and Windows Web Service setup which computer need more processing power? Can multiple Web Service servers run simultaneously for load distribution and redundancy? How do we handle billing for multiple offices with different addresses on one database? Can we choose office addr...

Can Web Service be run on a Linux Server? We have MySQL and Samba ( for image folder) running under Linux and they are working extremely well. We wish to replace chain replication some day with Web service as the solution to Multiple Offices. It would be nice if we don't have to invoke a Windows Ser...

No, it did not work. Probably because of the bug itself.
OD actually will look at the folder entered in the first (all computers) box only for images.

Dr. Sparks: We are using OD version 5.6.14. If we leave the data path for all workstations blank and just specify the correct data path in the box that is specific for each workstation, we are able to start OD(it recognizes the data folder). However, once we are in and try to access an image files, ...

Sorry, Version 5.5.14

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 CodeN...

Table tempfambal still breaks circular replication in version 5.3.17. Will it need random key if not clear out after use ?

I like to plug for circular replication. Inter-sites communication is getting faster, cheaper and more reliable all the time. Propagation times will be better and therefore A>>B>>....>>Z or beyond may be practical in the near future. Set up also much easier since each site have to communicate only t...

I had to look to the log files to see which slave was stopped. Then, I used the global skip-counter / slave start statements until slave is running again (it skipped creating the tempfambal table and 3 records of that table). Now knowing that the table can be deleted, I can simply drop the table and...

Table tempfambal breaks circular replication with the following error in mysqld.log: 071112 9:21:05 [ERROR] Slave: Error 'Table 'tempfambal' already exists' on query. Default database: 'opendental'. Query: 'CREATE TABLE tempfambal( FamBalNum int NOT NULL auto_increment, PatNum int NOT NULL, ProvNum ...

You analysis is absolutely on the point! Yes, we use circularly link databases and automatically replicating image folders. We have not used the clinic feature and will look into turning it on. Features 1 and 2 would be great for us. We already have two separate accounts for the clearing house so 1 ...

We had similar massive slow down after upgrading to 5.0 and the to 5.1.
After the appointment module was optimized for speed in version 5.2, the problem is gone. Thank you Dr. Sparks.

We can not centralize billing operation in one office because we can not specify which office address to go on the e-claim (Claim-Connect) nor can we select the clearing house to send the claim to. The default setting dictates the address and which clearing house to send claims. The only way to do i...

Dr. Spark: Can you E-mail me the update code for version 5.2. I would like to check the improvement of the appointment module speed. I must do update to new version at weekend but it is impossible to get the update code then. Can you start a service of sending subscribers announcement of new product...

We have two offices A and B. They use the same OD database replicated circularly. However, office A computers point to local image folder IA and office B computers point to local image folder IB for speed purpose. People in office A can see data and images of patients seen in their office and can se...