2.50 (release version) works fine for me in index mode, but trying to get it working on my system in sql mode gives the following error message when I try to import the gedcom
Reading Gedcom File ../php1.GED
Flushing contents
ERROR:Column count doesn't match value count at row 1
SQL:INSERT INTO pgv_other VALUES ('HEAD','php1.GED','HEAD','0 HEAD 1 SOUR GENBOX 2 VERS 3.1.3 2 NAME Genbox Family History 2 CORP Thoughtful Creations 3 ADDR PO Box 112077 4 CONT Cincinnati, OH 45211 4 CONT USA 1 DATE 11 SEP 2003 2 TIME 22:54:38 1 SUBM @SM1@ 1 FILE D:\\My Documents\\D4Web\\php1.GED 1 GEDC 2 VERS 5.5 2 FORM LINEAGE-LINKED 1 CHAR ANSEL ')
I guess this is probably me being very stupid, but how do I fix it? Index mode finds that file path to the same gedcom, so I am assuming that is not the issue.
Many thanks for all your superb work
Julia
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Julia,
I remember having the same problem a while ago. I think I solved it by manually dropping the tables in the database. What you have left then, is an empty database without tables in it and creating the tables from within phpGedview should work correctely then.
Hope this helps!
Boudewijn.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I also experienced this particular problem, and I also solved just like Boudewijn by manually dropping the tables from my phpMyAdmin interface, but I think it would be a better solution if John would consider changing the setup_database() function so that phpGedView will drop existing tables when needed.
best regard
Arne
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello
2.50 (release version) works fine for me in index mode, but trying to get it working on my system in sql mode gives the following error message when I try to import the gedcom
Reading Gedcom File ../php1.GED
Flushing contents
ERROR:Column count doesn't match value count at row 1
SQL:INSERT INTO pgv_other VALUES ('HEAD','php1.GED','HEAD','0 HEAD 1 SOUR GENBOX 2 VERS 3.1.3 2 NAME Genbox Family History 2 CORP Thoughtful Creations 3 ADDR PO Box 112077 4 CONT Cincinnati, OH 45211 4 CONT USA 1 DATE 11 SEP 2003 2 TIME 22:54:38 1 SUBM @SM1@ 1 FILE D:\\My Documents\\D4Web\\php1.GED 1 GEDC 2 VERS 5.5 2 FORM LINEAGE-LINKED 1 CHAR ANSEL ')
I guess this is probably me being very stupid, but how do I fix it? Index mode finds that file path to the same gedcom, so I am assuming that is not the issue.
Many thanks for all your superb work
Julia
Julia,
I remember having the same problem a while ago. I think I solved it by manually dropping the tables in the database. What you have left then, is an empty database without tables in it and creating the tables from within phpGedview should work correctely then.
Hope this helps!
Boudewijn.
Hi Julia and Boudewijn
I also experienced this particular problem, and I also solved just like Boudewijn by manually dropping the tables from my phpMyAdmin interface, but I think it would be a better solution if John would consider changing the setup_database() function so that phpGedView will drop existing tables when needed.
best regard
Arne
As Arne suggested, I've created a patch that will automatically detect if the tables are old and drop them. You can download it here:
http://sourceforge.net/tracker/index.php?func=detail&aid=809310&group_id=55456&atid=477081
--John
Thank you John, it's much appreciated!
best regard
Arne