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

04-23-2012 , 05:57 AM
Hello again,

let me, at first, apologize for the hassle i might have caused.

Today, I edited the my.ini file again, but this time the way Chaz recommended it. Only adding max_allowed_packet after max_connections line and leaving all other variables untouched, reboot server, checking variable in command line to see it was taken by mysql, which it did, and then starting fpdb and import some files smaller than 256kb and some larger ones including some ZOOM files of ~3M.
And what do you know, IT WORKED!!!

Thanks a million for your support and even more for your patience!

Cheers,
Doc

Quote:
Originally Posted by ChazDazzle
There are a couple changes I would make, but I can't guarantee that they'll fix the problem.

Go ahead and add:

max_allowed_packet = 100M (...after 'max_connections=100')
Furthermore, I would like to know whether the following message in the fpdb-log (NOT error) has any effect on analyzing my hands, specificly analyzing positional play. It only comes up when importing ZOOM files:
(text in [ ] is added by myself for translations from german to english)

2012-04-23 11:44:48,733 - importer INFO Beginn [start] 2012-04-23 11:44:48.734000 -- 1 Dateien zu importieren [1 file to import]. Indexe: auto
2012-04-23 11:44:48,796 - importer INFO Konvertiere [convert] C:\XXX\...\HH20120419 XXX - XXX - USD Pot Limit Omaha_Zoom.txt
2012-04-23 11:44:48,796 - parser INFO HandHistory init - PokerStars site, PokerStarsToFpdb.PokerStars subclass, in_path 'C:\XXX\...\HH20120419 XXX - XXX - USD Pot Limit Omaha_Zoom.txt'; out_path '-'
2012-04-23 11:44:54,796 - parser INFO Lese 2249 Hände [read xxx hands]
2012-04-23 11:44:54,812 - parser INFO readButton: nicht gefunden [not found]
2012-04-23 11:44:54,812 - parser INFO readButton: nicht gefunden
... (this line keeps repeating for several hundred lines)
2012-04-23 11:45:18,483 - parser INFO 2249 Hände [hands] (0 fehlgeschlagen) in 29.688 Sekunden gelesen [in xxx seconds read]
2012-04-23 11:48:40,342 - db INFO Analyze dauerte 5.9 Sekunden
2012-04-23 11:48:47,171 - importer INFO Massenimport fertig [bulk import finished]: Gespeichert [saved]: 2249, Dupletten: 0, Teilweise: 0, Fehler [error]: 0, Zeit: 238.328000069 Sekunden, Gespeichert/Sekunde: 9

If I can be of any help, please let me know!

Once again, I thank you all for the ongoing support!

Doc

Last edited by Doc Svenson; 04-23-2012 at 06:22 AM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2012 , 08:33 AM
Doesn't appear to be anything special in the logs. Makes me think we might be a bit verbose with some parts of the process - readButton namely - but other than that it's ok.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2012 , 10:29 AM
Quote:
Originally Posted by ChazDazzle
Doesn't appear to be anything special in the logs. Makes me think we might be a bit verbose with some parts of the process - readButton namely - but other than that it's ok.
Actually, this isn't entirely correct. The 'readButton not found' is popping up because PokerStars doesn't write the button position in the zoom hand histories like it does for standard games. We don't actually need it though, so positions should still be recorded correctly in the database.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2012 , 03:08 PM
Quote:
Originally Posted by ChazDazzle
Actually, this isn't entirely correct. The 'readButton not found' is popping up because PokerStars doesn't write the button position in the zoom hand histories like it does for standard games. We don't actually need it though, so positions should still be recorded correctly in the database.
Thanks for the info!
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2012 , 11:35 PM
Hey guys I am able to configure my.ini, added max_allowed_packet=100M and import normally in MySQL now. Config file is saved in C:\Program Data\MySQL instead of C:\Program Files\MySQL, took me some time to realise transferring the my.ini to Program Files folder.

