Thanks for the report.

I recently committed some code specifically do deal with this type of tourney, so the next release should contain the fix.

Sorrow

Interesting spot to crash.

The hh file is read, then closed immediately before parsing.

That call is only to signal the hud process that there is another hand available in the database to update itself. So the hud process must be crashing somewhere and closing the pipe.

Thats not going to be fun to track down.

wow, thanks!

keep up the great work

As I mentioned above, the importer only has the hh file open for a very short period of time each cycle (i've just committed a patch to make that time even shorter - just in case) so this _shouldn't_ (i won't say isn't...) be the reason for hosing the file.

(Could you zip the file before sending please? Email is munging the file format)

FTP HHs are utf-16, so a single byte offset could bugger the file, but i'd expect gibberish, not 0's

Sorrow

I have opened FPDB and immediately tried to import my Tourn Histories but nothing happened when I clicked it through the menu. I've also tried Ctrl-I with no success.

I am able to bulk import 20-30 files at a time but it has not imported my folder. My gf did open up FireFox last night while I was attempting to a new import which may overload the cpu.?

I have several thousand 45 and 180s that I'd like to import. I typically play between 1500-3,000 games a month

Below is my error log.

[PHP]fpdb starting ...Traceback (most recent call last):
File "/usr/share/pyshared/fpdb/GuiBulkImport.py", line 95, in load_clicked
(stored, dups, partial, errs, ttime) = self.importer.runImport()
File "/usr/share/pyshared/fpdb/fpdb_import.py", line 228, in runImport
(totstored, totdups, totpartial, toterrors) = self.importFiles(self.database, None)
File "/usr/share/pyshared/fpdb/fpdb_import.py", line 284, in importFiles
,self.filelist[file][0], self.filelist[file][1], q)
File "/usr/share/pyshared/fpdb/fpdb_import.py", line 438, in import_file_dict
hhc = obj(self.config, in_path = file, out_path = out_path, index = idx, starsArchive = self.settings['starsArchive'])
File "/usr/share/pyshared/fpdb/HandHistoryConverter.py", line 101, in __init__
self.start()
File "/usr/share/pyshared/fpdb/HandHistoryConverter.py", line 149, in start
self.processedHands.append(self.processHand(handTe xt))
File "/usr/share/pyshared/fpdb/HandHistoryConverter.py", line 275, in processHand
hand = Hand.HoldemOmahaHand(self.config, self, self.sitename, gametype, handText)
File "/usr/share/pyshared/fpdb/Hand.py", line 678, in __init__
hhc.readHandInfo(self)
File "/usr/share/pyshared/fpdb/PokerStarsToFpdb.py", line 258, in readHandInfo
hand.fee = int(100*Decimal(info[key][middle+2:]))
File "/usr/lib/python2.6/decimal.py", line 545, in __new__
"Invalid literal for Decimal: %r" % value)
File "/usr/lib/python2.6/decimal.py", line 3719, in _raise_error
raise error(explanation)
decimal.InvalidOperation: Invalid literal for Decimal: u''[/PHP]

Also, I am unable to define the date for analysis when I go to Viewers - Tournery Stats. I am able to do this if I go to the Ring Player Stats.

I'm pretty sure I finished squashing this bug as of about an hour ago.

Sorrow

Tourney Summaries: I'll try to add a more usable interface for this to the next snapshot
Tourney Stats: That bug is fixed in 0.20.903 of which you can download the Windows package here: http://****************/projects/fpdb...U.exe/download
The official announcement will be made as soon as we're done with packaging

Using .exe version of: fpdb-0.20.902noSSE, from fpdb.exe.log file.

parser : ERROR determineGameType: Unable to recognise gametype from: 'PokerStars Game #47583725585: Tournament #294420919, $5.00+$0.50 USD Mixed PLH/PLO (Hold'em Pot Lim'
parser : ERROR determineGameType: Raising FpdbParseError

Also, when moved to another table, hud's stats are off by one seat and sometimes two or three.

bit of a stupid question, but does the link in the above post support dwonload of this software?

