Unable to execute: INSERT INTO holdem_limit

[HellsDells]

2008/09/03 22:59:19.203: [00000800][PostgresConnection (Error)] Unable to execute query: INSERT INTO holdem_limit VALUES (5, '$3+$0.40 Hold'em No Limit NL', 0.00, 0.00, true, 2);; Reason: Fatal Error (ERROR: syntax error at or near "em" LINE 1: ...NSERT INTO holdem_limit VALUES (5, '$3+$0.40 Hold'em No Limi...

The last tournament showing in the Texas Holdem > Tournaments > Tournaments Pane is 9/2/2008 at 1:59PM start time. I have played 10+ MTTs and SNGs since then. They do not show in the Enter Results section either.

The auto import does not throw an error in the UI. The autoimport logs show hands being imported but they do not show.

2008/09/03 23:06:38: Info: PokerStars: Hand Imported (#20130401733).

I recently changed the config file to have "trust" instead of md5. I've changed it back and forth, restarted and rebooted multiple times to no effect.

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5

No clue what's going on. Please help -- the product is obviously of no use until this is corrected.

[WhiteRider]

Please enable logging, reproduce the problem by trying to import a few hands and submit your PokerTracker.log file to the Support system , and link to this thread in the reference field of the ticket so that we can investigate.

[HellsDells]

Thanks for the quick reply -- ticket generated.

I notice that the error is occuring on this line:

][HandHistoryDatabaseImport::DatabaseVariables::Entry] Beginning thread.
2008/09/04 20:21:33.312: [00003188][PostgresConnection (Error)] Unable to execute query: INSERT INTO holdem_limit VALUES (5, '$3+$0.40 Hold'em No Limit NL', 0.00, 0.00, true, 2);; Reason: Fatal Error (ERROR: syntax error at or near "em" LINE 1: ...NSERT INTO holdem_limit VALUES (5, '$3+$0.40 Hold'em No Limi... ^ )
2008/09/04 20:21:34.703: [00002520][AutoImporter] Hand Limit: $3+$0.40 Hold'em No Limit NL (9 max)

The string [Hold'em] contains a single quote that may be interferring with the single quote in the insert statement. I'm not familar with the parsing mechanism, but this may be the result of erroneous parsing here.

[WhiteRider]

Just to confirm - are you using Beta 17?
This is needed since the pokerstars update.

[HellsDells]

Thanks -- I was using build 2.00.

I downloaded beta 17 and it is now working, except for the cnt_r_first_raised_in thing, which I see other posts about.