Moved DB to new Computer, can't import anymore.

[ninjahomer]

Old system ran postgres 8.2, new system runs 8.2. Used the DB backup/restore from PT2, not directly running pg_dump myself.

Now every time I try to import I get this - any ideas??


*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: Select error: SQLSTATE = 22P05
ERROR: character 0xc691 of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query
DataObject: d_player_names
Syntax In Error: SELECT players.screen_name,
players.location,
0 as handle,
players.treeview_icon,
players.player_id,
players.main_site_id,
players.site_id,
players.alias_id,
players.hide_ind,
players.ring_player,
players.tourney_player,
upper(players.screen_name) as upper_name
FROM players
WHERE ( players.main_site_id = 2 ) OR
( players.player_id = 0 )

*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'shipdatchz', 1, 75047, 2, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'shipdatchz', 1, 75047, 2, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: Select error: SQLSTATE = 22P05
ERROR: character 0xc691 of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query
DataObject: d_player_names
Syntax In Error: SELECT players.screen_name,
players.location,
0 as handle,
players.treeview_icon,
players.player_id,
players.main_site_id,
players.site_id,
players.alias_id,
players.hide_ind,
players.ring_player,
players.tourney_player,
upper(players.screen_name) as upper_name
FROM players
WHERE ( players.main_site_id = 2 ) OR
( players.player_id = 0 )

*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'Tryptamean', 1, 75049, 2, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'Tryptamean', 1, 75049, 2, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: Select error: SQLSTATE = 22P05
ERROR: character 0xc691 of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query
DataObject: d_player_names
Syntax In Error: SELECT players.screen_name,
players.location,
0 as handle,
players.treeview_icon,
players.player_id,
players.main_site_id,
players.site_id,
players.alias_id,
players.hide_ind,
players.ring_player,
players.tourney_player,
upper(players.screen_name) as upper_name
FROM players
WHERE ( players.main_site_id = 2 ) OR
( players.player_id = 0 )

*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'stillfan', 1, 75049, 2, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'stillfan', 1, 75049, 2, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: Select error: SQLSTATE = 22P05
ERROR: character 0xc691 of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query
DataObject: d_player_names
Syntax In Error: SELECT players.screen_name,
players.location,
0 as handle,
players.treeview_icon,
players.player_id,
players.main_site_id,
players.site_id,
players.alias_id,
players.hide_ind,
players.ring_player,
players.tourney_player,
upper(players.screen_name) as upper_name
FROM players
WHERE ( players.main_site_id = 2 ) OR
( players.player_id = 0 )

*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'Tryptamean', 1, 75050, 2, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'Tryptamean', 1, 75050, 2, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: Select error: SQLSTATE = 22P05
ERROR: character 0xc691 of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query
DataObject: d_player_names
Syntax In Error: SELECT players.screen_name,
players.location,
0 as handle,
players.treeview_icon,
players.player_id,
players.main_site_id,
players.site_id,
players.alias_id,
players.hide_ind,
players.ring_player,
players.tourney_player,
upper(players.screen_name) as upper_name
FROM players
WHERE ( players.main_site_id = 2 ) OR
( players.player_id = 0 )

*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: SQLSTATE = 23505
ERROR: duplicate key violates unique constraint "player_idx_01";
Error while executing the query

No changes made to database.

INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'turffire1', 1, 75057, 2, 0, 1, 0 )
DataObject: d_player_names
Syntax In Error: INSERT INTO players ( screen_name, treeview_icon, player_id, main_site_id, hide_ind, ring_player, tourney_player ) VALUES ( 'turffire1', 1, 75057, 2, 0, 1, 0 )
*********************************

*********************************
PT Version: 2.17.03d
Error Date: 10/26/2008 09:41
Database Error: 7
Error Text: Select error: SQLSTATE = 22P05
ERROR: character 0xc691 of encoding "UTF8" has no equivalent in "WIN1252";
Error while executing the query
DataObject: d_player_names
Syntax In Error: SELECT players.screen_name,
players.location,
0 as handle,
players.treeview_icon,
players.player_id,
players.main_site_id,
players.site_id,
players.alias_id,
players.hide_ind,
players.ring_player,
players.tourney_player,
upper(players.screen_name) as upper_name
FROM players
WHERE ( players.main_site_id = 2 ) OR
( players.player_id = 0 )

*********************************

[WhiteRider]

I'll move this to the PT2 section of the forum where you'll get better help..

[ptrack pat]

What email was used to purchase PT2? I have no record of this one used for the site.

[ninjahomer]

PM sent with email info.

[ptrack pat]

Open the Utilities > PostgreSQL Settings window. What values do you have selected in the ODBC Entry to Use and Encoding fields?

[ninjahomer]

ODBC Entry to use: Postgresql ANSI
Encoding: UNICODE

I have both the old and the new server available right now, so if I need to backup from the old system again I can. If I point PT2 back to the old server I can still import no problem.

[ptrack pat]

It needs to be PostgreSQL Unicode. Change it and save the changes.

Then open the File > Maintain Database Names window, click the Add button, enter a description, check the "Dflt" box and in the last field choose "Select existing PostgreSQL database". On the window that opens select the PostgreSQL database. Then click OK to save all changes. CLOSE AND REOPEN POKER TRACKER.

[ninjahomer]

That seems to have worked. Thanks!!