It looks like Sky is an independent network. Depending on the hh format it shouldn't be too difficult.

http://****************/apps/mediawik...tory_Donations

just installed MySQL but cant bulk import all hand histories, bulk import randomly stops.

What file is showing when it hangs?

Also are you using the most recent release 0.29.907? There were a couple of important MySQL fixes in that.

Sorrow

single draw as i remember! I tried postgres but no luck for that, so I switch to MySQL and follow the instructions on fpdb wiki. Is bulk importing using SQLite, then change to MySQL later an option here?

Ya got the recent update.

No you need to import into the correct database, converting isn't an option.

Can you send me the failing file(s) please. There were some updates for draw stats in the most recent release, so we may have broken something.

Email sended.

Thanks for the response and i looked at the supplied link however I do not have any files because you cant get HHs from Sky onto my hardrive, the only option is to copy and paste the dealer chat window or can your tracker read thru the chat windows??? im really not sure tbh but please let me know what you think, i can still perhaps copy and paste some dealer chat messages as a form of hhs??

Is there anyway to add rakeback/bonuses like you can with HEM etc so that your graph you can see profit with rakeback etc? sorry if its there and im just being a tard! thanks for the great program!

Fpdb can't read directly from the poker client, only from files stored onto the harddrive or emails sent by the poker site. You could contact support and ask them to email you your HHs? I suppose you could copy&paste from the chat window, but tbh, wouldn't that just be way too much effort to actually do all the time when playing?

Cant import some of the holdem tourney as well, using mySQL server 5.5, wonder if I set it up wrong. Auto import runs fine on both draw and holdem game with MySQL

I've installed the latest version of fpdb in order to try it out with Stars. I have imported my hand histories and the viewers are working perfectly, great work. Auto-Import seems to be working fine too, but I am not seeing the HUD for some reason. Is this a known issue? is there a resolution. I have tried multiple forum searches including going back through this thread but as yet have not found any solution.

After more thorough searching of this thread, I tried one of the suggested solutions and now I have a working hud. Great work on this software, I haven't had chance to play around with customised HUDs yet but so fair it looks great.

We chated about this on our podcast, I use Linux (Mint12) with Wine and PokerStars and have tried this with some sucess. I am not too worried about the Hud but like the ability to see my stats.

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

@JasonMilo911

This worked for me (Highlighted in blue). Though I do believe all your software languages must be set to english, make sure your HH are in english and your fpdb too.

Hello,

thank you for offering such a great program and the ongoing support. I have been using fpdb for some time now and so far was able to solve my problems on my own using wiki or google.
However, I now run into some trouble that apparently I'm unable to solve.

Since my # of HHs reached a point where a switch from SQLite to MySQL seems mandatory, I installed MySQL 5.5.23 and configured it successfully (standard config).
Bulk importing works fine until it would stop at certain files. I narrowed the issue down to bulk import having problems with files larger than 256kb (my largest individual file being 400kb; files smaller than 256kb import correctly and cash stats are visible).

The fpdb error log reads:

fpdb startet ...Traceback (most recent call last):
File "GuiBulkImport.pyc", line 110, in load_clicked
File "fpdb_import.pyc", line 242, in runImport
File "fpdb_import.pyc", line 301, in importFiles
File "fpdb_import.pyc", line 533, in import_file_dict
File "Hand.pyc", line 298, in insertHandsPlayers
File "Database.pyc", line 2106, in storeHandsPlayers
File "MySQLdb\cursors.pyc", line 223, in executemany
File "MySQLdb\cursors.pyc", line 316, in _query
File "MySQLdb\cursors.pyc", line 280, in _do_query
_mysql_exceptions.OperationalError: (2006, 'MySQL server has gone away')

I searched the web for solutions to "2006, 'MySQL server has gone away'". The most common one suggests to increase the 'max_allowed_package' variable in the 'my.ini' file from 1M to 8M or bigger. First of all, I could not find this line, secondly my largest individual files are still under 1M big and increasing that number appears to not solve the issue. Needless to say, I raised this variable in the other myXYZ.ini files nevertheless but the bulk import would still stop at files larger 256kb.

