installation

[frknml]

I'm very new for open dental and i want to develope this program so before developing i have to learn how opendental works.I have installed perfectly but when i try to open and use opendental "choose database screen" comes and it gives an "Keyword not supported.Parameter name:user id" error please inform me how can i solve this problem? I'm looking forward to hearing your reply.

[jordansparks]

I think you didn't install MySQL using our installer. In the installer window, check the my.ini box and just run that. If that doesn't work, then uninstall MySQL entirely, and try that part of it again using our installer.

[frknml]

Thanks for your reply,I have installed with opendental installer and i have my.ini file morever i wrote below what written on the my.ini please check.

[mysqld]
basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
datadir="C:/mysql/data/"
skip-innodb

[jordansparks]

You are not the first with this problem:
http://70.90.133.65/forum/viewtopic.php ... r+id#p5347
I'll ask around on Monday and see what the solution is.

[frknml]

I read this topic and i couldn't find the solution, can anybody help me?

[wjstarck]

What language are you trying to use OD in?

[frknml]

i will use open dental in english,but my operating system is turkish.

[wjstarck]

That's what I thought.

There was a bug in MySQL at one time, that gave this error in particular, with Turkish, although it was supposed to have been resolved. You might try setting your computer settings to English temporarily to see if the problem goes away. That would at least give you a hint.

Read more here:

http://bugs.mysql.com/bug.php?id=26147

[nathansparks]

I received one email from a user with XP set to turkish who had the same issue, about 3 months ago, no resolution, I will see if I can find anything out on the mysql website.

Nathan

[nathansparks]

'I' and 'i' are different characters in the turkish character set, and there is an i in 'userid', I know that does not help much, I would concur with changing from turkish to english and seeing if the problem goes away, then we can look for a solution.

"function configure sets names in "latin5" so the server returns results in "latin5", and
function GetOrdinal() tries to Compare to value "id" against the value "Id" but be warn
before the comparing, all strings converted to lower case and i can say; in turkish
alphabet char 'I' and 'i' aren't same unlike the English alphabet, they are two different
characters, in this statement, the driver try to compare "id" against ıd" so the
exception is inevitable

Note: Consider the following characters

char in UPPERCASE -> 'I', in lowercase -> 'ı'
char in UPPERCASE -> 'İ', in lowercase -> 'i' "

[frknml]

Thanks for your replies friends i will try it in my english os.

[frknml]

I have solved my problem i reinstalled mysql with latin1, after i had installed mysql the choose database screen can't find the opendental database and i copied opendental database under this path C:\Program Files\MySQL\MySQL Server 5.0\data and opendental was opened.