if you set the debug level to 3 you must have some logging in the file 'pm_debug.log', both for the suggest requests and the final query that are sent to the database (and the returned results I guess). If no debug logging then there should be an error, either PHP or JavaScript.
armin On 22/07/2011 14:44, pelin wrote: > Hello Armin and Pedro: > I have a similar situation...or not!. > > In my config_default.xml I have: > *************** > <searchlist version="1.0"> > <dataroot>$</dataroot> > <searchitem name="caminoschaco-sep" description="Caminos"> > <layer type="postgis" name="caminoschaco-sep"> > <field type="s" name="tipo" description="TipoCamino" > wildcard="2"> > <definition type="suggest" connectiontype="db" sort="asc" > minlength="1" startleft="1"> > <dsn encoding="UTF-8">pgsql://mapas:mapas@postgisServer > /DBmapas</dsn> > <sql>SELECT DISTINCT tipo FROM red_vial WHERE tipo ~* > '^[search]' ORDER BY tipo</sql> > </definition> > </field> > </layer> > </searchitem> > ........... > ............... > ............... > .............. > *************** > > But I don't have suggestions in search, no info in php or pmapper logs, only > database logs: > > ******************* > 2011-07-22 09:28:57 ART [2749]: [1-1] LOG: statement: SELECT gid, > xmin(box3d(the_geom)), > ymin(box3d(the_geom)), > xmax(box3d(the_geom)), > ymax(box3d(the_geom)), > > tipo,nombre,jurisdicci,clase,transitabi,nombreruta,refer_mapa,jurisdic,nombre_2 > FROM red_vial as red_vial > WHERE tipo = 'HUELLA' > LIMIT 301 > 2011-07-22 09:28:57 ART [2749]: [2-1] LOG: duration: 23.307 ms > 2011-07-22 09:28:58 ART [4392]: [1657-1] LOG: statement: select * from > red_vial as red_vial where false limit 0 > ............... > ................ > ********************* > of course I must write the full text for query > > thanks in advance! > > > > > > ------------------------------------------------------------------------------ > 10 Tips for Better Web Security > Learn 10 ways to better secure your business today. Topics covered include: > Web security, SSL, hacker attacks& Denial of Service (DoS), private keys, > security Microsoft Exchange, secure Instant Messaging, and much more. > http://www.accelacomm.com/jaw/sfnl/114/51426210/ > > > > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------------------------------------------------------ 10 Tips for Better Web Security Learn 10 ways to better secure your business today. Topics covered include: Web security, SSL, hacker attacks & Denial of Service (DoS), private keys, security Microsoft Exchange, secure Instant Messaging, and much more. http://www.accelacomm.com/jaw/sfnl/114/51426210/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
