PS error: Unable to get the game date(2)

[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.

[ptrack pat]

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

[Blue Lagoon]

sorry.
pm sent.

[ptrack pat]

It says you deleted the PM before I could read it.

[cartamundi]

I got this error too. DBCode -1003, error text SQLSTATE S1093.

let me know if you need more info to debug.

[ptrack pat]

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.

[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.

[ptrack pat]

See the FAQ, issue #2
viewtopic.php?f=30&t=1377

[cartamundi]

the DB repair took all night while I was sleeping but seemed to do the trick. thank you sir