Open Side Menu Go to the Top
Register
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013

03-31-2009 , 06:20 PM
It looks like its trying to connect to a MySQL db. I want it to connect to postgres because I have postgres installed already.

I attempted to install MySQL 4 times, every time I get an error when it attempts to apply the security settings and will not complete the install. I opened up the TCP 3306 port on Windows Firewall, and even shut off the firewall completely. Still to no avail.

I'd prefer to get this working on postgres, but it appears as though I will have to change some things as it defaults to MySQL???

Haven't found anything on the forums regarding this yet. Anyone else know where I might find out how to do this?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-31-2009 , 06:55 PM
Do I need to be changing things in my 'Configuration.py' file in order to switch this over to postressql?

A comprehensive tutorial on how to set this up in postgressql would be great. It appears as though there is quite a bit of changing that needs to take place in various files for this program to work with postgressql.

Where do I start?

Thanks again
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-31-2009 , 06:56 PM
Quote:
Originally Posted by RainmanTrail
Here is what I'm getting:

Traceback (most recent call last):
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 464, in <module>
me = fpdb()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 377, in __init__
self.load_profile()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 275, in load_profile
self.settings['db-password'])
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_db.p y", line 65, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1044, "Access denied for user ''@'localhost' to database 'fpdb'")
made some changes, now getting this error:
Traceback (most recent call last):
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 464, in <module>
me = fpdb()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 376, in __init__
self.config = Configuration.Config()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\Configura tion.py", line 287, in __init__
if db['db-password'] == 'YOUR MYSQL PASSWORD':
KeyError: 'db-password'
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-31-2009 , 08:05 PM
Quote:
Originally Posted by RainmanTrail
Here is what I'm getting:

Traceback (most recent call last):
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 464, in <module>
me = fpdb()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 377, in __init__
self.load_profile()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 275, in load_profile
self.settings['db-password'])
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_db.p y", line 65, in connect
self.db=MySQLdb.connect(host = host, user = user, passwd = password, db = database)
File "C:\Python25\lib\site-packages\MySQLdb\__init__.py", line 74, in Connect
return Connection(*args, **kwargs)
File "C:\Python25\lib\site-packages\MySQLdb\connections.py", line 170, in __init__
super(Connection, self).__init__(*args, **kwargs2)
_mysql_exceptions.OperationalError: (1044, "Access denied for user ''@'localhost' to database 'fpdb'")
This looks like you have mysql running but do not have the correct db, user, or password set up. Here is a step-by-step guide for setting up mysql for use with fpdb.

If you don't have mysql running you can use postgres. You have to create an empty database with proper permissions. You would then edit your database element in the config file to be:
Code:
<database db_ip="localhost" db_name="fpdb-pg-local" db_pass="YourPassword" db_server="postgresql" db_type="fpdb" db_user="fpdb">    </database>
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
03-31-2009 , 08:12 PM
Quote:
Originally Posted by RainmanTrail
made some changes, now getting this error:
Traceback (most recent call last):
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 464, in <module>
me = fpdb()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py", line 376, in __init__
self.config = Configuration.Config()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\Configura tion.py", line 287, in __init__
if db['db-password'] == 'YOUR MYSQL PASSWORD':
KeyError: 'db-password'
This indicates a problem in your config file. I suspect that taking a close look at the link in my previous post will help. You should have a HUD_config.xml file in your c:\Documents and Settings\Travis\Applications Data\fpdb folder.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-01-2009 , 11:18 AM
Quote:
Originally Posted by Eratosthenes
This indicates a problem in your config file. I suspect that taking a close look at the link in my previous post will help. You should have a HUD_config.xml file in your c:\Documents and Settings\Travis\Applications Data\fpdb folder.
Thanks for your help, I finally have a running version using MySQL instead of postgres

I do however have a new error in the error file, it says this at startup:

C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py:2 47: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)

and it adds this error when I attempt to import a hh file from my full tilt folder:

C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py:2 47: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
TypeError: not_implemented() takes exactly 1 argument (3 given)
TypeError: not_implemented() takes exactly 1 argument (3 given)
C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\GuiAutoIm port.py:92: GtkWarning: gtk_file_system_win32_get_parent: assertion `g_path_is_absolute (filename)' failed
dia_chooser.set_filename(current_path)
C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\GuiBulkIm port.py:93: GtkWarning: gtk_file_system_win32_get_parent: assertion `g_path_is_absolute (filename)' failed
self.chooser.set_filename(self.settings['bulkImport-defaultPath'])


