I'm having this problem too

"Your database is probably not conf correct w/ SpadeEye
.ERROR: relation "players" does not exist""

Exclude Speed tables from search is not working on Party.

i am having the same problem, everytime i try to scan tables, i get "FETCH ALL failed: ERROR: current transaction is aborted, commands ignored until end of transaction block" and "BEGIN command failed: ERROR: current tranaction is aborted, commands ignored until end of transacion block" i am also using PT3 with hud

mr snood, any update with this error? sorry for being impatient

Nevermind I figured out my question.

I do have another, though. When running spade eye to Datamine, you have to your PT auto importing at the same time, of course, right? At the initial setup, I chose for the hands to be moved to the folder where my HH's are stored. Is it redundant to have that setup for the mine in SpadeEye while at the same time having that folder being the one specified while the PT import is going?

This sounds like if you set the database type to "Pokertracker (postgresql)" instead of "Pokertracker 3".
Please take a closer look at "Main->options->databases" to verify this.

Just make sure you set a destination directory in SpadeEye, where your PokerTracker autoimport looks for them.
I suggest you to use the following settings for datamining PartyPoker:
- "Destination directory" should be set to your PartyPoker handhistory directory: "[...]PartyGaming\PartyPoker\HandHistory".
- Extension should be set to "txt".
With this setting the Pokertracker autoimport should be able to find the correct files.

Sorry not yet, but a new SpadeEye version is in the works
Most things will affect bug fixing, so i will set up a PT3 database and try to find the reason for this error, too.

Mr. Snood,

Thanks for your response. One more thing...

I'm kinda pressed for time, so I don't wanna go search through the thread.... but will if this gets ignored because it's been asked a million times.

I wanna experiment with SpadeEye for a while before I determine if it's worth purchasing. Will I be able to run it for a while (to datamine) and see how it works before I buy it? I tried using it to datamine a while ago and it opened up the tables, but it didn't display any information, table or player, in the main window. Is that because I didn't purchase it yet or setup mistake by me? Thanks again

During the trial period you can use SpadeEye without constraints.
When the trial period ends (after 1 week) then you wont be able to run SpadeEye anymore, unless you register or ask me for another trial period

When you datamine with SpadeEye then it only takes care of retrieving the handhistoriy files of observed tables.
It is up to you, to import the files into a database.

To get a use of the numbers and see the table and player information, you need to run a "scan".
What pokerroom do you want to use SpadeEye?
You need to configure your database in "Main->options->databases" (http://www.spadeit.com/guide.php#sql) and set the SpadeEye "filter" (select "6 max/fullring", stake...).

When you press "Scan all tables" then it will list all tables and players along with their statistics.
This will not happen during the datamining.

Is there a way to cache player scores even after I close the program?

It is taking over 15 mins to score some 100nl tables that I'm trying out.

Can anybody with this problem please email (support@spadeit.com) or show me a screenshot of
"Main->options->databases"
in SpadeEye please?

What SpadeEye version do you use?

Already working w/ PT3?

scanning with spadeye is extremely slow for me with a PT3 database. Much slower than w/ PT2... any idea why?

Thats not only the case at you.
Got several complaints about that.
Seem like the new PT3 database is not very "scanner friendly", as my queries are not that bad, i think.
I need to see if i can improve them...

Not sure about latest PT3 beta, but i guess the database structure won't change anymore?

Yes, any problems?

incorrect.

Datamining does not seem to be working reliably with FTP. I got it set up and gave it the correct path to the hand history folder and started the dataminer. It did start putting files in the hand history folder but stopped after just a few minutes and now it doesn't seem to be doing anything at all, the hand history folder remains untouched. Any thoughts or suggestions? Is FTP blocking this?

I've isolated the problem. it seems that scanning is very slow only when PT3 is auto-importing. It's slow even if I'm scanning using PT2 Databases, while PT3 is auto-importing in another DB.

I am sure that affects the speed, but that isn't the only problem. I have imported a large number of hands (> 1.000.000 hands) into both a PT2 db and a PT3 db and then ran SpadeEye to scan (this was on Stars). PT3 SpadeEye solution is much slower, and not usable (on a large DB, it isnt noticable on smaller databases and thus not a problem then).

I am not saying this is due to faulty implementation of SpadeEye (nor of PT3), but probably due to the enhanced information structure stored in PT3. I havent been able to study the schema to see if theres any optimization to be made - I certainly hope so. I would certainly be willing to let go of some data shown in SpadeEye if that makes the search faster (i.e. avoid one or more JOINs of tables).

I guess the only other way to go is some advanced caching solution, or to create an intermediate DB a la PTAGG. But it would be good if it could work with current app structure because it is so smooth to use.

Interesting.

MrSnood,
If you need a large database (10M hands+) for testing I can provide you w/ that.

hi, im trying to datamining on FTP ... But FTP makes .tmp files.... and the PT doesn`t find any hand.............. how can i fix it? .....

Correct me if I'm mistaken. Wasn't it said a while back that scanning SpadeEye/Telescope, etc through Holdem Manager was very fast compared to PT2?

http://www.pokerstars.com/poker/room/prohibited/ lists SpadeEye as being prohibited.