FAQ - SharpStats

1.I keep getting a "database ssm does not exist" error. What's going on?

2.Now I'm getting a "database tourney_master does not exist error" whenever I try to use the rewards page.

3.After importing all of my hand histories, I've noticed that several files have not been moved. Why is this?

4.Why doesn't SharpStats import Cake hand histories from before July 1, 2008?

5.What are the requirements for SharpStats?

6.What do I use for the Server, Port, User ID and password fields?

7.Since upgrading from a beta version of SharpStats 1.01, none of my hand histories will import. What's the problem?

I keep getting a "database ssm does not exist" error. What's going on?

You need to click the Initialize Database button before attempting to import your hand histories.

Now I'm getting a "database tourney_master does not exist error" whenever I try to use the rewards page.

You need to click the Initialize Tournament Database button even if you do not have any tournament hand histories.

After importing all of my hand histories, I've noticed that several files have not been moved. Why is this?

In order to insure that none of your hand histories are damaged, SharpStats will not move any files that have hand histories from the date that they are imported. SharpStats also verifies that a file with the same name does not exist in the working directory before moving the current file.

Why doesn't SharpStats import Cake hand histories from before July 1, 2008?

Right around this date, Cake upgraded their client software to improve the generated hand histories. The hand histories that were created prior to this date were lacking a lot of information that SharpStats uses to display your statitistics.

What are the requirements for SharpStats?

SharpStats requires Microsoft .NET 2.0 or newer and PostgreSQL version 8.3 and newer.

There are no specific hardware requirements. However, a dual-core processor is highly recommended.

What do I use for the Server, Port, User ID and password fields?

99% of people will be able to connect to their PostgreSQL database with the following:

Server: 127.0.0.1

Port: 5432

User ID: postgres

Now, when you installed PostgreSQL, you were prompted to enter a password. Use that password for SharpStats. If you had Poker Tracker or HoldEm Manager install PostgreSQL for you, try 'dbpass' or 'postgrespass' (without the quotes). If you can't remember your password and the HeM and PT passwords don't work, you will need to uninstall PostgreSQL, delete the postgres user, and reinstall PostgreSQL.

Since upgrading from a beta version of SharpStats 1.01, none of my hand histories will import. What's the problem?

This problem was caused by a large code reorganization that occured with v1.01 beta 4. Luckily, there does seem to be a way to correct this.

Uninstall SharpStats

Delete the x:\Program Files\SharpStats Personal Tracker folder

Move all of your archived hand histories out of the [My] Documents\SSPT\Archive folder back into their respective import folders

Delete the [My] Documents\SSPT folder

Install the latest version of SharpStats (v1.01 official at this time)

If you are still having issues, please post a bug report in the forums.