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?
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?