PS error: Unable to get the game date(2)
Posted:
Thu Jan 01, 2009 9:16 amby Blue Lagoon
Unable to get the game date(2)... 2009/01/01 8:00:53 ET
Should I change anything? I have try to change time zone but doesn't help.
Re: PS error: Unable to get the game date(2)
Posted:
Thu Jan 01, 2009 10:26 amby ptrack pat
What email was used to purchase PT2? I have no record of this one used for the site?
Re: PS error: Unable to get the game date(2)
Posted:
Thu Jan 01, 2009 1:58 pmby ptrack pat
It says you deleted the PM before I could read it.
Re: PS error: Unable to get the game date(2)
Posted:
Sun Jan 04, 2009 1:28 pmby cartamundi
I got this error too. DBCode -1003, error text SQLSTATE S1093.
let me know if you need more info to debug.
Re: PS error: Unable to get the game date(2)
Posted:
Sun Jan 04, 2009 3:58 pmby ptrack pat
cartamundi wrote:I got this error too. DBCode -1003, error text SQLSTATE S1093.
let me know if you need more info to debug.
This is not the same error message. What is the EXACT message you are getting? I need the full text.
Re: PS error: Unable to get the game date(2)
Posted:
Sun Jan 04, 2009 10:01 pmby cartamundi
I sent a copy of one of my files for the game date issue to support. I think an update to the latest version may have solved this.
the other problem I have seems more significant. here is an example:
*********************************
PT Version: 2.17.03d
Error Date: 01/04/2009 20:50
Database Error: -1003
Error Text: SQLSTATE = S1093
[Microsoft][ODBC Microsoft Access Driver] Invalid argument.
No changes made to database.
INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 428127, 428127, 2, {ts '2008-12-31 00:36:34'}, 1, 1.0000, 0.0000, 55552, {ts '2009-01-04 20:50:44'}, 'Lunaria', '(did not show hand)', 55552, 0, 10, '23423657635', 0 )
DataObject: d_game
Syntax In Error: INSERT INTO game ( game_id, game_number, site_id, date_played, game_level_id, pot, rake, player_id, import_date, table_name, winning_hand, real_player_id, players_saw_flop, number_of_players, ub_game_number, ub_kill_game ) VALUES ( 428127, 428127, 2, {ts '2008-12-31 00:36:34'}, 1, 1.0000, 0.0000, 55552, {ts '2009-01-04 20:50:44'}, 'Lunaria', '(did not show hand)', 55552, 0, 10, '23423657635', 0 )
*********************************
I will send a support ticket for this shortly, as well.
Re: PS error: Unable to get the game date(2)
Posted:
Mon Jan 05, 2009 10:36 amby cartamundi
the DB repair took all night while I was sleeping but seemed to do the trick. thank you sir
