Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Development, Plugins and Globals :

searchlogger plugin search results problem

Apr 10, 2001, 8:28 AM
mgeyman
User (294 posts)
Apr 10, 2001, 8:28 AM
Post #1 of 5
Views: 3173
Shortcut
Quote Reply
searchlogger plugin search results problem
I'm getting this (partial) along with my search results everytime a perform a search. How can this be corrected?
(see below)

Thanks.

Mark
OhioBiz


1: INSERT INTO links2SearchLog (Last_Hit,Term,Results,HitCount) VALUES (NOW(),'solon','42','1')

GT::SQL::Table::do_query called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Table.pm line 232 with arguments (GT::SQL::Table=HASH(0x84cc3f8), INSERT INTO links2SearchLog (Last_Hit,Term,Results,HitCount) VALUES (NOW(),'solon','42','1')).GT::SQL::Table::insert called at /home2/www/ohiobiz/linkssql2/admin/Plugins/SearchLogger.pm line 106 with arguments (GT::SQL::Table=HASH(0x84cc3f8), HASH(0x85770fc)).Plugins::SearchLogger::log_query called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 109 with arguments (HASH(0x8556f4c)).(eval) called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 109 with arguments (HASH(0x8556f4c)).GT::Plugins::dispatch called at search.cgi line 66 with arguments (GT::Plugins, /home2/www/ohiobiz/linkssql2/admin/Plugins, search_results, CODE(0x8355f44), HASH(0x80b6d28)).main::search called at search.cgi line 48 with no arguments.main::main called at search.cgi line 23 with no arguments.

2: SELECT COUNT(*) FROM links2SearchLog WHERE Term = 'solon'

GT::SQL::Table::do_query called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Table.pm line 602 with arguments (GT::SQL::Table=HASH(0x84cc3f8), SELECT COUNT(*) FROM links2SearchLog WHERE Term = 'solon' ).GT::SQL::Table::select called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Base.pm line 180 with arguments (GT::SQL::Table=HASH(0x84cc3f8), HASH(0x8578048), ARRAY(0x8578f68)).GT::SQL::Base::count called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Table.pm line 1543 with arguments (GT::SQL::Table=HASH(0x84cc3f8), HASH(0x8578048)).GT::SQL::Table::_check_insert called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Table.pm line 225 with arguments (GT::SQL::Table=HASH(0x84cc3f8), HASH(0x812dfe0)).GT::SQL::Table::insert called at /home2/www/ohiobiz/linkssql2/admin/Plugins/SearchLogger.pm line 106 with arguments (GT::SQL::Table=HASH(0x84cc3f8), HASH(0x85770fc)).Plugins::SearchLogger::log_query called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 109 with arguments (HASH(0x8556f4c)).(eval) called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 109 with arguments (HASH(0x8556f4c)).GT::Plugins::dispatch called at search.cgi line 66 with arguments (GT::Plugins, /home2/www/ohiobiz/linkssql2/admin/Plugins, search_results, CODE(0x8355f44), HASH(0x80b6d28)).main::search called at search.cgi line 48 with no arguments.main::main called at search.cgi line 23 with no arguments.

3: SELECT * FROM links2SearchLog WHERE ( Term = 'solon' )

GT::SQL::Table::do_query called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Table.pm line 602 with arguments (GT::SQL::Table=HASH(0x84cc3f8), SELECT * FROM links2SearchLog WHERE ( Term = 'solon' ) ).GT::SQL::Table::select called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Table.pm line 658 with arguments (GT::SQL::Table=HASH(0x84cc3f8), GT::SQL::Condition=HASH(0x8577f7c), ARRAY(0x8577084)).GT::SQL::Table::get called at /home2/www/ohiobiz/linkssql2/admin/Plugins/SearchLogger.pm line 105 with arguments (GT::SQL::Table=HASH(0x84cc3f8), solon).Plugins::SearchLogger::log_query called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 109 with arguments (HASH(0x8556f4c)).(eval) called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 109 with arguments (HASH(0x8556f4c)).GT::Plugins::dispatch called at search.cgi line 66 with arguments (GT::Plugins, /home2/www/ohiobiz/linkssql2/admin/Plugins, search_results, CODE(0x8355f44), HASH(0x80b6d28)).main::search called at search.cgi line 48 with no arguments.main::main called at search.cgi line 23 with no arguments.

