wyszukiwanie zaawansowane po temacie, błąd w tabie pomoc

[gregoriii]

Mam problem z wyszukiwarką zaawansowaną, tzn.: wyszukując po temacie ( zaznaczona opcja: "Przeszukuj tylko tytuły") znajduje mi wyniki jednak gdy przechodzę przez kolejne zakładki (fora, użytkownicy, pomoc itd) to na "pomocy" wywala mi błąd. Nie pisze że "Brak wyników dla 'fraza'" tylko mam "The service is unavailable."

 Date: Wed, 01 Sep 2010 09:44:42 +0000
Error: 8120 - [Microsoft][sql Server Native Client 10.0][sql Server]Column 'faq.title' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

IP Address: 192.168.152.3 - /index.php?app=core&module=search&do=search&andor_type=&sid=d43fd80e3b565a434148da4fabf9069e&content_title_only=1&search_term=sex&search_app=core
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MSSQL query error:
SELECT TOP 25 h.* FROM faq h  LEFT JOIN permission_index i ON ( i.perm_type='help' AND i.perm_type_id=1 )   WHERE h.title LIKE '%moje%' AND (i.perm_view LIKE '*' OR i.perm_view LIKE '%,2,%') GROUP BY h.id ORDER BY id desc
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| F:\WebSites\forum.mamazone.pl\ips_kernel\classDb.php                       | [db_driver_mssql].query                                                       | 1060              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\sources\classes\search\controller.php  | [search_engine_core].search                                                   | 495               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\applications\core\modules_public\search\search.php| [iPSSearch].search                                                            | 339               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\applications\core\modules_public\search\search.php| [public_core_search_search].searchResults                                     | 160               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\sources\base\ipsController.php         | [public_core_search_search].doExecute                                         | 296               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Błąd w zapytaniu. Proszę o podpowiedzi w rozwiązaniu tego problemu.

[gregoriii]

Mam problem z wyszukiwarką zaawansowaną, tzn.: wyszukując po temacie ( zaznaczona opcja: "Przeszukuj tylko tytuły") znajduje mi wyniki jednak gdy przechodzę przez kolejne zakładki (fora, użytkownicy, pomoc itd) to na "pomocy" wywala mi błąd. Nie pisze że "Brak wyników dla 'fraza'" tylko mam "The service is unavailable."

 Date: Wed, 01 Sep 2010 09:44:42 +0000
Error: 8120 - [Microsoft][sql Server Native Client 10.0][sql Server]Column 'faq.title' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

IP Address: 192.168.152.3 - /index.php?app=core&module=search&do=search&andor_type=&sid=d43fd80e3b565a434148da4fabf9069e&content_title_only=1&search_term=sex&search_app=core
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
MSSQL query error:
SELECT TOP 25 h.* FROM faq h  LEFT JOIN permission_index i ON ( i.perm_type='help' AND i.perm_type_id=1 )   WHERE h.title LIKE '%moje%' AND (i.perm_view LIKE '*' OR i.perm_view LIKE '%,2,%') GROUP BY h.id ORDER BY id desc
.--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------.
| File                                                                       | Function                                                                      | Line No.          |
|----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------|
| F:\WebSites\forum.mamazone.pl\ips_kernel\classDb.php                       | [db_driver_mssql].query                                                       | 1060              |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\sources\classes\search\controller.php  | [search_engine_core].search                                                   | 495               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\applications\core\modules_public\search\search.php| [iPSSearch].search                                                            | 339               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\applications\core\modules_public\search\search.php| [public_core_search_search].searchResults                                     | 160               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
| F:\WebSites\forum.mamazone.pl\admin\sources\base\ipsController.php         | [public_core_search_search].doExecute                                         | 296               |
'----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'

Błąd w zapytaniu. Proszę o podpowiedzi w rozwiązaniu tego problemu.

nieoczekiwanie znalezione rozwiązanie opisane w poście

zmiana w pliku: search.php ( lokalizacja: admin\applications\core\modules_public\search\)

/* Are we option to show titles only / search in titles only */
               /* IPSSearchRegistry::set('opt.searchTitleOnly', ( isset( $this->request['content_title_only'] ) && $this->request['content_title_only']  ) ? true : false ); */
               /* IPSSearchRegistry::set('display.onlyTitles' , ( ( $this->request['show_as_titles'] AND $this->settings['enable_show_as_titles'] ) OR ( IPSSearchRegistry::get('opt.searchTitleOnly') ) ) ? true : false ); */
                 IPSSearchRegistry::set('display.onlyTitles', TRUE );

Temat do zamknięcia

[DawPi]

Microsoft]

[/b] - nigdy się tym nie zajmowałem. 
Tylko ticket do IPS-u Cię ratuje lub zgłoszenie tego w trackerze, bo widać, że jest to błąd.