Can't find my aliases in player list

[holdummmhero]

Ok I just bought a new computer and installed pt3 and am importing all of my old hands. For some reason, I can't find my old Party name or my older FTP name. I've imported multiple times and I see my alias in the hand histories, and it imports fine, but then it's not in the player lists. I have all of the filters off, and am using vista 64-bit with postgres 8.3. I'm probably doing something stupid and is easy to fix but I just can't figure it out.

[keggler]

are you sure it's a 64 bit vista? installing postgres on a 64 bit windows o/s is not that straight forward...


susan

[holdummmhero]

Yeah it's 64-bit, although when I go to display settings, under colors it says the highest is 32 bit, i don't know if that means something or not. Anyways, I didn't have any problems installing pt3, went the same as it went when i installed it on my old 32 bit vista.

[WhiteRider]

The colours is a different thing..
After you import, make sure you click Refresh, and that you don't have any filters set.
Can you find any players that were in hands with your player names you can't find.

[holdummmhero]

Yeah i've refreshed and all filters are off. I searched for other players in the hand, and some came up some didn't. The ones that did, I searched for them "vs player" and they were never against the alias I am trying to find, either a datamined hand or against my other alias I already have connected.

[holdummmhero]

And also the aliases worked in one database, but not this database, any ideas?

[WhiteRider]

Double-check that you are importing into the current active database.
Find a HH file that includes hands played by this player.
Manual import that single file - any hands imported, errors, duplicates?

And also the aliases worked in one database, but not this database

Was that on this same computer?
If you create a new database now, does it work in there too?

Try using the database menu to cluster, vacuum, analyse the DB.

[holdummmhero]

Yeah I've imported the single file with the alias, and it says no errors, 500 or so duplicates, and no hands imported. I've analyzed, clustered, and vacuumed, no help. And the aliases do appear on my other database on the same computer. And I made sure I was importing to the right database.

[WhiteRider]

OK - let's see if you can see your player name if we look directly in the database using PGAdmin.

Start -> Programs -> PostgreSQL8.x -> PGAdmin III

DON'T CHANGE ANYTHING!!
We're just searching...

Top left you see object browser, open the database server, choose your database and connect.
The default password is dbpass. If you changed it or install postgres manually, use your password, if you have passwords turned off then you won't need to worry.

Open Schemas / public / tables / player.
On the toolbar click the grid icon with what looks like a little wine glass in the corner - mouseover says 'apply a filter and view the data in the selected object'.
In the window that comes up enter as search string:
player_name='<player>'
e.g. mine would be player_name='WhiteRider'.
The player name is case sensitive (or you can search for player_name_search='<player>' which isn't).
Hit OK.
Do you see your player?

If not, try using the other grid icon to list the whole of the player table and sort it to find your player.
Any joy?

DON'T CHANGE ANYTHING!!

[holdummmhero]

Ok this is what came up: 264;300;"iplaysoccer6986";"iplaysoccer6986";1;0;FALSE under the categories that didn't copy over