Re: [pmapper-users] Problems with search xml on postgis
you need to define 2 DB fields used for the OPTIONS, one for the key
used for the search and one for the displayed value, they can be the
same if you do not want to use an ID field, like
... SELECT DISTINCT nombre, nombre FROM ...
On 07/11/2011 20:14, salo wrote:
>
> Hello everyone,
>
> I have defined the following search options:
>
>
>
> wildcard="2">
>
> encoding="UTF-8">pgsql://postgres:postgres@localhost/pizano
> SELECT DISTINCT nombre FROM municipios WHERE nombre IS NOT
> NULL
> ORDER BYnombre
>
>
>
>
>
>
> When I run the search on pmapper the listbox appears void, such as you can
> see in the image attachment
> http://old.nabble.com/file/p32788741/error_search_option_postgis.jpg
> error_search_option_postgis.jpg , and when I saw the pm_debug.log file I
> found the following:
>
> [07-Nov-2011 19:48:33] P.MAPPER debug info
> XML->//definition
> SimpleXMLElement Object
> (
> [@attributes] => Array
> (
> [type] => options
> [connectiontype] => db
> [sort] => asc
> )
>
> [dsn] => pgsql://postgres:postgres@localhost/pizano
> [sql] => SELECT DISTINCT nombre FROM municipios WHERE nombre IS NOT NULL
> ORDER BY nombre
> )
>
> [07-Nov-2011 19:48:33] P.MAPPER debug info
> search.php->getOptionsFromDb()
> SELECT DISTINCT nombre FROM municipios WHERE nombre IS NOT NULL ORDER BY
> nombre
>
> [07-Nov-2011 19:48:33] P.MAPPER debug info
> search.php->getOptionsFromDb()->json
> { "?":"", "ABEJORRAL":"", "ÁBREGO":"", "ABRIAQUÍ":"", "ACACÍAS":"",
> "ACANDÍ":"", "ACEVEDO":"", "ACHÍ":"", "AGRADO":"", "AGUA DE DIOS":"",
> "AGUACHICA":"", "AGUADA":"", "AGUADAS":"", "AGUAZUL":"", "AGUSTÍN
> CODAZZI":"", "AIPE":"", "ALBÁN":""}
>
> Please somebody help me!
>
> Kind Regards.
>
>
--
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Problems with search xml on postgis
Hello everyone,
I have defined the following search options:
pgsql://postgres:postgres@localhost/pizano
SELECT DISTINCT nombre FROM municipios WHERE nombre IS
NOT NULL
ORDER BYnombre
When I run the search on pmapper the listbox appears void, such as you can
see in the image attachment
http://old.nabble.com/file/p32788741/error_search_option_postgis.jpg
error_search_option_postgis.jpg , and when I saw the pm_debug.log file I
found the following:
[07-Nov-2011 19:48:33] P.MAPPER debug info
XML->//definition
SimpleXMLElement Object
(
[@attributes] => Array
(
[type] => options
[connectiontype] => db
[sort] => asc
)
[dsn] => pgsql://postgres:postgres@localhost/pizano
[sql] => SELECT DISTINCT nombre FROM municipios WHERE nombre IS NOT NULL
ORDER BY nombre
)
[07-Nov-2011 19:48:33] P.MAPPER debug info
search.php->getOptionsFromDb()
SELECT DISTINCT nombre FROM municipios WHERE nombre IS NOT NULL ORDER BY
nombre
[07-Nov-2011 19:48:33] P.MAPPER debug info
search.php->getOptionsFromDb()->json
{ "?":"", "ABEJORRAL":"", "ÁBREGO":"", "ABRIAQUÍ":"", "ACACÍAS":"",
"ACANDÍ":"", "ACEVEDO":"", "ACHÍ":"", "AGRADO":"", "AGUA DE DIOS":"",
"AGUACHICA":"", "AGUADA":"", "AGUADAS":"", "AGUAZUL":"", "AGUSTÍN
CODAZZI":"", "AIPE":"", "ALBÁN":""}
Please somebody help me!
Kind Regards.
--
View this message in context:
http://old.nabble.com/Problems-with-search-xml-on-postgis-tp32788741p32788741.html
Sent from the pmapper users mailing list archive at Nabble.com.
--
RSA(R) Conference 2012
Save $700 by Nov 18
Register now
http://p.sf.net/sfu/rsa-sfdev2dev1
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
[pmapper-users] Problems when migrating - Probelamas al migrar
I have installed on a virtual machine as follows: APACHE 2.2.12 MapServer 5.6.5 PHP 5.2.10-2UBUNTU6.10 PMAPPER 4.0 In another PC migrate to: APACHE 2.2.14 MapServer 5.6.1 PHP 5.3.2-1UBUNTU4.10 PMAPPER 4.0 The point is that the virtual machine is working properly and the new installation does not display anything and they do not give me any error in the logs or the pm_debug, or the php.log nor in the ms_error. Since I have nothing left to go, sometimes randomly and I get an error that says: [07-Nov-2011 10:22:37] P. MAPPER debug info P.MAPPER-ERROR: Layer / Group''not existing. Check '/ config / config.ini' file definition for section 'map.defGroups'. But when I check the config_default.xml no errors exist in the file. I spent a screenshot to see how I have the framework. Thank you, greetings. Tengo instalado en una maquina virtual lo siguiente: APACHE 2.2.12 MAPSERVER 5.6.5 PHP 5.2.10-2UBUNTU6.10 PMAPPER 4.0 En otra PC migre a: APACHE 2.2.14 MAPSERVER 5.6.1 PHP 5.3.2-1UBUNTU4.10 PMAPPER 4.0 La cuestión es que en la virtual machine funciona correctamente y en la nueva instalación no se despliega nada y además no me da ningún error en los logs ni en el pm_debug, ni en el php.log y tampoco en el ms_error. Ya no me queda nada por recorrer, en ocasiones y de forma aleatoria me aparece un error que dice: [07-Nov-2011 10:22:37] P.MAPPER debug info P.MAPPER-ERROR: Layer/Group '' not existing. Check '/config/config.ini' file definition for section 'map.defGroups'. Pero cuando reviso el config_default.xml no existen errores en ese archivo. Les paso un screenshot para que vean como me queda el framework. Gracias, saludos. -- Eduardo -- RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 ___ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