4: SELECT links2Category.ID, links2Category.Full_Name
FROM links2CatLinks, links2Category
WHERE links2CatLinks.CategoryID = links2Category.ID
AND (links2CatLinks.LinkID = '4635')

GT::SQL::Relation::select called at /home2/www/ohiobiz/linkssql2/admin/Links/Link.pm line 332 with arguments (GT::SQL::Relation=HASH(0x84c3344), HASH(0x84c3488), ARRAY(0x8561324)).Links::Link::get_categories called at search.cgi line 151 with arguments (Links::Link=HASH(0x83f5338), 4635).main::query called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 78 with arguments (HASH(0x80b6d28)).GT::Plugins::dispatch called at search.cgi line 66 with arguments (GT::Plugins, /home2/www/ohiobiz/linkssql2/admin/Plugins, search_results, CODE(0x8355f44), HASH(0x80b6d28)).main::search called at search.cgi line 48 with no arguments.main::main called at search.cgi line 23 with no arguments.

5: SELECT *
FROM links2Links
WHERE
ID = 4635

GT::SQL::Search::STH::fetchrow_sth called at /home2/www/ohiobiz/linkssql2/admin/GT/SQL/Search.pm line 1354 with arguments (GT::SQL::Search::STH=HASH(0x84c2118)).GT::SQL::Search::STH::fetchrow_hashref called at search.cgi line 149 with arguments (GT::SQL::Search::STH=HASH(0x84c2118)).main::query called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 78 with arguments (HASH(0x80b6d28)).GT::Plugins::dispatch called at search.cgi line 66 with arguments (GT::Plugins, /home2/www/ohiobiz/linkssql2/admin/Plugins, search_results, CODE(0x8355f44), HASH(0x80b6d28)).main::search called at search.cgi line 48 with no arguments.main::main called at search.cgi line 23 with no arguments.

6: SELECT links2Category.ID, links2Category.Full_Name
FROM links2CatLinks, links2Category
WHERE links2CatLinks.CategoryID = links2Category.ID
AND (links2CatLinks.LinkID = '3273')

GT::SQL::Relation::select called at /home2/www/ohiobiz/linkssql2/admin/Links/Link.pm line 332 with arguments (GT::SQL::Relation=HASH(0x84c3344), HASH(0x855b27c), ARRAY(0x84995e4)).Links::Link::get_categories called at search.cgi line 151 with arguments (Links::Link=HASH(0x83f5338), 3273).main::query called at /home2/www/ohiobiz/linkssql2/admin/GT/Plugins.pm line 78 with arguments (HASH(0x80b6d28)).GT::Plugins::dispatch called at search.cgi line 66 with arguments (GT::Plugins, /home2/www/ohiobiz/linkssql2/admin/Plugins, search_results, CODE(0x8355f44), HASH(0x80b6d28)).main::search called at search.cgi line 48 with no arguments.main::main called at search.cgi line 23 with no arguments.

it continues on...


Apr 10, 2001, 9:00 AM
Paul
Veteran (19537 posts)
Apr 10, 2001, 9:00 AM
Post #2 of 5
Views: 3069
Shortcut
Quote Reply
Re: searchlogger plugin search results problem In reply to
Do you have debug off or on?

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Apr 10, 2001, 9:31 AM
mgeyman
User (294 posts)
Apr 10, 2001, 9:31 AM
Post #3 of 5
Views: 3069
Shortcut
Quote Reply
Re: searchlogger plugin search results problem In reply to
Paul,

Thanks a lot. I figured it out. I had the debug setting set to "2" when that setting should be left blank.

Mark G.

Apr 10, 2001, 9:35 AM
Paul
Veteran (19537 posts)
Apr 10, 2001, 9:35 AM
Post #4 of 5
Views: 3080
Shortcut
Quote Reply
Re: searchlogger plugin search results problem In reply to
It should be set to 0

Paul
Installations:http://wiredon.net/gt/
Support: http://wiredon.net/forum/

Apr 10, 2001, 10:05 AM
mgeyman
User (294 posts)
Apr 10, 2001, 10:05 AM
Post #5 of 5
Views: 3063
Shortcut
Quote Reply
Re: searchlogger plugin search results problem In reply to
Paul,

Got it.

Thanks.

Mark G.