PDA

View Full Version : Import Errors



unk78
08-03-2009, 08:41 AM
How do i find out why none of my hands were imported?!



This is the SQL log:

The Error: ERROR: 42704: index "compiledresults_month_idx1" does not exist

Occurred when running ExecuteNonQuery with this query: DROP INDEX compiledresults_month_idx1

The Error: ERROR: 42704: index "compiledresults_month_idx1" does not exist

Occurred when running ExecuteNonQuery with this query: DROP INDEX compiledresults_month_idx1

The Error: ERROR: 42601: syntax error at or near ";"

Occurred when running ExecuteNonQuery with this query: CREATE LANGUAGE plpgsql;

The Error: ERROR: 42601: syntax error at or near ";"

Occurred when running ExecuteNonQuery with this query: CREATE LANGUAGE plpgsql;




Well its not really helpful because it doesnt have a timestamp.

And i had 29053 Import Errors but these are only 4 lines.

Is there any other log where the errors are explained specifically?

Im trieng to use a database in a network instead of one on my pc.

netsrak
08-03-2009, 09:00 AM
You could look in the importing\logs folder but the database seems to have not the right structure or coding.

Did you create it via Holdemmanager->database management?

unk78
08-03-2009, 09:05 AM
yes i did create the database using HEM.

im also using the superuser account "postgres"

in the importing/logs is nothing written, only a few hands but not 29k.

netsrak
08-03-2009, 10:05 AM
Thats strange, which Postgresql version, which HM Version?

Can you please delete the SQL.LOG and try to import some hands again so that we are sure it contains actual messages.

unk78
08-04-2009, 08:34 AM
this is from "\Holdem Manager\Logs\SQLErrors.txt"

The Error: ERROR: 42704: index "compiledresults_month_idx1" does not exist

Occurred when running ExecuteNonQuery with this query: DROP INDEX compiledresults_month_idx1

The Error: ERROR: 42601: syntax error at or near ";"

Occurred when running ExecuteNonQuery with this query: CREATE LANGUAGE plpgsql;

this is from "\Holdem Manager\Importing\Import Errors\ImportErrors.txt"

D:\hh\fullTilt\xyz\FT20090804 Bracken (6 max) - $0.01-$0.02 - Pot Limit Omaha Hi.txt ERROR: 42601: syntax error at or near "SAVEPOINT"




And i just tried the same procedure with a localhost database and i dont get any of these errors in the logfiles and everything works fine.
Oh but that local database i created month ago, the other one i created today.

netsrak
08-04-2009, 09:47 AM
Please give me some details about the server,

Operating system?
Postgresql Version?

unk78
08-04-2009, 02:18 PM
Debian, PostgreSQL 7.4