Stuck on version 7.3.7

For users or potential users.
Post Reply
drtmz
Posts: 84
Joined: Thu May 29, 2008 4:27 pm

Stuck on version 7.3.7

Post by drtmz » Sat Nov 06, 2010 11:39 am

Tried to go from 7.3.7 to 7.3.8 and then to 7.4.10 and get this message,
"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 'of account' at line 1.

Had to down grade back to 7.3.7 again. 7.3.7 works fine.

Any ideas?
Tom Zaccaria

teethdood
Posts: 267
Joined: Sun Jul 29, 2007 12:39 am
Location: Visalia, CA
Contact:

Re: Stuck on version 7.3.7

Post by teethdood » Mon Nov 08, 2010 7:07 am

make sure your database folder is a single word (ie. open2) instead of "Copy of Open Dental". Open Dental (or maybe it's MySQL) freaks out when it encounters spaces or weird characters in the name. Try that first.
Philip H. Doan, DDS
http://www.kaweahdental.com/

User avatar
wjstarck
Posts: 936
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: Stuck on version 7.3.7

Post by wjstarck » Mon Nov 08, 2010 7:15 am

FYI, I just did the same upgrade path this morning (7.3.7 - > 7.4.10) and did not have a problem...
Last edited by wjstarck on Thu Nov 11, 2010 2:22 am, edited 1 time in total.
Cheers,

Bill Starck, DDS
Big Idea Software, LLC
Developer, EASy(Electronic Anesthesia System) for Open Dental
817-807-1709
TX, USA

drtmz
Posts: 84
Joined: Thu May 29, 2008 4:27 pm

Re: Stuck on version 7.3.7

Post by drtmz » Tue Nov 09, 2010 1:40 am

Tried to go to the latest version of 7.5 this AM on my test machine and still the same error message.

drtmz

User avatar
jordansparks
Site Admin
Posts: 5744
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Stuck on version 7.3.7

Post by jordansparks » Tue Nov 09, 2010 5:41 pm

Then we'll need a copy of your database to test on our end.
Jordan Sparks, DMD
http://www.opendental.com

drtmz
Posts: 84
Joined: Thu May 29, 2008 4:27 pm

Re: Stuck on version 7.3.7

Post by drtmz » Wed Nov 10, 2010 3:20 pm

Called OD support today for the purpose of having them upload a copy of our database as Jordan suggested.
But then with the help of #11 Britt and #13 Luke we were able to upgrade our server from 7.3.7 to 7.4.10 with no problem.

Backed up the office data, came home and was able to restore the current data to my home machine.

So there is no longer a problem. Must have been gremlins.

drtmz
(Tell me where else you can get this kind of support.)

Post Reply