Two Plus Two Publishing LLC Two Plus Two Publishing LLC
 

Go Back   Two Plus Two Poker Forums > >

Poker Software Poker-related software official support, e.g., poker trackers, solvers, equity calculators.

Closed Thread
 
Thread Tools Display Modes
Old 04-18-2008, 09:17 PM   #1126
coxquinn
Pooh-Bah
 
coxquinn's Avatar
 
Join Date: Sep 2005
Location: stuck in craving and aversion
Posts: 3,729
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by Stefan_K View Post
I'm having problem with the newest PT3 database (one with HUD). I have 1 database conected to spade eye and when i scan it goes throgh first 20% of the tables @ nl100 pp then i get the error message:
"Your database is probably not configured correct with SpadeEye .FETCH ALL failed: ERROR: current transaction is aborted, commands ignored until end of transaction block"
followed by
"Your database is probably not conf correct with SpadeEye .BEGIN command failed: ERROR: current tranaction is aborted, commands ignored until end of transacion block"

After that it scans but putting all players as unknown.

I've used SpadeEye pretty much and it has been working fine with all the other pt3 databases but this one is like a little bit then a mill hand. I've tried to rebot the computer but doesn't work. It might have been started after i've vacum, analysed and cluster the database from pt3. The database is working in pt3 at least for my own hands.

Hope this gives you enogh info
I'm having this problem too
coxquinn is offline  
Old 04-18-2008, 09:19 PM   #1127
coxquinn
Pooh-Bah
 
coxquinn's Avatar
 
Join Date: Sep 2005
Location: stuck in craving and aversion
Posts: 3,729
Re: New Software SpadeEye: Tableselection (@PP)

"Your database is probably not conf correct w/ SpadeEye
.ERROR: relation "players" does not exist""
coxquinn is offline  
Old 04-19-2008, 02:48 AM   #1128
HighSteaks
veteran
 
HighSteaks's Avatar
 
Join Date: Aug 2006
Location: Australia
Posts: 3,386
Re: New Software SpadeEye: Tableselection (@PP)

Exclude Speed tables from search is not working on Party.
HighSteaks is offline  
Old 04-20-2008, 06:23 PM   #1129
lingdog
centurion
 
lingdog's Avatar
 
Join Date: Aug 2007
Location: www.bestgolfinginstructions.com
Posts: 167
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by Stefan_K View Post
I'm having problem with the newest PT3 database (one with HUD). I have 1 database conected to spade eye and when i scan it goes throgh first 20% of the tables @ nl100 pp then i get the error message:
"Your database is probably not configured correct with SpadeEye .FETCH ALL failed: ERROR: current transaction is aborted, commands ignored until end of transaction block"
followed by
"Your database is probably not conf correct with SpadeEye .BEGIN command failed: ERROR: current tranaction is aborted, commands ignored until end of transacion block"

After that it scans but putting all players as unknown.

I've used SpadeEye pretty much and it has been working fine with all the other pt3 databases but this one is like a little bit then a mill hand. I've tried to rebot the computer but doesn't work. It might have been started after i've vacum, analysed and cluster the database from pt3. The database is working in pt3 at least for my own hands.

Hope this gives you enogh info
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
lingdog is offline  
Old 04-22-2008, 05:05 PM   #1130
lingdog
centurion
 
lingdog's Avatar
 
Join Date: Aug 2007
Location: www.bestgolfinginstructions.com
Posts: 167
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by lingdog View Post
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
lingdog is offline  
Old 04-22-2008, 05:47 PM   #1131
ClutchCity
banned
 
ClutchCity's Avatar
 
Join Date: Nov 2007
Location: SSNL4Life
Posts: 3,537
Re: New Software SpadeEye: Tableselection (@PP)

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?

Last edited by ClutchCity; 04-22-2008 at 06:09 PM.
ClutchCity is offline  
Old 04-22-2008, 06:58 PM   #1132
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by coxquinn View Post
"Your database is probably not conf correct w/ SpadeEye
.ERROR: relation "players" does not exist""
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.
Mr_Snood is offline  
Old 04-22-2008, 07:01 PM   #1133
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by ClutchCity View Post
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?
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.
Mr_Snood is offline  
Old 04-22-2008, 07:02 PM   #1134
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by lingdog View Post
mr snood, any update with this error? sorry for being impatient
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 is offline  
Old 04-22-2008, 07:18 PM   #1135
ClutchCity
banned
 
