Hi, Could you send the layer definition in the mapfile please (layer named "geopnh")?
Thomas Le 18/09/2013 14:02, Pedro Venâncio a écrit : > > Hi all, > > Some new information about the error that I reported yesterday. > > A search to a layer on the same database, that works well, shows the > following result on pm_debug.log: > > [18-Sep-2013 13:15:47] P.MAPPER debug info > XML->//definition > SimpleXMLElement Object > ( > [@attributes] => Array > ( > [type] => suggest > [connectiontype] => db > [minlength] => 1 > [startleft] => 0 > [sort] => asc > ) > > [comment] => SimpleXMLElement Object > ( > ) > > [dsn] => pgsql://xxx:xxxxxxx@localhost/pinhel_20 > [sql] => SELECT DISTINCT rua FROM data.ruas WHERE rua ~* '[search]' > ORDER BY rua > ) > > [18-Sep-2013 13:15:50] P.MAPPER debug info > request > Array > ( > [searchitem] => n_rua2 > [fldname] => rua > [q] => norto > [limit] => 0 > [timestamp] => 1379502950458 > ) > > [18-Sep-2013 13:15:50] P.MAPPER debug info > Parameters for attribute search file: suggest.php function: __construct > Array > ( > [type] => db > [sort] => asc > [minlength] => 1 > [regexleft] => > [startleft] => 0 > [dependfld] => > [dsn] => pgsql://xxx:xxxxxxx@localhost/pinhel_20 > [encoding] => UTF-8 > [sql] => SELECT DISTINCT rua FROM data.ruas WHERE rua ~* '[search]' > ORDER BY rua > [dependfldval] => > ) > > [18-Sep-2013 13:15:50] P.MAPPER debug info > SELECT DISTINCT rua FROM data.ruas WHERE rua ~* 'norto' ORDER BY rua > [18-Sep-2013 13:15:51] P.MAPPER debug info > Searcharray in search.php->getSearchParameters() > Array > ( > [rua] => Rua Norton de Matos > [mode] => search > ) > > [18-Sep-2013 13:15:51] P.MAPPER debug info > Parameters for searchArray > file: query.php->q_execAttributeQuery > > Array > ( > [rua] => Rua Norton de Matos > [mode] => search > ) > > [18-Sep-2013 13:15:51] P.MAPPER debug info > Parameters for searchParams > file: query.php->q_execAttributeQuery > Array > ( > [layerName] => ruas > [layerType] => postgis > [firstFld] => rua > [qStr] => rua ILIKE '%Rua Norton de Matos%' > ) > > [18-Sep-2013 13:15:51] P.MAPPER debug info > P.MAPPER-DEBUG: squery.php/dumpPGQueryResults() - SQL Cmd: > SELECT n_rua, > ST_xmin(box3d(the_geom)), > ST_ymin(box3d(the_geom)), > ST_xmax(box3d(the_geom)), > ST_ymax(box3d(the_geom)), > n_rua,rua,comprimento > FROM ruas > WHERE rua ILIKE '%Rua Norton de Matos%' > LIMIT 301 > > > > > > > > > The layer that gives the Internal Server Error shows, on pm_debug.log: > > [18-Sep-2013 13:15:18] P.MAPPER debug info > XML->//definition > SimpleXMLElement Object > ( > [@attributes] => Array > ( > [type] => suggest > [connectiontype] => db > [minlength] => 1 > [startleft] => 0 > [sort] => asc > ) > > [comment] => SimpleXMLElement Object > ( > ) > > [dsn] => pgsql://xxx:xxxxxxx@localhost/cartografia_oficial > [sql] => SELECT DISTINCT arteria FROM rede_viaria.geopnh WHERE arteria > ~* '[search]' ORDER BY arteria > ) > > [18-Sep-2013 13:15:20] P.MAPPER debug info > request > Array > ( > [searchitem] => n_rede_viaria > [fldname] => arteria > [q] => no > [limit] => 0 > [timestamp] => 1379502920339 > ) > > [18-Sep-2013 13:15:20] P.MAPPER debug info > Parameters for attribute search file: suggest.php function: __construct > Array > ( > [type] => db > [sort] => asc > [minlength] => 1 > [regexleft] => > [startleft] => 0 > [dependfld] => > [dsn] => pgsql://xxx:xxxxxxx@localhost/cartografia_oficial > [encoding] => UTF-8 > [sql] => SELECT DISTINCT arteria FROM rede_viaria.geopnh WHERE arteria > ~* '[search]' ORDER BY arteria > [dependfldval] => > ) > > [18-Sep-2013 13:15:20] P.MAPPER debug info > SELECT DISTINCT arteria FROM rede_viaria.geopnh WHERE arteria ~* 'no' ORDER > BY arteria > [18-Sep-2013 13:15:21] P.MAPPER debug info > request > Array > ( > [searchitem] => n_rede_viaria > [fldname] => arteria > [q] => norto > [limit] => 0 > [timestamp] => 1379502921111 > ) > > [18-Sep-2013 13:15:21] P.MAPPER debug info > Parameters for attribute search file: suggest.php function: __construct > Array > ( > [type] => db > [sort] => asc > [minlength] => 1 > [regexleft] => > [startleft] => 0 > [dependfld] => > [dsn] => pgsql://xxx:xxxxxxx@localhost/cartografia_oficial > [encoding] => UTF-8 > [sql] => SELECT DISTINCT arteria FROM rede_viaria.geopnh WHERE arteria > ~* '[search]' ORDER BY arteria > [dependfldval] => > ) > > [18-Sep-2013 13:15:21] P.MAPPER debug info > SELECT DISTINCT arteria FROM rede_viaria.geopnh WHERE arteria ~* 'norto' > ORDER BY arteria > [18-Sep-2013 13:15:22] P.MAPPER debug info > Searcharray in search.php->getSearchParameters() > Array > ( > [arteria] => R NORTON DE MATOS > [mode] => search > ) > > > > > and on php_errors.log: > > [18-Sep-2013 11:15:22 UTC] PHP Warning: mapObj::getLayerByName(): > getLayerByName failed for : geopnh > , in /var/pmapper/incphp/query/search.php on line 116 > [18-Sep-2013 11:15:22 UTC] PHP Fatal error: Call to a member function > getMetaData() on a non-object in /var/pmapper/incphp/query/search.php on line > 213 > > > > > > I have already tried the solutions proposed in this thread > http://sourceforge.net/mailarchive/forum.php?thread_name=18419253.post%40talk.nabble.com&forum_name=pmapper-users > > but unsuccessfully. > > Anyone have suggestions? > > > Thank you very much! > > Best regards, > Pedro > > > > > > > ____________________________________ > > ----- Original Message ----- > From: Pedro Venâncio > To: pmapper-users > Sent: Tuesday, September 17, 2013 6:55 PM > Subject: Internal Server Error with postgis search > > > > Hi, > > I'm using (yet) pmapper 4.2 and I'm having difficulty creating a postgis > search. Despite being using pmapper 4.2, I've done this update > http://svn.pmapper.net/trac/changeset/1272 and I have other searches working > properly. > > The search that does not work is this one: > > <searchitem name="n_rede_viaria" description="Rede Viaria"> > <layer type="postgis" name="geopnh"> > <field type="s" name="arteria" description="Nome da Arteria" > wildcard="0"> > <definition type="suggest" connectiontype="db" > minlength="1" startleft="0" sort="asc"> > <dsn > encoding="UTF-8">pgsql://xxxxxx:xxxxxxxxxx@localhost/cartografia_oficial</dsn> > <sql>SELECT DISTINCT arteria FROM rede_viaria.geopnh > WHERE arteria ~* '[search]' ORDER BY arteria</sql> > </definition> > </field> > </layer> > </searchitem> > > > > With this, the suggestions appears as I write the name, but when I click on > one of the suggestions I get (on firebug) an Internal Server Error - > pm_cjs.js (linha 38) > > POST http://localhost/incphp/xajax/x_info.php 500 Internal Server Error > 6ms > > and on Send (Post): &findlist=0&arteria=R NORTON DE > MATOS&=Consultar&searchitem=n_rede_viaria&mode=search > > > May it be a result of the content of "arteria" field be in uppercase? How can > I get around this? > > > Thank you very much! > > Best regards, > > Pedro > > ------------------------------------------------------------------------------ > LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! > 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint > 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes > Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. > http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > -- Thomas RAFFIN Chef de Projet Internet traf...@sirap.fr <mailto:traf...@sirap.fr> Sirap <http://sirap.fr> Tel : 04 75 72 84 10 Fax : 04 75 70 07 98 Rue Paul Louis Héroult - BP 253 26106 Romans cedex ------------------------------------------------------------------------------ LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99! 1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint 2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/20/13. http://pubads.g.doubleclick.net/gampad/clk?id=58041151&iu=/4140/ostg.clktrk _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
