PDA

View Full Version : database error



DrLazerRage
10-27-2011, 12:58 PM
hi, i have a little problem with my postgres database (or with something else?)
Hud/autoimport was working fine, but when i wanted to review my hands i noticed theres no hands displayed in the reports/session tabs. I can see the number of hands played before, but the individual hands are not displayed:
30561

i havent noticed any of these problems with an other databese, so i decided to export these hands, and create a new databese (my further plans included to import the hands into the new database of course :) , but:
30591

log:
sqlerrors attached

optimizing the DB wasnt working either:

[2011.10.27. 18:02] Reading databases . . .done
[2011.10.27. 18:02] Starting optimization
[2011.10.27. 18:02] Optimizing holdemmanager...done
[2011.10.27. 18:10] Optimizing SSD-handhq-0622...done
[2011.10.27. 18:22] error: ERROR: XX001: invalid page header in block 706 of relation base/16817/16901[2011.10.27. 18:22] error: at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__a.MoveNext()
at Npgsql.ForwardsOnlyDataReader.GetNextResponseObjec t()
at Npgsql.ForwardsOnlyDataReader.GetNextRowDescriptio n()
at Npgsql.ForwardsOnlyDataReader.NextResult()
at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean synchOnReadError)
at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
at Npgsql.NpgsqlCommand.ExecuteNonQuery()
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeDb(String db, Int32 type)
at HoldemManagerDatabaseMaintenance.MainScreen.optimi zeAsync()[2011.10.27. 18:22] Error...please contact support@holdemmanager.com


So is there any way to use the hands of this database?
(sorry for my english :)

Patvs
10-28-2011, 02:04 AM
Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe

It looks like a corrupted database.
Create a new database and reimport your handhistories.

set the date formatting of your computer to M/d/yyyy (and not to European default d/M/yyyy)
and clear filters (even though it appears no filters are selected)