#1409 RA error if places have more than 5 levels

[Hansjörg Schwarz]

SVN 1161.
I call the RA from a persons view.
If that person has places with more than 5 levels, e.g. "Donsbach, Dillenburg, Lahn-Dill-Kreis, Gießen, Hessen, DEU" then the RA issues an error message and doesn't come up.

This is the error message i get:
"
Research Assistant
ERROR:-19 DB Error: no such field
SQL:Select * from pgv_factlookup WHERE StartDate <= 19040502 AND EndDate >= 18400928 AND PL_LV1 LIKE '%DEU%' AND PL_LV2 LIKE '%Hessen%' AND PL_LV3 LIKE '%Gießen%' AND PL_LV4 LIKE '%Lahn-Dill-Kreis%' AND PL_LV5 LIKE '%Dillenburg%' AND PL_LV6 LIKE '%Donsbach%'; [nativecode=1054 ** Unknown column 'PL_LV6' in 'where clause']

Fatal error: Call to undefined function: fetchrow() in /[...]/modules/research_assistant/ra_functions.php on line 161
"

Since the googlemap module allows up to 9 levels, the RA behaviour doesn't seem to be congruent within phpgedview.

With kind regards
Hansjörg

[Larry Meaney]

Logged In: YES
user_id=45016
Originator: NO

Oh, I was just about to report this :) The problem still exists in 4.1b6

To resolve for my installation, I manually modified the pgv_factlookup table to add these columns:
PL_LV6, PL_LV7, PL_LV8, PL_LV9, PL_LV10