any ideas? Thanks again
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-01-2009 , 01:10 PM
if I just open the program and try to import bulk, this is what I get:

C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb.py:2 47: DeprecationWarning: use gtk.UIManager
self.item_factory = gtk.ItemFactory(gtk.MenuBar, "<main>", accel_group)
C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\GuiBulkIm port.py:93: GtkWarning: gtk_file_system_win32_get_parent: assertion `g_path_is_absolute (filename)' failed
self.chooser.set_filename(self.settings['bulkImport-defaultPath'])
Traceback (most recent call last):
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\GuiBulkIm port.py", line 71, in load_clicked
self.importer.runImport()
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_impo rt.py", line 122, in runImport
(stored, duplicates, partial, errors, ttime) = self.import_file_dict(file, self.filelist[file][0], self.filelist[file][1])
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_impo rt.py", line 157, in import_file_dict
(stored, duplicates, partial, errors, ttime) = self.import_fpdb_file(file, site)
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_impo rt.py", line 193, in import_fpdb_file
site=fpdb_simple.recogniseSite(firstline)
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_simp le.py", line 1559, in recogniseSite
raise FpdbError("failed to recognise site, line:"+line)
fpdb_simple.FpdbError: 'failed to recognise site, line:FullTiltPoker Game #924831306: Table Evans - $0.25/$0.50 Ante $0.05 - Limit Razz - 20:03:14 ET - 2006/08/22'
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-01-2009 , 06:38 PM
Quote:
Originally Posted by RainmanTrail
if I just open the program and try to import bulk, this is what I get:

...blah...
File "C:\Documents and Settings\Travis\Desktop\fpdb_0.10\pyfpdb\fpdb_simp le.py", line 1559, in recogniseSite
raise FpdbError("failed to recognise site, line:"+line)
fpdb_simple.FpdbError: 'failed to recognise site, line:FullTiltPoker Game #924831306: Table Evans - $0.25/$0.50 Ante $0.05 - Limit Razz - 20:03:14 ET - 2006/08/22'
The problem is that FullTiltPoker is all one word. The HH parser expects it to be "Full Tilt Poker". I just got some razz HHs from FTP, both stable and bet, and they have it as "Full Tilt Poker".

Wait! I see. the HH is from 2006 and the minkeys at FTP have changed their HH format. (Pointless changes like this really burn me up--and yeah, I know the change wasn't pointless to some marketing guy who held his breath until the tech guys agreed to change it.) It is about a 2 min job to fix that, but the file will probably break somewhere else.

I am PMing you my email address, so if you will send me that file I will see how painful it will be to make the changes needed to import those old files. If that is the only diff, I will fix it immediately.

Meanwhile, try some newer files.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-02-2009 , 07:35 AM
Guys,

first of all thanks so much for taking the time to try to do this.

I downloaded the software yesterday and got it functioning OK on Vista / MySQL.

I read through about half of this thread but there are some questions that I have which don't seem to be answered ..
  1. The Bulk Import works OK for me, the Auto Import seems to do nothing .. ? I have configured the FTP HH history folder, seems impossible to screw up.
    Something else to check for ?
  2. When wanting to see player stats, this only seems possible for Hero (i.e. my username) .. entering other player's handles is not recognised.
  3. In general, where is the most up to date documentation held ? Once the software is up and running, I don't see a 'Getting Started / HowTo ' user guide type thing. Not trying to be a jerk here as i know that this is a volunteer project and what you have done looks awesome.
  4. Any plans to highlight HU tables ?

Thanks once again.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-02-2009 , 10:27 AM
Quote:
Originally Posted by indigo
The Bulk Import works OK for me, the Auto Import seems to do nothing .. ? I have configured the FTP HH history folder, seems impossible to screw up.
Something else to check for ?
AutoImport is probably just sitting there waiting for a new HH file to appear in your HH folder. It is also possible that you didn't click the "Start Import" button--it is pretty big and might not actually look like a button. You can also autoimport observed hands by selecting the folder where they are stored--you still have to have some tables open for autoimport to do anything.
Quote:
When wanting to see player stats, this only seems possible for Hero (i.e. my username) .. entering other player's handles is not recognised.
This is still working for me. I was able to bring up the stats of my recent nemesis: 1) clicked on the Full Tilt radio button, 2) double clicked my FTP screen name to highlight it, 3) typed in his screen name, 4) clicked "Refresh", and 5) marvelled at his 16.3BB/100.
Quote:
In general, where is the most up to date documentation held ? Once the software is up and running, I don't see a 'Getting Started / HowTo ' user guide type thing. Not trying to be a jerk here as i know that this is a volunteer project and what you have done looks awesome.
The up-to-date docs are in the wiki. Most of us would rather code than write docs, but we have been putting some new docs in every now and then.
Quote:
Any plans to highlight HU tables ?
I'm not sure what you mean by this.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-02-2009 , 02:44 PM
Quote:
Originally Posted by Eratosthenes
The problem is that FullTiltPoker is all one word. The HH parser expects it to be "Full Tilt Poker". I just got some razz HHs from FTP, both stable and bet, and they have it as "Full Tilt Poker".

Wait! I see. the HH is from 2006 and the minkeys at FTP have changed their HH format. (Pointless changes like this really burn me up--and yeah, I know the change wasn't pointless to some marketing guy who held his breath until the tech guys agreed to change it.) It is about a 2 min job to fix that, but the file will probably break somewhere else.

I am PMing you my email address, so if you will send me that file I will see how painful it will be to make the changes needed to import those old files. If that is the only diff, I will fix it immediately.

Meanwhile, try some newer files.
I think I figured out some of my problem. The hh files that are exported from Poker Tracker Stud are exported in that format. When I change the fpdb_simple.py file at line 1554 to read "FullTiltPoker" instead of "Full Tilt Poker" the hands seem to import just fine with only a few incomplete files out of 100k hands or so. However, I couldnt just change the coding to include another elif statement or a ("Full Tilt Poker" or "Full Tilt Poker") argument. Not sure why, but either way, I have those hands imported now, and I just changed it back to the proper hh format.

Perhaps this should be looked into for the next release as I'm sure many others will be exporting hh files from PTStud in the future.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-02-2009 , 05:54 PM
Quote:
Originally Posted by RainmanTrail
I think I figured out some of my problem. The hh files that are exported from Poker Tracker Stud are exported in that format. When I change the fpdb_simple.py file at line 1554 to read "FullTiltPoker" instead of "Full Tilt Poker" the hands seem to import just fine with only a few incomplete files out of 100k hands or so. However, I couldnt just change the coding to include another elif statement or a ("Full Tilt Poker" or "Full Tilt Poker") argument. Not sure why, but either way, I have those hands imported now, and I just changed it back to the proper hh format.

Perhaps this should be looked into for the next release as I'm sure many others will be exporting hh files from PTStud in the future.
Changing this:
Code:
def recogniseSite(line):
    if (line.startswith("Full Tilt Poker")):
to this:
Code:
def recogniseSite(line):
    if (line.startswith("Full Tilt Poker") or line.startswith("FullTiltPoker"):
should give you a quick fix so that you can import new HHs and those exported from PT Stud.

I will make that change so that it is included in the next release.

Getting a handful of import failures out of 100k ftp stud hands is about what I am getting when I import my own ftp stud play. I have not tried to root out that last little problem because this code will "soon" be obsoleted by the new parser the guys are working on. The new parser will be faster and more reliable and will make it much to easier support new sites with just a plug in.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-03-2009 , 06:29 PM
Quote:
Originally Posted by Eratosthenes
Changing this:
Code:
def recogniseSite(line):
    if (line.startswith("Full Tilt Poker")):
to this:
Code:
def recogniseSite(line):
    if (line.startswith("Full Tilt Poker") or line.startswith("FullTiltPoker"):
should give you a quick fix so that you can import new HHs and those exported from PT Stud.

I will make that change so that it is included in the next release.

Getting a handful of import failures out of 100k ftp stud hands is about what I am getting when I import my own ftp stud play. I have not tried to root out that last little problem because this code will "soon" be obsoleted by the new parser the guys are working on. The new parser will be faster and more reliable and will make it much to easier support new sites with just a plug in.
shouldn't that line have two parenthesis at the end instead of 1?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-03-2009 , 07:29 PM
Quote:
Originally Posted by RainmanTrail
shouldn't that line have two parenthesis at the end instead of 1?
yes!

I have pushed the (correct) fix and it is available in my git repo.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-05-2009 , 06:02 AM
Quote:
Originally Posted by Eratosthenes
AutoImport is probably just sitting there waiting for a new HH file to appear in your HH folder. It is also possible that you didn't click the "Start Import" button--it is pretty big and might not actually look like a button.

You can also autoimport observed hands by selecting the folder where they are stored--you still have to have some tables open for autoimport to do anything.

This is still working for me. I was able to bring up the stats of my recent nemesis: 1) clicked on the Full Tilt radio button, 2) double clicked my FTP screen name to highlight it, 3) typed in his screen name, 4) clicked "Refresh", and 5) marvelled at his 16.3BB/100.
OK, reason for the confusion is that Bulk Import is only loading the first few HH files in the Full Tilt folder, hence why I could not retrieve Villain's Stats.
If I select other individual files in the folder, then I can import them without problem, but I have to do it one by one. Any reason why Bulk Import would only do some of the files ? How can I assist debug this ?

Also, I read about needing numby & mathplotlib for the graphs. On trying to download, one of the sites recommended installing python(x,Y) in order to run, I did this and it still does not work. How can I check to see if it has been properly installed for FPDB ?

Thanks in advance.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-05-2009 , 11:04 AM
Quote:
Originally Posted by indigo
OK, reason for the confusion is that Bulk Import is only loading the first few HH files in the Full Tilt folder, hence why I could not retrieve Villain's Stats.
If I select other individual files in the folder, then I can import them without problem, but I have to do it one by one. Any reason why Bulk Import would only do some of the files ? How can I assist debug this ?
You should be able to select a folder in the Bulk Import gui and have fpdb import all the HH files in the folder. If you are selecting a folder, but not importing all of the files in it, then something is going wrong.

First thing to do is look at fpdb-error-log.txt in the pyfpdb folder (same folder as fpdb.py). There should be a useful error message in that file.

Second thing, run fpdb from the command line so you can see the print output. (Open a terminal window, cd to the folder where fpdb.py is stored and enter python fpdb.py.) First try to import one of the files that didn't import when you selected the whole folder--see if anything interest shows up in the terminal window. Then try importing the whole folder. The output on the terminal should look something like this:
Code:
$ pyfpdb/fpdb.py -d fpdbTEST
Note: error output is being diverted to fpdb-error-log.txt and HUD-error.txt. Any major error will be reported there _only_.
Reading configuration file /home/fatray/.fpdb/HUD_config.xml

todo: implement obtain_global_lock (users: pls ignore this)
creating mysql index  Players name
creating mysql index  Hands siteHandNo
creating mysql index  Tourneys siteTourneyNo
Finished recreating tables
started at 2009-04-05 10:42:17.816802 -- 96 files to import. drop
preparebulk: cons= (u'Hands_ibfk_1',)
dropping mysql fk Hands_ibfk_1 Hands gametypeId
preparebulk: cons= (u'HandsPlayers_ibfk_1',)
dropping mysql fk HandsPlayers_ibfk_1 HandsPlayers handId
preparebulk: cons= (u'HandsPlayers_ibfk_2',)
dropping mysql fk HandsPlayers_ibfk_2 HandsPlayers playerId
preparebulk: cons= (u'HandsActions_ibfk_1',)
dropping mysql fk HandsActions_ibfk_1 HandsActions handPlayerId
preparebulk: cons= (u'HudCache_ibfk_1',)
dropping mysql fk HudCache_ibfk_1 HudCache gametypeId
preparebulk: cons= (u'HudCache_ibfk_3',)
dropping mysql fk HudCache_ibfk_3 HudCache tourneyTypeId
Total stored: 228 duplicates: 0 partial: 0 errors: 0  time: 13.834113121
Total stored: 61 duplicates: 0 partial: 0 errors: 0  time: 3.09120512009
Total stored: 72 duplicates: 0 partial: 0 errors: 0  time: 4.56625509262
Total stored: 16 duplicates: 0 partial: 0 errors: 0  time: 0.868985891342
Total stored: 41 duplicates: 0 partial: 0 errors: 0  time: 2.65115499496
Total stored: 93 duplicates: 0 partial: 0 errors: 0  time: 6.46930217743
...
Total stored: 117 duplicates: 0 partial: 0 errors: 0  time: 8.15374302864
Total stored: 102 duplicates: 0 partial: 0 errors: 0  time: 6.73258185387
afterbulk: cons= (u'Hands_ibfk_1',)
afterbulk: cons= None
creating fk  HandsPlayers handId -> Hands id
afterbulk: cons= None
creating fk  HandsPlayers playerId -> Players id
afterbulk: cons= None
creating fk  HandsActions handPlayerId -> HandsPlayers id
afterbulk: cons= None
creating fk  HudCache gametypeId -> Gametypes id
afterbulk: cons= None
creating fk  HudCache tourneyTypeId -> TourneyTypes id
GuiBulkImport.import_dir done: Stored: 6701     Duplicates: 0     Partial: 0     Errors: 0 in 584.175077915 seconds - 11/sec
The interesting line is about the 10th--it tells you how many files fpdb thinks it should be importing. The last line tells you how many hands were actually imported.
Quote:
Also, I read about needing numby & mathplotlib for the graphs. On trying to download, one of the sites recommended installing python(x,Y) in order to run, I did this and it still does not work. How can I check to see if it has been properly installed for FPDB ?
The windows installer should have installed python 2.5. Python 2.6 has been released but is not in wide use, so we have been sticking with 2.5 and probably will for a while longer--we cannot use 2.6 until all of the libraries that we use have released versions compatible with 2.6. To check your python installation, open a terminal window, type python, and hit enter. You should see output like this:
Code:
$ python
Python 2.5.1 (r251:54863, Jun 15 2008, 18:24:51) 
[GCC 4.3.0 20080428 (Red Hat 4.3.0-8)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>>
Notice the version on the first line (2.5.1 on my PC.). If you are seeing something other than 2.5.x, you probably need to get rid of the 2.6.x version and use 2.5.x. Now enter import numpy at the >>> prompt. Same with import matplotlib. If numpy and matplotlib are installed properly you should see this:
Code:
>>> import numpy
>>> import matplotlib
>>> import spam
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named spam
>>>
If there is a problem you should get an error like the one I got when I tried to import spam. Last time I looked at the numpy and matplotlib sites they had versions for different versions of python--you need the version for python 2.5.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-05-2009 , 02:10 PM
Thanks once again for the advice, trying to get graphs working first :
Code:
Python 2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)] on win32
Type "help", "copyright", "credits" or "license" for more information.
>>> import numpy
>>> import matplotlib
>>> import spam
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
ImportError: No module named spam
>>>
Exactly as you did, so assume this is correct.

From the error log, after trying to generate graph for my player ID on Full Tilt :

File "C:\Users\lewis\Documents\Downloads\fpdb_0.10\pyfp db\GuiGraphViewer.py", line 59, in generateGraph
sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-05-2009 , 02:39 PM
Quote:
Originally Posted by indigo
From the error log, after trying to generate graph for my player ID on Full Tilt :

File "C:\Users\lewis\Documents\Downloads\fpdb_0.10\pyfp db\GuiGraphViewer.py", line 59, in generateGraph
sitenos.append(self.siteid[site])
KeyError: u'Full Tilt'
Open your HUD_config.xml file in a text editor. Find the line for Full Tilt. Change this:
Code:
site_name="Full Tilt"
to this:
Code:
site_name="Full Tilt Poker"
That was an error in the HUD_config.xml.example in the distribution--now changed.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-05-2009 , 06:15 PM
Quote:
Originally Posted by Eratosthenes
Open your HUD_config.xml file in a text editor. Find the line for Full Tilt. Change this:
Code:
site_name="Full Tilt"
to this:
Code:
site_name="Full Tilt Poker"
That was an error in the HUD_config.xml.example in the distribution--now changed.
Hiya,

Actually the HUD config file shipped with 'Full Tilt Poker'.

Code:
 
- <site enabled="True" site_name="Full Tilt Poker" table_finder="FullTiltPoker.exe" screen_name="ENTER HERO NAME" site_path="" HH_path="" decoder="fulltilt_decode_table" converter="passthrough" bgcolor="#000000" fgcolor="#FFFFFF" hudopacity="1.0" supported_games="holdem,razz,omahahi,omahahilo,studhi,studhilo">
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-05-2009 , 07:34 PM
Quote:
Originally Posted by indigo
Hiya,

Actually the HUD config file shipped with 'Full Tilt Poker'.

Code:
 
- <site enabled="True" site_name="Full Tilt Poker" table_finder="FullTiltPoker.exe" screen_name="ENTER HERO NAME" site_path="" HH_path="" decoder="fulltilt_decode_table" converter="passthrough" bgcolor="#000000" fgcolor="#FFFFFF" hudopacity="1.0" supported_games="holdem,razz,omahahi,omahahilo,studhi,studhilo">
If this wasn't "Full Tilt" vs "Full Tilt Poker", then I'm stumped--one of the other devs will see this and have a suggestion.

You might check that you really are using that config file. When you start fpdb or HUD_main from a terminal window you will get something like this:
Code:
$ pyfpdb/fpdb.py 
Note: error output is being diverted to fpdb-error-log.txt and HUD-error.txt. Any major error will be reported there _only_.
Reading configuration file /home/YourName/.fpdb/HUD_config.xml
That shows the config file that you are actually using. If it doesn't show a path, it is using the one in your pyfpdb folder (where you started fpdb).

Oh, and you might need to reimport--select create/recreate tables from the Database menu to clear the old data first.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-06-2009 , 01:00 AM
Quote:
Originally Posted by Eratosthenes
If this wasn't "Full Tilt" vs "Full Tilt Poker", then I'm stumped--one of the other devs will see this and have a suggestion.
My suggestion is that you aren't using the config file you think you are. This was set in the default config a while ago, but looks like it was reverted since.

Eratosthenes has now fixed it permanently i'm sure
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-06-2009 , 10:57 AM
This is a minor problem I discovered when looking around in the database. The time at which a hand is played is not recorded properly. The time stamp is an hour early:

Code:
mysql> select max(handStart) from Hands;
+---------------------+
| max(handStart)      |
+---------------------+
| 2009-04-04 18:06:10 | 
+---------------------+
1 row in set (0.00 sec)

mysql> select utc_timestamp();
+---------------------+
| utc_timestamp()     |
+---------------------+
| 2009-04-04 17:16:49 | 
+---------------------+
1 row in set (0.00 sec)
(This was done ten minutes after finishing a session; max(handStart) should have been 17:06 rather than 18:06.)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2009 , 12:04 AM
I have been reading about 3bet stats, but I don't see any on the HUD or on the player stats window. Have these been removed? Or is there something I'm missing?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2009 , 03:13 AM
Quote:
Originally Posted by RainmanTrail
I have been reading about 3bet stats, but I don't see any on the HUD or on the player stats window. Have these been removed? Or is there something I'm missing?
You need to set up HUD_config.xml so that this statistic is shown by the HUD. Find the section beginning with

<game cols="3" db="fpdb" game_name="holdem" rows="2">

and add a "stat" line (there will be several of these) looking something like the following:

<stat click="tog_decorate" col="2" popup="default" row="0" stat_name="three_B_0" tip="tip1"> </stat>

Take note of where you have to specify "three_B_0". Also, make sure the "cols" (columns) and "rows" entries are consistent with the other "stat" lines and with the numbers given in the "game" line above. To ensure this, you will have to raise the number of columns or rows, or else delete an existing "stat" line to make room for the 3-bet statistic. (N.B.: In the "stat" lines, columns and rows are numbered from zero upwards.)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-07-2009 , 03:31 AM
Quote:
Originally Posted by Eleatic Stranger
You need to set up HUD_config.xml so that this statistic is shown by the HUD. Find the section beginning with

<game cols="3" db="fpdb" game_name="holdem" rows="2">

and add a "stat" line (there will be several of these) looking something like the following:

<stat click="tog_decorate" col="2" popup="default" row="0" stat_name="three_B_0" tip="tip1"> </stat>

Take note of where you have to specify "three_B_0". Also, make sure the "cols" (columns) and "rows" entries are consistent with the other "stat" lines and with the numbers given in the "game" line above. To ensure this, you will have to raise the number of columns or rows, or else delete an existing "stat" line to make room for the 3-bet statistic. (N.B.: In the "stat" lines, columns and rows are numbered from zero upwards.)
sweet thanks!

I assume then, that I can also add in AF and anything else I desire? Is there somewhere I can look to find out all the stats I could potentially use?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m