PDA

View Full Version : Import Problems OnGame



23Tyler23
04-13-2009, 01:39 PM
So I tried Holdem Manager.
But any time I want to import hands I get import errors.
I use Windows Vista and HM Version 1.07
I updated my PostgreSQL Database I created a new Database for Holdem Manager but nothing works.
Now I activated the Log Database cofig Point and I got this:
The Error: ERROR: 42601: wrong number of parameters for prepared statement "csexecute_month"

Occurred when running ExecuteNonQuery with this query: EXECUTE CSExecute_month(1,0,4,-17500,900,-3,5,3,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,1,1,0, 0,0,0,0,0,0,0,0,0,2); EXECUTE CSPositionActionInsert_month(1,0,0,0,2,2,0,0,0,0,1 ,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

The Error: ERROR: 42601: wrong number of parameters for prepared statement "csexecute_month"

Occurred when running ExecuteNonQuery with this query: EXECUTE CSExecute_month(2,0,1,5500,167,1,1,1,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,1,0,0,0,0 ,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3 ); EXECUTE CSPositionActionInsert_month(2,0,0,0,0,0,0,0,0,0,0 ,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

The Error: ERROR: 42601: wrong number of parameters for prepared statement "csexecute_month"

Occurred when running ExecuteNonQuery with this query: EXECUTE CSExecute_month(3,1,17,-18000,5120,-3,6,1,0,1,0,2,0,1,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,3,1,0,1,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,7); EXECUTE CSPositionActionInsert_month(3,0,0,0,3,0,0,0,0,0,2 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,2,0,0,0,0,0,2,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,2,1,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0);

The Error: ERROR: 42601: wrong number of parameters for prepared statement "csexecute_month"

Occurred when running ExecuteNonQuery with this query: EXECUTE CSExecute_month(11,0,1,12500,0,2,5,1,1,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ); EXECUTE CSPositionActionInsert_month(11,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,1,1,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;
-----------------------
and so on.
So Im not shure what else I could try any Ideas are appreciated.

morny
04-13-2009, 05:23 PM
Update to this version http://www.holdemmanager.com/downloads/HmOmaha.exe and if the problem persists then create a new database http://www.holdemmanager.net/faq/afm...aspx?faqid=146 and see if they import now

23Tyler23
04-14-2009, 06:57 AM
I updated to the new Holdem Manager Version and created a new Database.
But I still get the import errors. :(

morny
04-14-2009, 08:44 AM
Can you email me the database thats giving these errors via www.yousendit.com to morny@holdemmanager.net and also link to this thread

23Tyler23
04-14-2009, 09:25 AM
Ok I send you a Backup of my Holdem Manager Database. Its probably empty cause I couldnt import any hands. I hope you can find the error thank you.