i've all but given up on my OM.

edit : is it compatible with the new betfair and bet 365 which i'll probably move to as soon as i clear my betfair bonus.

Hello everyone,
The new snapshot 0.20.903 is now available for download as source or as packages for Debian, Gentoo, Ubuntu and Windows.
This version brings many improvements and bugfixes, updating is recommended for users of previous snapshots. If you're using a stable version like 0.20 or 0.20.1 please consider trying this version and report any bugs, and in particular regressions, so we can fix them.

Please note that you will have to either recreate your database, or use a new one for this version.

The most important changes in no particular order:
- Recognise and store PS bounty tourneys properly
- Some cleanups in the graphical Interface
- Some improvements to HUD positioning
- PostgreSQL should work again
- Fixes to these stats: WtSD, sawShowdown, currency
- Improvements to Everleaf and AbsolutePoker Support
- We think FullTilt.fr should now work
- Improvements to Tourney and Ring Player Stats interface
- Fix to handle non-English characters in Windows usernames
- Improved handling of timezones, in particular the obscenity that is called Daylight Savings Time
- New stat: fold to steal
- Some improvements to the database design

To download:
- Debian/Ubuntu Linux: http://****************/projects/fpdb...l.deb/download
- Gentoo Linux: http://****************/projects/fpdb...build/download
- Windows: http://****************/projects/fpdb...U.exe/download
- Source version for those who installed the dependencies manually: http://****************/projects/fpdb...r.bz2/download

Thanks to everyone who contributed code, advice, documentation, testing and bug reports!

You can try the new 0.20.903 but it probably still won't work. Could you post or send us an example hand from that file? Publicly to: fpdb-main@lists.****************
Privately to me: steffen@schaumburger.info
Simply close the HUD for that table and it should re-appear in the right position as soon as the next hand is imported.
You can find the links to the latest snapshot in my last post. Alternatively you can find the latest stable version here: http://****************/projects/fpdb/files/ (download 0.20.1 for your operating system, ie. the .exe for Windows, the .deb for Debian/Ubuntu, the .tar.bz2 for everything else).
What does OM mean?
Fpdb supports betfair, not sure what you mean with new betfair. I never heard of bet 365, but if they're part of a network we already support then it should work, just give it a go

Cheers, Steffen

I think Betfair poker became part of the OnGame network

That file isn't going to work, i've never played a mixed tourament. I think HORSE parses, but any other mixed game variant we will need examples.

We probably only need the rest of that first line to fix it.

Sorrow

Thanks guys. I'll try to import my HHs tonight.

PokerStars Game #47587046512: Tournament #294420919, $5.00+$0.50 USD Mixed PLH/PLO (Hold'em Pot Limit) - Level XVII (500/1000) - 2010/08/01 20:39:48 ET
Table '294420919 6' 9-max Seat #5 is the button


PokerStars Game #47587206261: Tournament #294420919, $5.00+$0.50 USD Mixed PLH/PLO (Omaha Pot Limit) - Level XVIII (625/1250) - 2010/08/01 20:44:19 ET
Table '294420919 6' 9-max Seat #4 is the button

Hi sorrow, dangerman

Just quickly tested, and your git no-longer causes a lockup - the errors are still thrown to the logfile, but autoimport and HUD continues to work.

gimick/

Does the hh file get trashed?

Posting to report issues with the Positional, Tourney, and Ring Player stats views. They either do not launch or do not display any info. Below is the basic info and how I can recreate the problem:

OS: Win7 x64
Site: PokerStars
Hand Histories: Varied testing range from 116 to 20k
FPDB version(s) from about box:
Operating System nt
Python 2.6
GTK+ 2.20.0
PyGTK 2.16.0
matplotlib 0.99.3
numpy 1.4.1
sqlite3 2.4.1
sqlite 3.5.9
database sqlite