I appreciate any help and thank you in advance. Furthermore, I can send you HH files who fail to import, if requested.
(On a side note: files who fail to import correctly don't show up in the cash stats tab but are accounted for under database>stats>total hands etc.)

Kind regards,
Doc

WinXP SP3
fpdb 0.29.907
MySQL 5.5.23
Memory: 512MB

Cant import files larger than 256kb here as well.

Working on something right now to fix this problem. Hopefully will have it out by the end of the week.

Thank you very much. If I can be of any help, let me know (regardless the fact, that I'm not trained in computer programming).

Doc

Hi,
I love FPDB and have been using it for a while on PS...
Today I installed Carbon, so I could swim with the apparent ocean of fish there, however the stats windows aren't appearing??
The program can "see" my HH's as I can see it processing them in the import window, ticking by...
I was wondering if you could provide some insight, as to possible causes.
Thanks!

I received your email and have responded, I'll continue this there.


Sorry cjm2009, unless we have a text file (or some other data representation) to work with we can't support the site.

Not at the moment.

I believe Chaz was looking at providing this as a feature, but it requries a database schema change which means that it won't happen until at least the 0.30 release.

Could you expand on this please? What podcast?

Do you have anything in ~/.fpdb/log/HUD-log.txt that looks relevant?

Linux + Wine + Stars is probably the best supported platform, i'm curious what your issue might be.

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.

I've not able to trigger that exact message, but I am able to trigger another issue when I throw a 12Mb file at it.

Setting max_allowed_packet = 64M allowed my to import that file successfully, but I fail again importing a 20Mb file. So we need to fix this. I've logged the issue as http://****************/apps/mantisbt...iew.php?id=159

In the process, i've managed to trigger a new bug when recreating tables:
I've fixed that now at least

I also tried the reverse of what was recommended and shortened wait_timeout to 10 to try and trigger the 2006 message and i'm now able to trigger the issue, but having done that i've found something that makes me believe this is a windows only issue.

From http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

If you are using MySQL 5.1 or later you should be able to set wait_timeout in my.ini to something vary large to work around the issue. Are you able to try this for me please?

Logging this issue as http://****************/apps/mantisbt...iew.php?id=160

Thanks

Sorrow

I haven't posted this recently so a reminder:

When you do report issues, try to make it easier for us help you. We usually need at least the
following information:

• - FPDB version
• - Operating system and version (e.g. Linux Mint 12 or Windows 7 64bit)
• - Database type (MySQL, SQLite, PostgreSQL)
• - Install method (exe, tarball, deb, git, ebuild)
• - Site name and gametype (e.g. $10 Pokerstars Razz SnG)
• - Translation: What language is FPDB displaying in. If the language is not English, can you please reproduce the issue while using the English translation first
• - Errors from the log files. There is now a copy to clipboard function to assist this. We are usually looking for lines containing WARNING and ERROR.

Most of these details are available for easy copy & paste in the Help menu under About or in Help->Log Messages (Use copy to clipboard)

Without these details they are the first thing we are going to ask for.

Thanks

Sorrow

Thanks for the support!

Doc

Hello,

I sat down today and tried to make MySQL bulk import files larger than 256kb correctly. Unfortunately, I did not succeed.
After I went back to SQLite for the past few days, I re-installed MySQL 5.5.23 (Win32) and was able to configure it correctly and have it run for fpdb 0.29.907.
However, it still fails to bulk import files bigger than 256kb. FPDB just stops responding and the same '2006' message appears in the error log.
I tried to work around this by manually editing the 'my.ini' file as suggested, but neither was there a 'wait_timeout' line nor a 'max_allowed_package' line to be changed.
For documentation purpose I copy+paste the 'my.ini' (deleted all descriptions and XXX other parts for privacy safety reasons):

# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
# Generated by the MySQL Server Instance Configuration Wizard
...
#
# CLIENT SECTION
# ----------------------------------------------------------------------
...
#
[client]

port=3306

[mysql]

default-character-set=latin1


# SERVER SECTION
# ----------------------------------------------------------------------
#
...
[mysqld]
...
port=3306
...
basedir="C:/ProXXX/XXX/MySQL Server 5.5/"
...
datadir="C:/DokXXX/XXX/XXX/MySQL/MySQL Server 5.5/Data/"
...
character-set-server=latin1
...
default-storage-engine=INNODB
...
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_E NGINE_SUBSTITUTION"
...
max_connections=100
...
query_cache_size=0
...
table_cache=256
...
tmp_table_size=5M
...
thread_cache_size=8

#*** MyISAM Specific options
...
myisam_max_sort_file_size=100G
...
myisam_sort_buffer_size=8M
...
key_buffer_size=8M
...
read_buffer_size=64K
read_rnd_buffer_size=256K
...
sort_buffer_size=212K

#*** INNODB Specific options ***
...
innodb_additional_mem_pool_size=2M
...
innodb_flush_log_at_trx_commit=1
...
innodb_log_buffer_size=1M
...
innodb_buffer_pool_size=8M
...
innodb_log_file_size=10M
...
innodb_thread_concurrency=8

I manually added the 'max_allowed_package' line with a numeric value in the 'MySQL' section of the 'my.ini' file, but fpdb would crash even with files smaller than 256kb, so I deleted it again. Furthermore, it appears to make no difference starting fpdb with the run_fpdb.bat or fpdb.exe, as the problem remains.

------------------

Apologies in advance, but in a different matter I noticed two more things.

First, using SQLite and HUD a few days ago, my HUD error log reported the following issue:

Unhandled exception in thread started by <bound method HUD_main.read_stdin of <__main__.HUD_main object at 0x027CF610>>
Traceback (most recent call last):
File "HUD_main.pyw", line 273, in read_stdin
File "Database.pyc", line 881, in get_stats_from_hand
sqlite3.OperationalError: database is locked

I rarely use HUD, so I did not notice it earlier and have no clue what it means.

Secondly, I played ZOOM cash games in the past 3 days and the fpdb-log comes up with the following message (not an error, and hands are imported correctly using SQLite, but I thought I bring this up, but disregard it, if it's a known issue):

2012-04-22 03:05:39,812 - parser INFO HandHistory init - PokerStars site, PokerStarsToFpdb.PokerStars subclass, in_path 'C:\XXX\PokerStars\HandHistory\XXX\HH20120418 XXX - XXX - USD Pot Limit Omaha_Zoom.txt'; out_path '-'
2012-04-22 03:05:41,937 - parser INFO Lese 513 Hände
2012-04-22 03:05:41,937 - parser INFO readButton: nicht gefunden
2012-04-22 03:05:41,967 - parser INFO readButton: nicht gefunden
...
(nicht gefunden = not found in german)
Any hint or idea for me, please?

I apologize for this long report and thank you for any input or help!

Doc

WinXP SP3
fpdb 0.29.907
MySQL 5.5.23 (Win32)
Pokerstars; cash games (everything is set in English)

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')
innodb_buffer_pool_size = 410M (....before 'innodb_additional_mem_pool_size=2M')

Then change:

query_cache_size = 16M
myisam_max_sort_file_size = 256M

And rename 'table_cache' as:

table_open_cache = 256

After you're done, reboot the mysql server, or alternatively you can just restart your computer. Since you're running in INNODB mode, nothing in the *** MyISAM Specific options should matter (figured we'd lower myisam_max_sort_file_size just to be safe).

After you've rebooted, you can double check that the changes you've made have taken effect by typing into the MySQL command prompt:

show variables like 'max_allowed_packet';

If it's set to 100M, then you're good. If not, then MySQL Server isn't using the changes you've made which could have something to do with your windows permissions. When possible, always run these things 'As Administrator'.

Not sure why max_allowed_packet wasn't taking for you the first time. It's definitely something you'll want to set higher than default.

Also, I just submitted a patch that should fix this problem in another way, provided this doesn't work for you. sorrow's got to look it over, but I image we're getting pretty close to cutting another release. We'll keep you posted.

Sorry for the headache. Trust me, I feel your pain.