I keep this error when I go to my search page.
I am still using the 2.2.1, i can't upgrade because of the "fetchrow_hashref" error
It has to do with a search logs table
error
Can't call method "fetchrow_hashref" on an undefined value at (eval 6) line 9
Stack Trace
======================================
Links (14529): Links::environment called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links.pm line 524 with no arguments.
Links (14529): Links::fatal called at (eval 6) line 9 with arguments
(Can't call method "fetchrow_hashref" on an undefined value at (eval 6) line 9.
).
Links (14529): Links::__ANON__ called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Template.pm line 899 with arguments
(HASH(0x83bbb88)).
Links (14529): GT::Template::_get_var called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/templates/default/compiled/search.html.compiled line 241 with arguments
(GT::Template=HASH(0x834f344), top_search_terms, 0, 1).
Links (14529): GT::Template::parsed_template called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Template.pm line 640 with arguments
(GT::Template=HASH(0x834f344)).
Links (14529): GT::Template::_parse called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Template.pm line 126 with arguments
(GT::Template=HASH(0x834f344), search.html, HASH(0x834f0e0)).
Links (14529): GT::Template::parse called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links.pm line 385 with arguments
(GT::Template, search.html, ARRAY(0x83bf938), HASH(0x834f0e0)).
Links (14529): Links::user_page called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links/SiteHTML.pm line 254 with arguments
(search.html, [undef], HASH(0x834f0e0)).
Links (14529): Links::SiteHTML::__ANON__ called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Plugins.pm line 112 with arguments
([undef], [undef]).
Links (14529): GT::Plugins::dispatch called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links/SiteHTML.pm line 28 with arguments
(GT::Plugins, /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Plugins, site_html_search, CODE(0x8390f54), [undef], [undef]).
Links (14529): Links::SiteHTML::display called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links/User/Search.pm line 58 with arguments
(search).
Links (14529): Links::User::Search::handle called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Plugins.pm line 112 with no arguments.
Links (14529): GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x80823f8)).
System Information
======================================
Perl Version: 5.008001
Links SQL Version: 2.2.0
DBI.pm Version: 1.37
Running under mod_perl: No
Running under SpeedyCGI: No
GT::SQL::error = Failed to execute query: 'SELECT * FROM SearchLog ORDER BY HitCount DESC LIMIT 15' Reason: Table 'coupons.SearchLog' doesn't exist
@INC =
/home/httpd/vhosts/xxxxxxxxxxxxx.com/cgi-bin/admin
/usr/lib/perl5/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/5.8.1
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl
I am still using the 2.2.1, i can't upgrade because of the "fetchrow_hashref" error
It has to do with a search logs table
error
Can't call method "fetchrow_hashref" on an undefined value at (eval 6) line 9
Stack Trace
======================================
Links (14529): Links::environment called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links.pm line 524 with no arguments.
Links (14529): Links::fatal called at (eval 6) line 9 with arguments
(Can't call method "fetchrow_hashref" on an undefined value at (eval 6) line 9.
).
Links (14529): Links::__ANON__ called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Template.pm line 899 with arguments
(HASH(0x83bbb88)).
Links (14529): GT::Template::_get_var called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/templates/default/compiled/search.html.compiled line 241 with arguments
(GT::Template=HASH(0x834f344), top_search_terms, 0, 1).
Links (14529): GT::Template::parsed_template called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Template.pm line 640 with arguments
(GT::Template=HASH(0x834f344)).
Links (14529): GT::Template::_parse called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Template.pm line 126 with arguments
(GT::Template=HASH(0x834f344), search.html, HASH(0x834f0e0)).
Links (14529): GT::Template::parse called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links.pm line 385 with arguments
(GT::Template, search.html, ARRAY(0x83bf938), HASH(0x834f0e0)).
Links (14529): Links::user_page called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links/SiteHTML.pm line 254 with arguments
(search.html, [undef], HASH(0x834f0e0)).
Links (14529): Links::SiteHTML::__ANON__ called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Plugins.pm line 112 with arguments
([undef], [undef]).
Links (14529): GT::Plugins::dispatch called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links/SiteHTML.pm line 28 with arguments
(GT::Plugins, /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Plugins, site_html_search, CODE(0x8390f54), [undef], [undef]).
Links (14529): Links::SiteHTML::display called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Links/User/Search.pm line 58 with arguments
(search).
Links (14529): Links::User::Search::handle called at /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/GT/Plugins.pm line 112 with no arguments.
Links (14529): GT::Plugins::dispatch called at search.cgi line 25 with arguments
(GT::Plugins, /home/httpd/vhosts/xxxxxxxxxxxxxxx.com/cgi-bin/admin/Plugins, handle_search, CODE(0x80823f8)).
System Information
======================================
Perl Version: 5.008001
Links SQL Version: 2.2.0
DBI.pm Version: 1.37
Running under mod_perl: No
Running under SpeedyCGI: No
GT::SQL::error = Failed to execute query: 'SELECT * FROM SearchLog ORDER BY HitCount DESC LIMIT 15' Reason: Table 'coupons.SearchLog' doesn't exist
@INC =
/home/httpd/vhosts/xxxxxxxxxxxxx.com/cgi-bin/admin
/usr/lib/perl5/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/5.8.1
/usr/lib/perl5/site_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.1
/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
/usr/lib/perl5/vendor_perl/5.8.1/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.1
/usr/lib/perl5/vendor_perl/5.8.0/i386-linux-thread-multi
/usr/lib/perl5/vendor_perl/5.8.0
/usr/lib/perl5/vendor_perl