PDA

View Full Version : Error when running reports



homietheclown
08-30-2010, 09:23 AM
I'm getting an error message when I try to run reports in cash games. It says ERROR: 42703: ph.firstpreflopactiontype column doesn't exist or something. And I can't do the fix index thing because there is no firsrpreflopactiontype in the rebuild indexes dialog. Thanks in advance.

Patvs
08-31-2010, 02:07 AM
Update to http://www.holdemmanager.com/downloads/Hm_1.11.05_Beta.exe

Can you create a NEW empty database and reimport the hands.

homietheclown
08-31-2010, 03:18 AM
I did both and I'm still getting the same error.

netsrak
08-31-2010, 04:23 AM
Please try a reindex of your database via pgadminIII->maintenance.

homietheclown
08-31-2010, 11:20 AM
I tried it. Also didn't work.

fozzy71
08-31-2010, 11:01 PM
Then the database is damaged beyond repair.

*Try creating a new UTF DB - FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB - FAQ - Hold'em Manager Poker Tracking Software :: Reinstalling on a new PC - Backup Tips (http://faq.holdemmanager.com/questions/372/Reinstalling+on+a+new+PC+-+Backup+Tips)

Patvs
09-01-2010, 12:34 AM
Which SQL version do you have?
If 8.4--> the 8.4 from installing it using the HoldemManager + PostgreSQL combo installer??---> If yes--> install the 8.4.4 update from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

If 8.3--> install 8.4.4. on port 5433 and connect to that

homietheclown
09-01-2010, 06:23 AM
I installed 8.4.4 created a new DB and imported a single file from the database folder which I exported from PT3 (previously I was importing the whole database) and I got the same problem.

netsrak
09-01-2010, 08:56 AM
Please schedule a remote support session with our support. Email support@holdemmanager.net, with a link to this thread and your forum name, so we can setup a Teamviewer (http://www.holdemmanager.net/teamviewer) session.

homietheclown
09-01-2010, 03:43 PM
support@holdemmanager.net or .com?

fozzy71
09-01-2010, 05:02 PM
Either one, it doesn't matter.