ClutchCity's Avatar
 
Join Date: Nov 2007
Location: SSNL4Life
Posts: 3,537
Re: New Software SpadeEye: Tableselection (@PP)

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
ClutchCity is offline  
Old 04-22-2008, 10:36 PM   #1136
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

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.
Mr_Snood is offline  
Old 04-23-2008, 12:03 AM   #1137
ICMoney
Carpal \'Tunnel
 
ICMoney's Avatar
 
Join Date: Sep 2005
Location: Honesty IS the best policy.
Posts: 8,280
Re: New Software SpadeEye: Tableselection (@PP)

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.
ICMoney is offline  
Old 04-23-2008, 09:40 AM   #1138
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by coxquinn View Post
"Your database is probably not conf correct w/ SpadeEye
.ERROR: relation "players" does not exist""
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?
Mr_Snood is offline  
Old 04-23-2008, 12:21 PM   #1139
BetYourLife
grinder
 
Join Date: Sep 2006
Posts: 518
Re: New Software SpadeEye: Tableselection (@PP)

Already working w/ PT3?
BetYourLife is offline  
Old 04-24-2008, 11:01 AM   #1140
iSTRONG
Pooh-Bah
 
iSTRONG's Avatar
 
Join Date: Sep 2004
Posts: 5,731
Re: New Software SpadeEye: Tableselection (@PP)

scanning with spadeye is extremely slow for me with a PT3 database. Much slower than w/ PT2... any idea why?
iSTRONG is offline  
Old 04-24-2008, 01:10 PM   #1141
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

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?
Mr_Snood is offline  
Old 04-24-2008, 01:10 PM   #1142
Mr_Snood
old hand
 
Join Date: Mar 2005
Location: Germany
Posts: 1,415
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by BetYourLife View Post
Already working w/ PT3?
Yes, any problems?
Mr_Snood is offline  
Old 04-24-2008, 02:32 PM   #1143
iSTRONG
Pooh-Bah
 
iSTRONG's Avatar
 
Join Date: Sep 2004
Posts: 5,731
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by Mr_Snood View Post

Not sure about latest PT3 beta, but i guess the database structure won't change anymore?
incorrect.
iSTRONG is offline  
Old 04-28-2008, 03:13 PM   #1144
frumpus
journeyman
 
frumpus's Avatar
 
Join Date: Apr 2008
Location: folding for value
Posts: 346
Re: New Software SpadeEye: Tableselection (@PP)

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?
frumpus is offline  
Old 04-28-2008, 09:45 PM   #1145
iSTRONG
Pooh-Bah
 
iSTRONG's Avatar
 
Join Date: Sep 2004
Posts: 5,731
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by Mr_Snood View Post
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?
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.
iSTRONG is offline  
Old 04-29-2008, 08:44 AM   #1146
garvin
centurion
 
Join Date: Feb 2006
Posts: 119
Re: New Software SpadeEye: Tableselection (@PP)

Quote:
Originally Posted by iSTRONG View Post
I've isolated the problem. it seems that scanning is very slow only when PT3 is auto-importing.
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.
garvin is offline  
Old 04-29-2008, 09:09 AM   #1147
iSTRONG
Pooh-Bah
 
iSTRONG's Avatar
 
Join Date: Sep 2004
Posts: 5,731
Re: New Software SpadeEye: Tableselection (@PP)

Interesting.

MrSnood,
If you need a large database (10M hands+) for testing I can provide you w/ that.
iSTRONG is offline  
Old 04-29-2008, 09:56 AM   #1148
doytollovski
stranger
 
Join Date: Mar 2008
Posts: 3
Re: New Software SpadeEye: Tableselection (@PP)

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? .....
doytollovski is offline  
Old 04-29-2008, 04:56 PM   #1149
Stosh
old hand
 
Stosh's Avatar
 
Join Date: Nov 2004
Posts: 1,254
Re: New Software SpadeEye: Tableselection (@PP)

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?
Stosh is offline  
Old 04-29-2008, 07:24 PM   #1150
ddubois
Carpal \'Tunnel
 
ddubois's Avatar
 
Join Date: Jan 2004
Location: Coconut Creek, FL
Posts: 7,695
Re: New Software SpadeEye: Tableselection (@PP)

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

Closed Thread
      

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Forum Jump


All times are GMT -4. The time now is 02:15 PM.


Powered by vBulletin®
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright © 2008-2020, Two Plus Two Interactive