PDA

View Full Version : Syntax Error at or near ","



JohnNilsson
04-24-2011, 07:24 AM
Hello,

After importing my rather large database from last year (8K SnG), and when trying to filter out for certain hands I receive this error message:

The following error occured when running this report: ERROR: 42601: syntax error at or near ","


I have deleted the filter, tried to change player, restarted the programm, even tried to do a full database management (which itself stops "from user request" after 10 mins for some reason) and nothing helps.

Before this massive import of database, it was working just fine, though with long waiting times when I selected filters to apply. I had about 1-2k games in the database only tho.

This error is annoying, as apart from looking at my pretty graph or anything in the "tourney result" view, nothing shows!

Patvs
04-24-2011, 05:02 PM
Which SQL version are you using?

Update to the latest version from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)
Read:
http://forums.holdemmanager.com/manager-general/11194-top-10-hem-performance-increase-tips.html

(edit the postgresql.conf)

Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe



And reimport the hands again into a new database.
As a test, only import a small sample of SNGs, and run the filter to see if you still get the same error.