The import throws a lot of "unable to recognize game type from hand xxxx", but I do not think this is the issue. I went through the preferences one by one and changed them until I found what was causing the screen not to display at all. So far, changing the screen name for stars from "YOUR SCREEN NAME HERE" to my name will prevent the Positional and Tourney player stats from showing. If I leave the SN as "YOUR SCREEN NAME HERE" then those screens will show. However, if I then put my SN in the box and hit refresh, it fails in both cases. I can recreate this at will.

The Ring Player stats just never shows.

Note: this is a x64 box and so some paths are changed and I use a custom HH path but that path has no special characters or spaces.

Here's a sample of the errors logged when the screens are launched.

Ring Player
Traceback (most recent call last):
File "GuiPositionalStats.pyc", line 143, in refreshStats
File "GuiPositionalStats.pyc", line 175, in fillStatsFrame
File "GuiPositionalStats.pyc", line 186, in createStatsTable
sqlite3.OperationalError: near "' '": syntax error

Traceback (most recent call last):
File "GuiPositionalStats.pyc", line 143, in refreshStats
File "GuiPositionalStats.pyc", line 175, in fillStatsFrame
File "GuiPositionalStats.pyc", line 186, in createStatsTable
sqlite3.OperationalError: near "' '": syntax error

Let me know what else you need to track this down of if you think I missed a setting somewhere. I am a programmer by trade, so I know you may need more than this, just tell me.

Upon looking closer at the log file(s), it seems that EVERY hand threw out the "unable to recognize gametype" error. So I suspect that the tables are empty and that is killing the screens. Now to find out why they are not recognized.

Using 0.20.903 source code version, I did experience the hud freeze and I ended up with another corrupted hand history.

Using the exe version, I didn't experience hud freeze, but I didn't play so many hands that I would consider it a very extensive test.

I have started to take notes about other errors I experience and I'll post them up after I get more comfortable that I'm filtering out pilot errors.

The most recent development release might be a paper-bag job. There has been a serious bug fixed with showdown stats, and the Ring Playerstats page is broken on my install at the moment showing

It is due to some work sqlcoder was doing to make the columns in that page configurable (you'll be happy to hear Dog)

See http://trac-git.assembla.com/fpdb-sq...f42eb320bc0bc3 for the required config section.

"unable to recognize game type from hand xxxx" is an issue we need to address on a per game basis, I can usually fix those with just the header (newer versions should print the first 100 characters of the header to make it a bit easier to find.)

Sorrow

Here's what I found. I had PS send me a file with all my hands since I didn't have the save option turned on for a while. Between each hand definition they have inserted Hand #1, Hand #2, etc. Looks to me like the parser is reading these and not knowing what to do (nothing it can do with them either). However, it does look like the REAL hands are getting parsed and put in the database since my profit graph will populate and looks correct with all the hands I expect to be in there.

So now I am back to seeing the reported errors happening when I put in my screen name.

Are you suggesting we put this section in our HUD_config.xml file?

You are right, the hand splitting code recognises '#1' as a hand in its own right, and of course fails to identify the type of game.

I wrote something to deal with the Stars archive format:

./GuiBulkImport.py --starsarchive -c PokerStars -f filename

Never got around to adding a checkbox to the gui though.

Yes, the stats view can now be configured. For the moment there aren't any defaults, so if you are using an 'old' config you will need to add the new section.

Sorrow

Good to know on the archive options. Just FYI, I verified that this was the issue with the unrecognized game in the error logs. Only I did it using a RegEx search and replace on the archive to remove the Hand #x text. So, that is all good and works. Further this really was only an issue if you look in the logs and wonder "WTF?, why aren't my hands importing?" when, in fact, the actual hands ARE getting imported just fine. Just one of those things that make you chase down rabbit holes.

Anyway, after running through all this, uninstalling/reinstalling/resetting over and over to test and make sure I am not missing a setting before I import hands, it is still consistent that the Positional, Tourney, and Ring screens are behaving as I described. I might be dense and just missing it in your posts above, but are you seeing that too or do I have something else going on here?

Edit: Session screen is doing the same thing.

Almost exactly what that option does
After adding the <gui_cash_stats> section to your config and restarting the (at least cash page) should open again.

Sorrow