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 »

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 »

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: 949
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Re: Stuck on version 7.3.7

Post by wjstarck »

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 »

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: 5776
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

Re: Stuck on version 7.3.7

Post by jordansparks »

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 »

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