need some help

Any support related posts should go here.

need some help

Postby mattyg89 » Tue Sep 21, 2010 9:56 am

Hello new to poker tracker software im having trouble with my auto import it comes up with this in red

Fatal Exception during Auto-Import process: Unable to execute query: INSERT INTO player VALUES (0, 0, '[Split Pot]', '[Split Pot]', 0, 0, 0, FALSE);; Reason: Fatal Error (ERROR: invalid page header in block 214 of relation "player" )

Have no idea what to do so come help will be appreciated
mattyg89
 
Posts: 2
Joined: Tue Sep 21, 2010 9:06 am

Re: need some help

Postby kraada » Tue Sep 21, 2010 10:22 am

There are two main reasons for this kind of error. The first is a result of data corruption from a computer crash that requires reindexing your database. You can reindex your database from the Database Management window - it may take a while but shouldn't take more than an hour or two unless your database is very large.

The second reason for this error is a result of faulty hardware. You can set PostgreSQL to ignore these errors by clicking Start --> Programs --> PostgreSQL --> Configuration Files --> Edit postgresql.conf. In the configuration file that appears, go to the bottom of the file and add the text “zero_damaged_pages = on” on a new line and then save and close the file. Click Start --> Programs --> PostgreSQL --> Reload Configuration and PostgreSQL will ignore the damaged data. If you continue to have problems with that hard drive, you should consider replacing it.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: need some help

Postby mattyg89 » Tue Sep 21, 2010 1:34 pm

thanks for your help, it seems to be working nicely now
mattyg89
 
Posts: 2
Joined: Tue Sep 21, 2010 9:06 am


Return to PTH Support

Who is online

Users browsing this forum: No registered users and 4 guests

cron
highfalutin