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 '[EMAIL PROTECTED]@%' ORDER BY emri asc But in the ajax window all parameters are set??? Thank, Volkmar _____ Von: Oliver Christen [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 7. Juni 2007 12:45 An: [EMAIL PROTECTED]; [email protected] 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:[EMAIL PROTECTED]> To: 'Oliver Christen' <mailto:[EMAIL PROTECTED]> ; [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]@%' <mailto:'[EMAIL PROTECTED]@%25'> ORDER BY emri asc [nativecode=ERROR: relation "streetname" does not exist] Emir is the column name but ' <mailto:'[EMAIL PROTECTED]@%25'> [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 <mailto:[EMAIL PROTECTED]> 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
