AKingdon, normaly I would sayvthatvit work. For me, at less, the HUD kept his pkace. I had a problem with the stats, they were all mixed up but Phil gave me the solution with the config file

If you read this Phil, I'n not sure what you mean by "fiddle" with the fav_seat numbers. You mean change a 0 by a 1 on my seat ??? I very very far from beeing a geek ... :'(

Yes, try changing it to 1, 2, 3... each time restart HUD and see if it is in the right place. (I think you could just set to 1 and move all HUD boxes around table to the right places, but not sure.)

Hi,

Trying to convert from sqlite to mysql. Here is my <supported databases> tag in HUD_config.xml:

<database db_server="mysql" db_user="fpdbuser" db_pass="newPassword" db_name="fpdb" db_ip="localhost"></database>

When I go back and try to open fpdb, it starts but then quickly closes. I can't even access the logs (through the gui). I switched it back to sqlite and it works again. I looked in the logs at that point and see several lines like this:

2015-01-28 12:23:03,349 config INFO Reading configuration file /Users/hero/.fpdb/HUD_config.xml
2015-01-28 12:23:07,189 parser INFO xlrd not found. Required for importing Excel tourney results files

There's about a dozen of these before I see:

2015-01-28 12:31:28,699 db INFO Connecting to SQLite: /Users/hero/.fpdb/database/fpdb.db3


which is when i reverted it back to sqlite.

Any help appreciated.

Firstly, I thought I included xlrd in my latest RC. Are you running rc5?

Zannapp has kindly helped me figure out the MySQL issue with rc5. There is a mini-release here that you can extract over the top of rc5 which should make MySQL work. Or you can wait for me to make a new rc6 release, which I intend to do quite soon.

Would love to try this fix but it looks like everything is .exe. I'm on OS X Yosemite. Any chance you have an OSX mini-fix handy?

Oh, I'm sorry. I've been responding to windows people so much I stupidly assumed (and you've posted before, right? I feel so dumb right now).

The OSX package doesn't have MySQL support at all - I was waiting for someone to request it before doing the work. Now you have, I shall! Stay tuned for the next release.

The only dumb thing was for me not to tell you I'm on OSX.

I have another question for you anyway, I'm having trouble understanding how a session is defined. I *think* I'm missing some sessions in the sessions graph but I've been wrong about that before (i.e. I thought I was missing a session when, in fact, the session just didn't contain any hands.)

I see this in my sqllite db (can't wait for MySQL! actually, does postgres work already on OSX?):
select count(*), min(starttime), max(starttime) from Hands where starttime > '2015-01-27 10:00' and starttime < '2015-01-28';
12|2015-01-27 21:08:14+00:00|2015-01-27 22:41:47+00:00

however, in my sessions UI, I only see 4 hands for one session on the 27th. So the hands seem to be in the DB but not showing up in the UI somehow? Seems odd to me.

I'll try to set up the postgres db after tonight's session.

Could be a timezone thing? I haven't looked too hard at the code, but I think times are converted to UTC before storing in the DB. IIRC the UI does some funky stuff to work out date/time cutoffs as well - I think it assumes that the 'day' starts at some offset from midnight (I think the default is 5 hours, but it's configurable) to account for the fact that a lot of poker players are night owls.

Postgres should work. I use it myself.

Before you try postgres though, I got excited and did the mysql thing already. There's a zipfile here containing four files - fpdb, HUD_main, _mysql.so and libmysqlclient.18.dylib. Extract them into fpdb.app/Contents/MacOS - overwrite fpdb and HUD_main. Make a backup first (or keep your original rc5 zip ready to go) in case I goofed again.

Hmm... didn't work for me, phil.

I copied the files into the MacOS dir as you said and fired up fpdb but it crashed before it could open fully.

good thing I've got the original zip ;-)

That's a bummer. Anything in log files?

Meanwhile you could try postgres with rc5.

Actually now that i'm looking at it, it looks like I had rc3 running.

I'll update to rc5 and give it a go again.

ok.

So I moved back to rc5. sqlite still works :-)

I tried to switch to postgres, but it gave me some message about "An invalid DB version or missing tables". Is there some schema I file I need to run or tables I need to set up first?

regardless, running mysql just gives me a quiet crash with nothing of interest in the logs.

2015-01-28 22:57:10,449 config INFO Reading configuration file /Users/hero/.fpdb/HUD_config.xml
2015-01-28 22:57:10,922 db INFO Failed to read settings table. - Please recreate tables.
2015-01-28 22:57:51,717 config INFO Reading configuration file /Users/hero/.fpdb/HUD_config.xml
2015-01-28 22:58:19,046 config INFO Reading configuration file /Users/hero/.fpdb/HUD_config.xml
2015-01-28 22:58:19,526 db INFO Connecting to SQLite: /Users/hero/.fpdb/database/fpdb.db3

Nevermind re: postgres issue. I did the Maintenance > create/recreate tables thing (after googling)

But mysql isn't working still. I'm happy with postgres though, so it's up to you if youw ant to tinker with it.

fpdb-errors log? It gets wiped every time you run so you should run with mysql again then check fpdb-errors.

Oh just saw your next post. If you are happy with pgsql then no need to invest your time debugging mysql for me. I will look into it on my own time.

Edit: btw I found a bug with postgres and tournament hands the other day, fixed for next release.

Hi,Is there any development of FPDB or the last update from 2013?
Also can someone share his good hud settings for NLHE?

Haven't managed to figure this out, if someone wants to help me over skype I will compensate it with some fair amount

How do I change the HUD stats?

http://forumserver.twoplustwo.com/sh...postcount=7500

Hey Phil,

Got pgsql working just fine (for now!) so don't worry about the mysql for mac fix for my sake.

Wanted to take a look at the sessions code though. Could you point me in the right direction? I still don't know my way around the codebase.

GuiSessionViewer.py <- does the graphing and table
Filters.py <- the left sidebar that handles dates

SQL.py <- search for "sessionStats"

Awesome. Thanks.

I see something wrong with the one session that looks like it's missing:

fpdb=# select id from Hands where starttime > '2015-01-27 17:00' and starttime < '2015-01-28';
id
------
1409
1410
1411
1412
1413
1414
1415
1416
(8 rows)

fpdb=# select count(*) from handsplayers where handid in (select id from Hands where starttime > '2015-01-27 17:00' and starttime < '2015-01-28');
count
-------
0
(1 row)


Not sure how to re-import hands that are in the hands table but not in handsplayers. Any thoughts? Keep in mind I just re-created all the tables when i switched from sqllite to pgsql.

Any help appreciated as always.

You're stretching the limits of my knowledge here, I'm not a database guy and I didn't write any of the original DB code for FPDB. Can we take this offthread to irc/skype/something else a bit more interactive? I have some ideas and I'm sure we can figure it out but the back and forth over a forum thread is a bit painful.

yep. pm sent.

Many thanks to nookatee, between us we tracked down a bug in the BetOnline HH parser. Largely due to the fact that BetOnline hand histories are apparently the work of satan. Some kind of fix will be in the next release but I don't think there's a robust way to deal with all possible cases. I'll probably go with nookatee's suggested solution - it should preserve hero's profit stats in most cases.

Hi

i just started using fpbd because it seems the only one to work with "seals with clubs".

I have a problem with some tables where the autoimport get errors (and bulk too)... whether nlhe or plo. It looks like HU table are ok and some times other tables work too...

Is it a known issue? Can i do something with my config or is it a problem of the hh of seals that changed of format?

thanks in advance

abakobo