During installation of MySQL, I chose server machine, multifunctional database and decision support (DSS)/OLAP. Is these options suitable for fpdb database?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-23-2012 , 11:44 PM
Quote:
Originally Posted by riverofjustice
Hey guys I am able to configure my.ini, added max_allowed_packet=100M and import normally in MySQL now. Config file is saved in C:\Program Data\MySQL instead of C:\Program Files\MySQL, took me some time to realise transferring the my.ini to Program Files folder.

During installation of MySQL, I chose server machine, multifunctional database and decision support (DSS)/OLAP. Is these options suitable for fpdb database?
Yes, this would work fine.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-24-2012 , 01:46 AM
Hi guys.

Two weeks ago I had a problem with this programm (and I still have it):

basically if I play with Play Money, the statistics are.
When I play with Real Money, the programm doesn't work correctly...

When I use both tables at the same time, the statistics appears only on Play Money Table...

I have the latest version and I've already tried to uninstall everything.

Thank you
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-24-2012 , 03:49 PM
Somebody can help with this problem?
File "GuiAutoImport.pyc", line 190, in do_import
File "fpdb_import.pyc", line 418, in runUpdated
File "fpdb_import.pyc", line 535, in import_file_dict
File "Hand.pyc", line 309, in insertHandsStove
File "Database.pyc", line 2145, in storeHandsStove
sqlite3.DatabaseError: database disk image is malformed
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-24-2012 , 11:34 PM
SOS guys

Auto importing not working for my MySQL, screen go not responding. Works with no hand history but now got 200k hand history.

Last edited by riverofjustice; 04-24-2012 at 11:59 PM.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2012 , 12:12 AM
Quote:
Originally Posted by riverofjustice
SOS guys

Auto importing not working for my MySQL, screen go not responding. Works with no hand history but now got 200k hand history.
working fine now! topic is closed.

Is there %fold to Raise to Steal stat?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2012 , 10:20 AM
Quote:
Originally Posted by firippusan
version 0.29.902 and 904 under debian, works for about 2 hours then crashes. From then on every time I restart fpdb, 10 sec after I hit autoimport, crashes again and fpdb stops. Looked at the log from the menu but doesn't say anything like an error.
I suspect there's a bug with omaha.
Tried 905 also: holdem works fine but omaha crashes after a few minutes. From then every time I restart and hit autoimport, client insta-crashes. No error logs. I need to turn off stars client and restart it for fpdb to not crash after autoimport, which works for a few minutes then crashes again.
Holdem works fine and never crashes.

Anybody succesfully uses fpdb for plo on stars?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
04-25-2012 , 05:40 PM
Quote:
Originally Posted by firippusan
Anybody succesfully uses fpdb for plo on stars?
I use this version which works fine for me:

http://****************/projects/fpdb...2.exe/download
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-12-2012 , 11:34 AM
Hi guys, I've a Big problem...

