6.3 to 6.4 Conversion Problem

[DrT]

I am getting corrupted database converting from OD ver. 6.3 to ver. 6.4 with the message "Table 'opendental.autonote' doesn't exist."

[jordansparks]

Is your MySQL username and password still root and (blank)? Those were the defaults that the program shipped with
http://www.opendental.com/manual/choosedatabase.html

Did you install MySQL using our installer, or did you do it yourself separately? Are you using Linux?

[DrT]

Thank you for your quick reply.
Yes, I install MySQl 5 on Ubuntu (Linux) as a file server. I converted an existing database (ver. 5.6) to ver. 5.9, 6.2 and 6.3 successfully. And when I converted the database from ver. 6.3 to ver. 6.4, I got the error message mentioned above.

[DrT]

I looked in the existing database and noticed that there is no autonote file. Should there be an autonote file in the opendental mysql database in ver. 5.6?

[jordansparks]

Your MySQL permissions are wrong.
http://www.opendental.com/manual/passwordsmysql.html
Or the permissions for the mysql data directory are wrong. Try chmod 777.

This could all be avoided by installing on Windows.

[DrT]

I manually set mysql user and password as root and (blank). I chmod 777 the mysql data directory. I was able to convert from version 5.6 to 6.3 with no problem. Only when I try to convert to version 6.4 and above do I get the error message.

[jordansparks]

The autonote table was created in version 5.1. So this means to me that you are missing file(s) from your database. Look at your database files. Are there any autonote files? There should be three of them. Files can go missing if you used poor backup software that skips empty files. You can get the missing files from our trial version installation as long as there was no data in them.

[DrT]

Thank you Dr. Sparks for your help.

I went back to an older opendental db ver.4.9 and converted to ver. 5.6. I then extracted the 6 autonote files and place them in the existing database (ver. 5.6) and did the conversion. The conversion went smoothly up to version 6.5. I will try to further convert to version 6.9 when I have the time. Thank you again for you help.

Tom

[Justin Shafer]

I used to have this problem upgrading the database with the linux server. I had to reset the grant tables in mysql I think.. was a couple of years ago... Restoring the database shouldnt affect the grant tables in mysql though.. could be a conversion problem.. but dont rule out the grant tables... I believe I also had a bug with mysql around that time as well, and I downgraded it...