AW: [Cartoweb-users] search plugin result

Thu Jun 7 11:24:47 EDT 2007

Ok, I logged som variables from search.ini in the function getResult. There
I loop through the parameters ($parameter) and get 3. 

07.06.2007 17:02:31,250 [5608] WARN DbResultProvider::getResult -
sort_column->1->emri

07.06.2007 17:02:31,251 [5608] WARN DbResultProvider::getResult -
sort_direction->2->asc

07.06.2007 17:02:31,251 [5608] WARN DbResultProvider::getResult -
number->3-> 

Where is then the actual where clause??

Shoudn't it be there?

The initial $sql, where strings will be replaced is :

07.06.2007 17:02:31,250 [5608] WARN DbResultProvider::getResult - SELECT
DISTINCT fid, emri FROM streetname WHERE emri LIKE '%@emri@%' ORDER BY emri
asc

But in the ajax window all parameters are set???

Thank,

Volkmar

  _____  

Von: Oliver Christen [mailto:oliver.christen at camptocamp.com] 
Gesendet: Donnerstag, 7. Juni 2007 12:45
An: herbst at gc-i.de; cartoweb-users at lists.maptools.org
Betreff: Re: [Cartoweb-users] search plugin result

Hi

it seems the most probable cause is you do not have an input named 'emri' in
your template.

then the code fail to recover the value and cant replace correctly the
@emri@ in the sql string.

regards

Oliver

----- Original Message ----- 

From: Volkmar Herbst <mailto:herbst at gc-i.de>  

To: 'Oliver Christen' <mailto:oliver.christen at camptocamp.com>  ;
cartoweb-users at lists.maptools.org 

Sent: Thursday, June 07, 2007 11:28 AM

Subject: AW: [Cartoweb-users] search plugin result

Hi Oliver,

this ist he following (if I replace in the pgsql database streetname with
streetnamel):

Message : Failed executing search SQL query Message: DB Error: no such table
Userinfo: SELECT DISTINCT fid, emri FROM streetname WHERE emri LIKE
'%@emri@%' <mailto:'%25 at emri@%25'>  ORDER BY emri asc [nativecode=ERROR:
relation "streetname" does not exist]

Emir is the column name but ' <mailto:'%25 at emri@%25'> %@emri@%' should be
the search string??

As I wrote, if I add a street with a streetname @emri@ it works.

Thanks

Volkmar

  _____  

Von: Oliver Christen [mailto:oliver.christen at camptocamp.com] 
Gesendet: Donnerstag, 7. Juni 2007 10:50
An: herbst at gc-i.de; cartoweb-users at lists.maptools.org
Betreff: Re: [Cartoweb-users] search plugin result

Hi

The sql is generated in search/common/Search.php

Could you show me what the actual generated sql look like ?

regards

Oliver

----- Original Message ----- 

From: Volkmar Herbst <mailto:herbst at gc-i.de>  

To: cartoweb-users at lists.maptools.org 

Sent: Thursday, June 07, 2007 8:59 AM

Subject: [Cartoweb-users] search plugin result

Dear all, I encounter a strange problem using the search plug-in. 

I set it up like it is described in the new example and I can start my site
without error but there was no result of the search. I tried to log the
event in order to find out which SQl was sent to the pgsql database but the
cartoweb.log does not show anything regarding this. 

First question: is there another log somewhere showing the sql??). 

I changed the table name in the database to provoke an error and got finally
then sql string sent and found out, that the where clause did not send my
search string but the column name with @ like: @<column>@ (@emri@) . This
could not return anything of course. I inserted the column name "@<column>@"
in the search field in database and got a hit!

What could this be and where can I find the Script which does the search and
builds the sql????

Further the click on the entry does not trigger the re-centre action but if
I put manually the ID in the textbox it works. Wonder why.

Any hints? 

Here the ini file:

dbType = pgsql

dsn = pgsql://volkmar:xxxx@localhost:5432/database

encodingContext = searchDb 

config.streetname.provider.type = fulltextTable

config.streetname.provider.table = streetname

config.streetname.provider.id = fid

config.streetname.provider.columns = emri

config.streetname.provider.fulltextColumns = emri

config.streetname.provider.sortColumn = emri

config.streetname.provider.sortDirection = asc

config.streetname.provider.sortPriorities = emri

config.streetname.provider.labels =  emri

config.streetname.formatter.type = smarty

config.streetname.formatter.template = search_results

the request:

  * array (  'ajaxActionRequest' => 'Search.DoIt',  'posted' => '1',
'js_folder_idx' => '3',  'selection_type' => '',  'selection_coords' => '',
'features' => '',  'project' => 'TiranaP',  'collapse_keymap' => '0',
'fake_reset' => '',  'fake_query' => '',  'outline_label_text' => 'Your
label',  'tool' => 'zoomin',  'recenter_doit' => '0',  'openNodes' => '',
'layers_background' => 'qbird',  'outline_mask' => 'no',  'shortcut_doit' =>
'0',  'recenter_x' => '',  'recenter_y' => '',  'id_recenter_ids' => '',
'search_name' => 'Chestnut Street',  'search_config' => 'streetname',
'search_sort_column' => 'emri',  'search_sort_direction' => 'asc',
'search_number' => '',  'recenter_scale' => '0',  'mapsize' => '1',
'shortcut_id' => '-1',  'id_recenter_layer' => 'parcel',  'LangCookie' =>
'en',  'TestCookie' => 'OK',  'PHPSESSID' =>
'813d2505b2785a868d2ad5fdef4410b6',)

  _____  

_______________________________________________
Cartoweb-users mailing list
Cartoweb-users at lists.maptools.org
http://lists.maptools.org/mailman/listinfo/cartoweb-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070607/b842778c/attachment-0001.html