HarryA wrote:
Hi
I'm using this new version of Gametime+ with PostgreSQL 8.2 database. I got following error message when trying to add (or Gametime+ automatically tried) Pokerroom statistics to table. Statistics are correctly imported and showing PokerTracker. I'm using latest version of PT.
Code:
Error
Code = 80004005
Code meaning = Unspecified error
Source = Microsoft OLE DB Provider for ODBC Drivers
Description = ERROR: syntax error at or near "s";
Error while executing the query
Any idea how to fix this?
Other version (including 1.4.7 and unofficial patch) doesn't work with my PostgreSQL.
I'm using v 1.4.6 (the one w/ auto-adding of tables and support for psql) and I just encountered the exact same problem.
I don't know if this has been fixed, but I think I know what the problem is. It happens when you play on a private table. The table is named "xyz's HE" and GameTime+ can't really cope with the ' part of the name (common SQL problem, the ' has to be converted into an escape sequence) and creates an invalid SQL statement. It should be an easy fix.
It's pretty annoying though, because although you can purge that session from your PT database, it will be autoimported again from the PokerRoom.com database next time you import HH's from PokerRoom.com and GameTime+ will keep giving you the error message. A way to get around this problem is to
1) import all HH's you need from the PokerRoom.com database
2) purge the sessions with private tables.
3) Delete/rename the PokerRoom.com database folder.
The PokerRoom.com will automatically recreate the folder and a database for you and you should be able to continue as usual. If you import all you your HH's into PT anyways, deleting the PokerRoom.com database shouldn't be a problem. Also it enhances the speed of import when you delete the database from time to time.
Until there's a fix for this bug, just don't enter private tables and you should be fine.