[Cartoweb-users] search plugin result

[Oliver Christen]

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 
  To: 'Oliver Christen' ; 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@%' ORDER BY emri asc [nativecode=ERROR:  relation "streetname" does not exist] 

  Emir is the column name but '%@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 

    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/c3a97361/attachment.html