PDA

View Full Version : Cannot create HM database



jurrr
07-26-2009, 07:35 AM
I'm on 1.09 beta 20.

a) My current DB seems corrupt.

The hands aren't being imported and I get tons of errors:
C:\Games\UB_mine\histories\batch_956.txt ERROR: 25P02: current
transaction is aborted, commands ignored until end of transaction
block

Also, somehow some duplicate hands are present in the database. And
many hands are missing due to the import problems.

b) I decided to recreate the DB as I get the following error:

------------------------------
DB Control Panel
------------------------------
The following error occurred when trying to initialize the Holdem Manager database: ERROR: XX000: encoding SQL_ASCII does not match server's locale English_United States.1252
------------------------------
[OK]
------------------------------

FWIW my old HM database had an UTF8 encoding and I suspect when I installed Posgres (which was also for other, not only HM purposes) I specified UTF8 as the default encoding.


Any advice?

netsrak
07-26-2009, 09:55 AM
See page 2 in this thread: http://www.holdemmanager.net/forum/showthread.php?t=12925