FPDB works only with Play Money.
If i play Real Money (Hold'em or Omaha), it doesn't work...

I don't know why...

I have Win7 starter...
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-13-2012 , 06:16 PM
Quote:
Quote:
Quote:
Originally Posted by JasonMilo911 View Post
Hello. I play on pokerstars.it and I'm tryin to make the software works to improve my game. I have windows 7, ive downloaded and loaded the file. I followed the steps on the guide "Getting Started" and everrything was working fine. I bulked imported some hh, then i closed it and restarted it (as the software itself told me to do). Unfortunatly tho from the viewers tab of the menu I cannot display anyhting. I cannot see stats and all. It just does not work! Any suggestions/steps I forgot! TY
Can you please try resetting your config please? http://****************/apps/mediawik..._Configuration

Also - do you have any non-ascii characters in your username or path.
Hi,
First of all, thx for this program.
I have the same problem as Jason: importation works fine for hands and tournaments, the hub too but some options in the viewers tab don't.
Graphs, Positional Stats, Session Stats, Hand viewer don't display anything.
Tourney graphs, Tourney stats work fine.
Could you help me please ?
I'm on Windows 7 Ultimate, fpdb v0.29.907 (installed with windows exe), poker room Pokerstars.fr and playing only SNG in real money Hold'm No Limit.
No "non ascii character" in my username.
paths : C:\Program Files\PokerStars.FR
C:\Users\Kharnacier\AppData\Local\PokerStars.FR\Ha ndHistory\Kharnacier
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-15-2012 , 01:42 AM
No one can help us????
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-15-2012 , 09:13 PM
Quote:
Originally Posted by Titiro17
No one can help us????
Just got my account back after the outage. Feel free to send the hand histories you have problems with to support@pokeit.co and I'll take a look. What version are you using?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-16-2012 , 01:19 PM
Quote:
Originally Posted by ChazDazzle
Just got my account back after the outage. Feel free to send the hand histories you have problems with to support@pokeit.co and I'll take a look. What version are you using?
Hand Histories?
What I have to do?

Now I'm using 0.29.907 and my problem is connected with real money.

FPDB works only with Play Money.
If i play Real Money (Hold'em or Omaha), it doesn't work...

Ty
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-16-2012 , 03:46 PM
Quote:
Originally Posted by Titiro17
Hand Histories?
What I have to do?

Now I'm using 0.29.907 and my problem is connected with real money.

FPDB works only with Play Money.
If i play Real Money (Hold'em or Omaha), it doesn't work...

Ty
If it's only working with play money then there's probably something wrong with how we're reading the hand histories. I'd like to check one of them out to be sure. What site are you playing on? If you grab one of the files from the directory where your poker site is saving them and email the file to me, I can get a better idea of what needs to be fixed. Thanks.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-16-2012 , 04:15 PM
Quote:
Originally Posted by ChazDazzle
If it's only working with play money then there's probably something wrong with how we're reading the hand histories. I'd like to check one of them out to be sure. What site are you playing on? If you grab one of the files from the directory where your poker site is saving them and email the file to me, I can get a better idea of what needs to be fixed. Thanks.
Actually I'm playing on PokerStars.it
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-16-2012 , 04:39 PM
Hi,

PartyPoker had an software update and now Auto import displays "1 error" after every hand. Also the HUD doesn't appear. Seems that they changed something in the format of the hand history files.
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-16-2012 , 04:50 PM
Quote:
Originally Posted by p0kerspeler
Hi,

PartyPoker had an software update and now Auto import displays "1 error" after every hand. Also the HUD doesn't appear. Seems that they changed something in the format of the hand history files.
Would you mind sending a sample hand to support@pokeit.co?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-17-2012 , 12:33 AM
Quote:
Originally Posted by p0kerspeler
Hi,

PartyPoker had an software update and now Auto import displays "1 error" after every hand. Also the HUD doesn't appear. Seems that they changed something in the format of the hand history files.
I only work in partypoker HUD mode tournaments, cash Game or money does not work real or fictional. I hope they fix the problem
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-17-2012 , 06:58 AM
Quote:
Originally Posted by Kharnacier
Hi,
First of all, thx for this program.
I have the same problem as Jason: importation works fine for hands and tournaments, the hub too but some options in the viewers tab don't.
Graphs, Positional Stats, Session Stats, Hand viewer don't display anything.
Tourney graphs, Tourney stats work fine.
Could you help me please ?
I'm on Windows 7 Ultimate, fpdb v0.29.907 (installed with windows exe), poker room Pokerstars.fr and playing only SNG in real money Hold'm No Limit.
No "non ascii character" in my username.
paths : C:\Program Files\PokerStars.FR
C:\Users\Kharnacier\AppData\Local\PokerStars.FR\Ha ndHistory\Kharnacier
More info: I don't have any ring hands (but I don't think it's necessary for "Hands viewer", "Graphs", "Positional Stats" or "Session stats" ?)
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-17-2012 , 06:51 PM
Hello !

I have some problems and remarks for fpdb-0.29.907 on linux debian for Winamax.

1) The HUD works well for MTT when I stay on the same table, but when I change of table, I have the stats for the old table and the new table (there is the 2 table names in the little hud window). I have to stop and resart the HUD if I whant olny the stats of the new table.

HUD doesn't work for this tourney mtt : Freeroll VIP Aluminium(21208692)

Winamax Poker - Tournament summary : Freeroll VIP Aluminium(21208692)
Player : gpelle
Buy-In : 0€ + 0€
Registered players : 3945
Prizepool : 2000€
Tournament started 2012/04/12 20:15:01 UTC
You played 1h 57min 33s
You finished in 456th place

2) I have some questions about "tourney stats". You can see a screnshot here : http://guillaumepelle.perso.sfr.fr/p...B_20010430.png
For me the line 1 is the line of the Buyin 4,50

2.1) At line 17 (Buyin 0,47), I have lot of tourney type.

