pto box self-selecting?

[djfl]

This is the 4th time I've noticed the FTP "do not import
observed hand histories" button has self-selected. I keep
the button deselected so that I can datamine. It seems
to self-select when I import a backed-up database from
another computer...tho I also datamine FTP on THAT
computer. Really weird.

Anyway, it occurred this time in conjunction with a PAHUD error...

"SQL exception while trying to query player:
Error executing "SELECT main_site_id, alias_id, treeview_icon
FROM players WHERE screen_name='Smaugs' AND main_site_id=(
SELECT site_id FROM poker_sites WHERE site_abbrev='FTP')":
ERROR:more than one row returned by a subquery used as an
expression;

The PAHUD error is not limited to the player Smaugs...I get the message with pretty much all players. I'll post this in both the PTO and PAHUD forums as they may be related, but are certainly from the different programs.

[djfl]

I may have partially figured out the answer, I just opened my database for inspection and all my old info is gone. It only has the tables/players that I've mined into it over the past 24hours. I use postgresql database. Do I have to reload the database and lose all the info I've put in?

thanks.

[ptrack mike]

It seems to self-select when I import a backed-up database from another computer...

That is exactly why it appears to self-select. This value and well as the other values on that tab are stored in the prefs table in your database. If you import from a backup of an old database it will always set the values to be what they were when you made the backup.

I don't know where your data could have gone if it's missing after you imported it. If you look at the data on the source computer is it all there?

[djfl]

I just checked PTO on the other computer. FTP is set to import observed hands and my database is normal. I vacuumed/analyzed, backed up the database, and brought it to the new computer. Now I have no database and the "don't import observed hands" is selected.

1) Why could this be happening?
2) While I do want to know why it's happening, firstly I'd really want to get my database updated quickly. Should I just make another backup of the database and bring it over to the other computer again? If so, how can I get the hands I've datamined over the last 24hrs into the new database?

thanks again.

[ptrack mike]

1. Something doesn't sound right. Are you importing the observed hands into the same database that you are exporting or are you using the option on that tab to import into a different database? The setting for "Do Not Import..." is stored in your default database.

2. I'm still not sure I totally follow where you have all these hands, but load up the database with all the older hands, then import the last 24 hours of observed hands from your processed folder or wherever you have them using File > Import Hand Histories...

[djfl]

"Error retrieving from the VERSION_INFO table
3-"

This is the error message I get when I start up PTO on the computer with the malfunctioning database.



1)I'm importing the observed hands into the same database that I imported from the other computer. I only maintain one postgresql database each for holdem and omaha. The SQL databases are set as my default on both computers.

2)Hmm, I'm not sure I totally follow what you mean either. We rock! :) What I mean is that all my stored hands up until 24 hours ago are on my laptop database, vacuumed and backed up. I then transferred that backed up database to my desktop computer and I've been having errors ever since then. I didn't realize the errors right away and I've been adding FTP hands to the...I guess empty...database ever since. I've had PTO set to auto-import, so these hands have already been run thru and moved by PTO. I guess I could go to the folder that stores my processed hand histories and just reimport the latest ones?
This still doesn't solve what I have to do to get my desktop computer up and running with a proper database. It's possible the backup became corrupted somehow I guess? Or the importing of the database didn't take?
Should I make a new backup on the laptop...with the working database...and try again?

[djfl]

FWIW, I have PAHUD running on the laptop and I'm dataming Party. All the hands are showing a Pot size of either 0 or N/A. I know this isn't the PAHUD forum, but I'm assuming it's related. It seems to be showing all the other stats properly. If it's not related, I'll repost it in the PAHUD forum.

[ptrack mike]

I guess I could go to the folder that stores my processed hand histories and just reimport the latest ones?

Yes, that would be the best solution. But something must be wrong with the database.

"Error retrieving from the VERSION_INFO table
3-"

That means a table is missing from the database, so something isn't working when you are importing the backup file from the other PC to the new one. I am surprised you aren't getting a error when you restore the backup. Are the laptop and desktop using the same exact versions of PostgreSQL?

It's possible the backup became corrupted somehow I guess? Or the importing of the database didn't take?
Should I make a new backup on the laptop...with the working database...and try again?

Yes, try that. Something isn't working with the backup/restore process.

FWIW, I have PAHUD running on the laptop and I'm dataming Party. All the hands are showing a Pot size of either 0 or N/A. I know this isn't the PAHUD forum, but I'm assuming it's related. It seems to be showing all the other stats properly. If it's not related, I'll repost it in the PAHUD forum.

That sounds like a PA HUD issue so please post those in their forum so they can help you.

[djfl]

I got my postgresql links...and all postgre info for that matter...from pokertracker.com. Both computers are running Postgre 8.2.

Under postgre release notes, both have info on Release 8.2.6 and previous...so I'm assuming both are 8.2.6.

[ptrack mike]

Did you try backing up the laptop database and restoring the file on the desktop? Did it work this time? If not, what does it say when you do the Restore? Are there errors?