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' ; [email protected] 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 '[EMAIL PROTECTED]@%' ORDER BY emri asc [nativecode=ERROR: relation "streetname" does not exist] Emir is the column name but '[EMAIL PROTECTED]@%' 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:[EMAIL PROTECTED] Gesendet: Donnerstag, 7. Juni 2007 10:50 An: [EMAIL PROTECTED]; [email protected] 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: [email protected] 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:[EMAIL PROTECTED]: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 [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
_______________________________________________ Cartoweb-users mailing list [email protected] http://lists.maptools.org/mailman/listinfo/cartoweb-users
