Menu

SQL Error when importing gedcom file

Help
Anonymous
2004-07-29
2004-07-31
  • Anonymous

    Anonymous - 2004-07-29

    Hello,

    I have a new problem when importing my first gedcom :

    Etape 4/4 : Import d'enregistrements dans la base de donnes
    ERROR:
    SQL:CREATE TABLE pgv_individuals (i_id VARCHAR(30), i_file VARCHAR(255), i_rin VARCHAR(30), i_name VARCHAR(255), i_isdead INT(1) DEFAULT 1, i_gedcom TEXT, KEY index_id (i_id), KEY index_name (i_name), KEY index_rin (i_rin))

    Impossible de crer la table : Individuals

    When I have a look with MySQL, following tables are existing :
    herve_sabot.pgv_blocks check status OK
    herve_sabot.pgv_favorites check status OK
    herve_sabot.pgv_individuals check status OK
    herve_sabot.pgv_messages check status OK
    herve_sabot.pgv_news check status OK
    herve_sabot.pgv_users check status OK

    What can I do ?

    Regards

     
    • John Finlay

      John Finlay - 2004-07-31

      Are you upgrading from an older version or is this a fresh install?

      You should delete the pgv_individuals table from your database.  All of the other tables above can stay.  You can do this with the following sql command:
      DROP TABLE pgv_individuals;

      Then try importing again.
      --John

       
    • Anonymous

      Anonymous - 2004-07-31

      Sorry but this did not work.
      I had to modify the script (ignoring sql errors - The tables were created), and import twice. It works now because the database structure is created.
      Possible problem in MySql configuration?

      Regards

       

Log in to post a comment.