[ic] problems with search engine via db

ic at 3edge.com ic at 3edge.com
Fri Sep 8 11:00:11 EDT 2006


Marko Kuzio writes: 

> hi, 
> 
> i have a problem with the search engine, which i use with an postgres db. 
> 
> in the catalog.cfg i have defined the follow settings: 
> 
> Database    userdb  userdb.pgsql    TAB
> Database    transactions    transactions.pgsql  TAB
> Database    products      artikel.txt   TAB
> Database    gbd_artikel  artikel.pgsql  TAB
> Replace ProductFiles
> ProductFiles    gbd_artikel 
> 
> i think, this is the correct default setting, to use the gbd_artikel
> postgres db-table as default search table.
 

the TAB's behind the .pgsql tables don't seem correct to me, should be more 
likely something like: 

Database gbd_artikel artikel.pgsql __SQLDSN__ 

where __SQLDSN__ is set in your variables.txt to something useful to set up 
the database connection. 

 


> 
> my catalog pages contains the follow search form: 
> 
> <form action="[area search]" method="POST">
>    <input type="hidden" name="mv_search_field" value="bezeichnung">
>    <input type="text" size="30" name="mv_searchspec">
>    <input type="submit" value="Search">
> </form> 
> 
> and the search (search.html) contains  the follow test code: 
> 
> [search-region prefix=my]
>  [search-list]
>  SKU:   [my-artikel_nr]
>  Title: [my-data gbd_artikel bezeichnung]
>   [/search-list]
>  [/search-region] 
> 
> when i submit the form and the search page is calling, the follow error
> is visible in the browser: 
> 
> >> Internal Server Error!
>     The server encountered an internal error or misconfiguration and was 
> unable to complete your request. << 
> 
> hm, i check the apache error log and find:
> "Premature end of script headers: /homex/mak/ic/cgi-bin/ic" 
> 
> the ic error log is empty. 
> 
> i configure with the manual:
> http://www.interchange.rtfm.info/icdocs/config/ProductFiles.html
> http://www.interchange.rtfm.info/icdocs/tags/search-region.html 
> 
> hm ...... 
> 
> thx+greets 
> 
>  
> 
>  
> 
> --  
> 
> Marko Kuzio
> System Development
> Durchwahl +49 (0)89 17860-357
> --
> PEPPERMIND
> Digital Business Design
> Hirschgartenallee 25 | D-80639 M?
> Telefon +49 (0)89 1730130 | Fax +49 (0)89 17860-399
> kontakt at peppermind.de | www.peppermind.de  
> 
>  
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
 



More information about the interchange-users mailing list