#2287 [4017] ordinary search

[Warren Meads]

I performed an ordinary search from the header search box. The following url was generated

http://ft.meads.co.nz//search.php?action=general&topsearch=yes&query=Louise+Fox&search=%3E

and the following error message resulted

ERROR 8: Undefined index: 1
0 Error occurred on line 378 of file functions_privacy.php in function displayDetailsById
1 called from line 697 of file functions_privacy.php in function showLivingNameById
2 called from line 507 of file search_ctrl.php in function GeneralSearch
3 called from line 305 of file search_ctrl.php in function init
4 called from line 33 of file search.php

I searched using an admin log in so there should not have been any privacy issues.

I also think that this is a unique find so as normal should have gone straight to the INDV page.

[Greg Roach]

I visited your site. You have 2 public and 3 private gedcoms.

To reproduce the error, I need to select one of the public gedcoms, then search for a name which occurs in the other public gedcom.

Can you try something for me to help identify the problem. At the top of search.php, immediately after the line:
require './config.php';
can you add the line
@import_request_variables('cgp');

Does this fix the problem?

[Warren Meads]

Yes it does fix the problem and gives one result on the search page which in the past would have gone straight to the indv page

The name Louise Fox only appears in Meadsmain.ged (Meads family)

[Warren Meads]

I have done what you suggested below and that is search (without logging in) for a name that is in one gedcom but search from the other that does not have the name. The temp fix you already gave is still current.

Here is the resulting error code

ERROR 8: Undefined index: 1
0 Error occurred on line 378 of file functions_privacy.php in function displayDetailsById
1 called from line 697 of file functions_privacy.php in function showLivingNameById
2 called from line 507 of file search_ctrl.php in function GeneralSearch
3 called from line 305 of file search_ctrl.php in function init
4 called from line 33 of file search.php
ERROR:-2 DB Error: syntax error
SQL:SELECT i_gedcom, i_isdead FROM pgv_individuals WHERE i_id='I4773' AND i_file= [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]

ERROR 8: Undefined index: 1
0 Error occurred on line 580 of file functions_privacy.php in function displayDetailsById
1 called from line 697 of file functions_privacy.php in function showLivingNameById
2 called from line 507 of file search_ctrl.php in function GeneralSearch
3 called from line 305 of file search_ctrl.php in function init
4 called from line 33 of file search.php

ERROR 8: Undefined index: 1
0 Error occurred on line 378 of file functions_privacy.php in function displayDetailsById
1 called from line 507 of file search_ctrl.php in function GeneralSearch
2 called from line 305 of file search_ctrl.php in function init
3 called from line 33 of file search.php

[Greg Roach]

If you're still getting the error with the import_request_variables() in place, then it suggests that this is not the cause (damn - I was looking for an easy answer!).

OK - take the line out.

I'll have another go at trying to reproduce it on my dev machine.

[Warren Meads]

Greg. It was ok when I searched using my admin log in.

[Anonymous]

I have the same problem. The error report also includes a comment about database syntax error:

ERROR 8: Undefined index: 1
0 Error occurred on line 378 of file functions_privacy.php in function displayDetailsById
1 called from line 697 of file functions_privacy.php in function showLivingNameById
2 called from line 507 of file search_ctrl.php in function GeneralSearch
3 called from line 305 of file search_ctrl.php in function init
4 called from line 33 of file search.php
ERROR:-2 DB Error: syntax error
SQL:SELECT i_gedcom, i_isdead FROM pgv_individuals WHERE i_id='I12865' AND i_file= [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]

[Anonymous]

I have the same problem. The error report also includes a comment about database syntax error:

ERROR 8: Undefined index: 1
0 Error occurred on line 378 of file functions_privacy.php in function displayDetailsById
1 called from line 697 of file functions_privacy.php in function showLivingNameById
2 called from line 507 of file search_ctrl.php in function GeneralSearch
3 called from line 305 of file search_ctrl.php in function init
4 called from line 33 of file search.php
ERROR:-2 DB Error: syntax error
SQL:SELECT i_gedcom, i_isdead FROM pgv_individuals WHERE i_id='I12865' AND i_file= [nativecode=1064 ** You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1]

[Greg Roach]

Fixed in SVN

[SourceForge Robot]

This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 100 days (the time period specified by
the administrator of this Tracker).