On winamax, the tourney type are (except tourney for win a ticket) :

a) 0,45+0,05 : "No Limit Hold'em" for 10 players, 5 players, 15 players (multi tables)

Winamax Poker - Tournament summary : No Limit Hold'em(16747748)
Player : gpelle
Buy-In : 0.45€ + 0.05€
Registered players : 10
Prizepool : 4.50€
Tournament started 2012/01/09 10:09:40 UTC
You played 31min 55s
You finished in 1st place
You won 2.25€

b) 0,46+0,04 : "Quitte ou Double" for 10 players (DON)

Winamax Poker - Tournament summary : Quitte ou Double(13801458)
Player : gpelle
Buy-In : 0.46€ + 0.04€
Registered players : 10
Prizepool : 4.60€
Tournament started 2011/10/30 21:58:36 UTC
You played 56min 42s
You finished in 6th place

c) 0,47+0,03 : "Deglingos!" for 10 players (winner take all, short stack 500), "No Limit Hold'em" for 10 players (HU), "Shootout Heads-Up" for 16 players, "Double Shootout" HU for 4 players winner take all

Winamax Poker - Tournament summary : Deglingos !(14705412)
Player : gpelle
Buy-In : 0.47€ + 0.03€
Registered players : 10
Prizepool : 4.70€
Tournament started 2011/11/21 20:36:24 UTC
You played 22min 30s
You finished in 4th place

Winamax Poker - Tournament summary : No Limit Hold'em(21083463)
Player : gpelle
Buy-In : 0.47€ + 0.03€
Registered players : 2
Prizepool : 0.94€
Tournament started 2012/03/26 20:16:29 UTC
You played 4min 7s
You finished in 2nd place

Winamax Poker - Tournament summary : Shootout Heads-Up(20560766)
Player : gpelle
Buy-In : 0.47€ + 0.03€
Registered players : 16
Prizepool : 7.52€
Tournament started 2012/03/17 17:19:05 UTC
You played 32min 31s
You finished in 7th place

d) 0,48+0,02 : "Deglingos Heads-Up" HU with a short stack of 500

Winamax Poker - Tournament summary : Deglingos Heads-Up(22891670)
Player : gpelle
Buy-In : 0.48€ + 0.02€
Registered players : 2
Prizepool : 0.96€
Tournament started 2012/04/27 19:00:43 UTC
You played 3min 42s
You finished in 1st place
You won 0.96€

For the buy 0,47 all the tourney type are on the same line. It should be good have one line for one tourney type. The tourney type can be determinate with the summary file by the buy in and the nuber of players or directly by the name (label).

2.2) The lines 7, 16, 19 and 23 are empty for "win" "roi" and "$/tour" why ? What is the problem ?

2.3) At lines 21 22, there is a lot of sng (line 21), and mtt maybe at line 22, but at line 22 there is 2 3rd place but I never have a 3rd place at a mtt. Maybe the sng and mtt are in the to lines ...

2.4) Should be possible to tag a line by the name of the game ? It's more explicit !


3) Since this version, graphs doesn't work. ("graphique" and "graphique de tournoi") (work well before)

4) You can download my hand history here : http://guillaumepelle.perso.sfr.fr/p...e_20110430.zip
You can download my log files and errors files here : http://guillaumepelle.perso.sfr.fr/p...e_20120430.zip

Thank you for this program and sorry for my english.

PS : at row 17 I have some sng : HU and déglingos (10 players) on the same raw. It's a problem because now I can't know my roi for HU !
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote
05-18-2012 , 12:34 AM
Recent update in Party Poker did change the way to write history hands. Now the table no have number else the name of the table. Is right that?
Free, open source poker tracking software: FPDB - (Version 0.40.5) - Nov 14, 2013 Quote

      
m