Import Errors
Results 1 to 7 of 7

Thread: Import Errors

  1. #1
    Junior Member
    Join Date
    Aug 2009
    Posts
    20

    Default Import Errors

    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.

  2. #2
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    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?

  3. #3
    Junior Member
    Join Date
    Aug 2009
    Posts
    20

    Default

    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.

  4. #4
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    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.

  5. #5
    Junior Member
    Join Date
    Aug 2009
    Posts
    20

    Default

    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.
    Last edited by unk78; 08-04-2009 at 08:39 AM.

  6. #6
    HM Support netsrak's Avatar
    Join Date
    Feb 2009
    Location
    Germany
    Posts
    25,795

    Default

    Please give me some details about the server,

    Operating system?
    Postgresql Version?

  7. #7
    Junior Member
    Join Date
    Aug 2009
    Posts
    20

    Default

    Debian, PostgreSQL 7.4

Similar Threads

  1. Import Errors
    By SootedNinjas in forum Manager General
    Replies: 2
    Last Post: 03-09-2009, 07:11 PM
  2. Getting a ton of import errors
    By bigjohnsn in forum Manager General
    Replies: 2
    Last Post: 02-10-2009, 11:15 PM
  3. Import Errors PS
    By zippo in forum Manager General
    Replies: 8
    Last Post: 01-20-2009, 04:50 PM
  4. Import Errors
    By vitti in forum Manager General
    Replies: 6
    Last Post: 12-27-2008, 04:48 PM
  5. Import Errors
    By weaktight in forum Manager General
    Replies: 9
    Last Post: 10-16-2008, 01:48 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •