Page 1 of 1

Database conversion error

PostPosted: Tue Aug 12, 2008 4:49 am
by richardc
Hello - I'm getting an error when I try to convert my pokerstars (about 50,000 hands) access database to SQL. I've installed PostgreSQL vers. 8.3 and successfully converted a (smaller) Party database with no problem. The problem happens late in the conversion process when it is creating indexes with the error message:
Error creating index - game_players_idx_01
7 - SQLSTATE = 235050 ERROR: could not create unique index
Table contains duplicated values; Error while executing the query.

FYI PT version is 2.17.02 & I'm running windows on a Parallel's virtual machine on a Mac.

Thanks in advance Pat / all for help on this matter.

Richard C

Re: Database conversion error

PostPosted: Tue Aug 12, 2008 8:42 am
by ptrack pat
Open the File > Maintain Database Names window, double-click the name field of this database you are trying to convert. What is the file size and name that shows in the window that opens?

Re: Database conversion error

PostPosted: Tue Aug 12, 2008 7:52 pm
by richardc
ptrack3.mdb
196,358KB

Re: Database conversion error

PostPosted: Tue Aug 12, 2008 7:54 pm
by richardc
Just had a thought - it's the default open database, is being open going to cause a conversion problem?
RC

Re: Database conversion error

PostPosted: Tue Aug 12, 2008 8:53 pm
by ptrack pat
No, that wouldn't cause it. If you can ZIP that file, I'll PM you with directions on how to send it to me.

highfalutin