First of all, I now receive this error message when I try to find a place in PGV 4.2.3:
ERROR 8: Undefined index: 75
0 Error occurred on line 1842 of file functions_db.php in function find_place_list
1 called from line 618 of file find.php
What do I need to do to solve this?
Sadly I have also another issue with places;
I made a mistake when enter a new place.
Later I corrected this, but in the search the misspelled place is still there.
This is also for Lists, Place Hierarchy .. and VERY annoying!
Any advise would be welcome.
Cheers,
Matthijs
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Search your DB via a GUI, like phpMyAdmin, and see if you can locate anything remaining in the SQL that is misspelled. Then you can correct and export your GEDCOM and replace your old one. This will resolve any reference to the original error.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Matthijs:
I sometimes export (download) the database as a GEDCOM. Using an ordinary text editor, you can correct the mistake (if it's still in there), and then re-upload and re-import the corrected GEDCOM.
Be sure to tell PGV to replace the existing database contents. If you have media, you need to tell PGV to *not* keep media links. This is so because the GEDCOM you created with PGV already has the required media information in it. This option is for handling GEDCOMs that are created by programs like Family Tree Maker that don't support media information embedded in GEDCOMs.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I am not that keen to replace my GEDCOM, also because I have used linked media etc.
Furthermore, strangely I do have no misspells anymore. I did remove the cache from the index though.
However, I still got this strange error message, also in the logging;
admin - ERROR 8: Undefined index: 75; 0 Error occurred on line 1842 of file functions_db.php in function find_place_list1 called from line 618 of file find.php
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
First of all, I now receive this error message when I try to find a place in PGV 4.2.3:
What do I need to do to solve this?
Sadly I have also another issue with places;
I made a mistake when enter a new place.
Later I corrected this, but in the search the misspelled place is still there.
This is also for Lists, Place Hierarchy .. and VERY annoying!
Any advise would be welcome.
Cheers,
Matthijs
Search your DB via a GUI, like phpMyAdmin, and see if you can locate anything remaining in the SQL that is misspelled. Then you can correct and export your GEDCOM and replace your old one. This will resolve any reference to the original error.
Thanks…
I just checked the "pgv_places" table of the PGV database and all seems OK.
So where is it misspelled and why do I get this error?
Matthijs:
I sometimes export (download) the database as a GEDCOM. Using an ordinary text editor, you can correct the mistake (if it's still in there), and then re-upload and re-import the corrected GEDCOM.
Be sure to tell PGV to replace the existing database contents. If you have media, you need to tell PGV to *not* keep media links. This is so because the GEDCOM you created with PGV already has the required media information in it. This option is for handling GEDCOMs that are created by programs like Family Tree Maker that don't support media information embedded in GEDCOMs.
I am not that keen to replace my GEDCOM, also because I have used linked media etc.
Furthermore, strangely I do have no misspells anymore. I did remove the cache from the index though.
However, I still got this strange error message, also in the logging;
admin - ERROR 8: Undefined index: 75; 0 Error occurred on line 1842 of file functions_db.php in function find_place_list1 called from line 618 of file find.php