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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
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
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
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