I have installed phpgedview and passed the first configuration screen where I chose to use MySQL
I created an administrator account
when I tried to upload a gedcom file, I got an error message saying that the database is missing the pgv_individuals table.
I have checked it using my MySQL client and indeed no such table exists.
The tables that were created are:
pgv_blocks
pgv_favorites
pgv_messages
pgv_news
pgv_users
What could be the problem?
Am I missing more tables?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
The pgv_individuals, pgv_families, pgv_sources, pgv_places, and pgv_other tables will be created when you import the gedcom. If you are able to continue uploading then you can ignore this error message and continue to import.
You say that you get this message on uploadgedcom.php? Anything else included in that error message like line numbers that could help us in debugging the beta?
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2004-03-23
this is the complete error:
ERROR:Table 'phpgedview.pgv_individuals' doesn't exist
SQL:SELECT SUBSTRING_INDEX(i_name, ',', 1) as surname, COUNT(*) FROM pgv_individuals WHERE i_file='bkentsm2.ged' GROUP BY SUBSTRING_INDEX(i_name, ',', 1)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Index mode will work because this is a MySQL SQL error.
The reason for the error is that the program is trying to find the most common surnames and put them in the metatags of the page. Well of course this will cause errors if the gedcom hasn't been imported yet. I thought that I had caught all of the possibilites for this error to occur in beta 5.
Even though you get this error you should still be able to continue configuring and importing the gedcom.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi
I have installed phpgedview and passed the first configuration screen where I chose to use MySQL
I created an administrator account
when I tried to upload a gedcom file, I got an error message saying that the database is missing the pgv_individuals table.
I have checked it using my MySQL client and indeed no such table exists.
The tables that were created are:
pgv_blocks
pgv_favorites
pgv_messages
pgv_news
pgv_users
What could be the problem?
Am I missing more tables?
The pgv_individuals, pgv_families, pgv_sources, pgv_places, and pgv_other tables will be created when you import the gedcom. If you are able to continue uploading then you can ignore this error message and continue to import.
You say that you get this message on uploadgedcom.php? Anything else included in that error message like line numbers that could help us in debugging the beta?
--John
this is the complete error:
ERROR:Table 'phpgedview.pgv_individuals' doesn't exist
SQL:SELECT SUBSTRING_INDEX(i_name, ',', 1) as surname, COUNT(*) FROM pgv_individuals WHERE i_file='bkentsm2.ged' GROUP BY SUBSTRING_INDEX(i_name, ',', 1)
Are you using the latest beta 5 release of version 3.0?
--John
yes I am
Have you tried to use PGV in Index mode yet?
I would suggest trying that and see what the result is then. This will isolate MySQL perms and configuration from the equation.
John
Index mode will work because this is a MySQL SQL error.
The reason for the error is that the program is trying to find the most common surnames and put them in the metatags of the page. Well of course this will cause errors if the gedcom hasn't been imported yet. I thought that I had caught all of the possibilites for this error to occur in beta 5.
Even though you get this error you should still be able to continue configuring and importing the gedcom.
--John