PDA

View Full Version : Holdem Manager Problems with import (errors)



imohar
03-28-2009, 06:55 AM
Hi,

when i try to import files from Pokerstars (saved as .txt from Pokerstars) i get only errors, it doesn't help if i do it manualy from a folder. I Use 1.07.01. I already created a new Database, the Problem Keeps the same. I try to import
62 Files and i get 2322 Erros and not one hand imported....

What is the Problem?

Kind Regards.

p.s. it's a Trial Version

Al1
03-28-2009, 06:59 AM
Can you attach those files.

imohar
03-28-2009, 04:58 PM
1060 yes here is one of theses...

morny
03-29-2009, 09:52 AM
Are you sure it didnt work with a new database? Ive tried it now and it works fine all 74 hands are imported with 0 errors, can you try updating http://www.holdemmanager.com/downloads/Hm1.08Beta.exe and then create a new database and reimporting

imohar
03-29-2009, 04:42 PM
hi,

i did what you said, but without any better Result, still 100% importinh Error. To be sure that my PC is not the Problem i took my Notebook and installed 1.7 first tried with a new database(same Problem) then i updated to 1.8 and created a new database but also the same error... I deactivaed all of my security tools without any result. The database is ok. (not on the same PC, it's an Dedicated Webserver)

Al1
03-29-2009, 10:29 PM
Can you attach you holdemmanager.config file.

Have you reused this file on the new PC?

imohar
03-30-2009, 02:59 AM
hi, attached you finde the file, and no i did not re-used the FIle.
To ensure that not the .conf file is the Problem i kicked the Holdem Manager folder after de-install it via Windows. BUt the Problem still exist.
Since the Database is a Internet host i deleted username and PW inside of the Config File. (The Password ist stored in clear Text?!? is already u bug open for that?)

morny
03-30-2009, 12:13 PM
Email me and well do a teamviewer session morny@holdemmanager.net

imohar
04-01-2009, 01:47 PM
Email me and well do a teamviewer session morny@holdemmanager.net

hi morny,

after our Teamviewer Session i did some tests, first i re-installed a local Postgres Database and it works... then i loggend into my host and looked into the Postgres DB log file and found that:

m18s20:/var/log/postgresql# more postgresql-7.4-main.log
2009-04-01 19:36:29 LOG: could not create IPv6 socket: Address family not supported by protocol
2009-04-01 19:36:29 LOG: database system was shut down at 2009-04-01 19:35:31 MEST
2009-04-01 19:36:29 LOG: checkpoint record is at 0/3687FAC
2009-04-01 19:36:29 LOG: redo record is at 0/3687FAC; undo record is at 0/0; shutdown TRUE
2009-04-01 19:36:29 LOG: next transaction ID: 20135; next OID: 18897
2009-04-01 19:36:29 LOG: database system is ready
2009-04-01 19:36:29 LOG: incomplete startup packet
2009-04-01 19:38:14 ERROR: there is no parameter $44
2009-04-01 19:38:14 ERROR: syntax error at or near "SAVEPOINT" at character 1
2009-04-01 19:38:47 ERROR: prepared statement "hhexecute" already exists
2009-04-01 19:38:47 ERROR: syntax error at or near "SAVEPOINT" at character 1
2009-04-01 19:38:48 ERROR: syntax error at or near "SAVEPOINT" at character 1
2009-04-01 19:38:49 ERROR: syntax error at or near "SAVEPOINT" at character 1
2009-04-01 19:38:50 ERROR: syntax error at or near "SAVEPOINT" at character 1
2009-04-01 19:38:51 ERROR: syntax error at or near "SAVEPOINT" at character 1


Is that part of my problem and when yes, how can i fix it?
(at 19:38 i startet the import of a handhistory)

morny
04-02-2009, 11:29 AM
Can you email me and remind me what the problem is and what we done, cant remember as i do quite alot of these

imohar
04-02-2009, 11:34 AM
this is already forwared to ray ;) he will look into it today,i will keep you updated

imohar
04-02-2009, 01:50 PM
ok, finaly ray figuerd out that the command savepoint is only available in postgres sql 8 and higher i was running 7.4.1. So i have to upgrade my db first.

morny
04-02-2009, 04:54 PM
Great glad you got it sorted in the end, its Roy btw:)