tempfambal error

[glamorgan]

Hi everyone; OD keeps breaking when we open the account module and refers to a table called "tempfambal", the error goes only when we delete this table. The error will go for couple of days but comes back every couple of days...
How can we permenatly avoid this?

[jsalmon]

Open Dental creates that table, uses it, and instantly deletes it. It should never stay in your database. When it does, it most likely is due to not having MySQL 5.5 installed (you must be at OD v7.8 or higher), not running Open Dental as an administrator, OR having MySQL users set up with your MySQL installation and some user does not have DROP TABLE permission.

[jsalmon]

And if all that doesn't fix it, you can always just update to our latest stable version (v12.3) which tacks on a random string to the end of that table name. That way the odds of two of the same tables is exponentially less likely to occur but then your database may get flooded with tables like "tempfambal12346789" which is not acceptable in my opinion but it will allow you to work through the work week and then you can delete these tables when YOU'RE ready to, not when it wants you to.

[glamorgan]

Yes, this error does not show with v12!
Thanks