Quote:
Originally Posted by riverofjustice
Email sended
...
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
....
Cant import files larger than 256kb here as well.
I received your email and have responded, I'll continue this there.
Quote:
Originally Posted by cjm2009
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??
Sorry cjm2009, unless we have a text file (or some other data representation) to work with we can't support the site.
Quote:
Originally Posted by rizzler
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!
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.
Quote:
Originally Posted by GDog1666
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.
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.
Quote:
Originally Posted by JasonMilo911
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.
Quote:
Originally Posted by Doc Svenson
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).
fpdb startet ...Traceback (most recent call last):
...
File "Hand.pyc", line 298, in insertHandsPlayers
File "Database.pyc", line 2106, in storeHandsPlayers
File "MySQLdb\cursors.pyc", line 223, in executemany
...
_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
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.
Code:
File "/usr/lib/pymodules/python2.7/MySQLdb/cursors.py", line 280, in _do_query
db.query(q)
_mysql_exceptions.OperationalError: (1153, "Got a packet bigger than 'max_allowed_packet' bytes")
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:
Code:
Traceback (most recent call last):
File "./fpdb.pyw", line 530, in dia_recreate_tables
t.importer.database.resetPlayerIDs()
AttributeError: Database instance has no attribute 'resetPlayerIDs'
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
Quote:
You are using a Windows client and the server had dropped the connection (probably because wait_timeout expired) before the command was issued.
The problem on Windows is that in some cases MySQL does not get an error from the OS when writing to the TCP/IP connection to the server, but instead gets the error when trying to read the answer from the connection.
...
The solution to this is to either do a mysql_ping() on the connection if there has been a long time since the last query (this is what Connector/ODBC does) or set wait_timeout on the mysqld server so high that it in practice never times out.
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