View | Details | Raw Unified | Return to bug 5981
Collapse All | Expand All

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1746-1752 CREATE TABLE IF NOT EXISTS `search_history` ( Link Here
1746
  `userid` int(11) NOT NULL,
1746
  `userid` int(11) NOT NULL,
1747
  `sessionid` varchar(32) NOT NULL,
1747
  `sessionid` varchar(32) NOT NULL,
1748
  `query_desc` varchar(255) NOT NULL,
1748
  `query_desc` varchar(255) NOT NULL,
1749
  `query_cgi` varchar(255) NOT NULL,
1749
  `query_cgi` text NOT NULL,
1750
  `total` int(11) NOT NULL,
1750
  `total` int(11) NOT NULL,
1751
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1751
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1752
  KEY `userid` (`userid`),
1752
  KEY `userid` (`userid`),
(-)a/installer/data/mysql/updatedatabase.pl (+6 lines)
Lines 5369-5374 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5369
    SetVersion($DBversion);
5369
    SetVersion($DBversion);
5370
}
5370
}
5371
5371
5372
$DBversion = "3.09.00.XXX";
5373
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
5374
    $dbh->do("ALTER TABLE search_history MODIFY COLUMN query_cgi text NOT NULL");
5375
    print "Upgrade to $DBversion done (Change search_history.query_cgi type to text. bug 5981)\n";
5376
    SetVersion($DBversion);
5377
}
5372
5378
5373
=head1 FUNCTIONS
5379
=head1 FUNCTIONS
5374
5380
(-)a/opac/opac-search.pl (-1 / +6 lines)
Lines 589-594 for (my $i=0;$i<@servers;$i++) { Link Here
589
            }
589
            }
590
590
591
            # Adding the new search if needed
591
            # Adding the new search if needed
592
	    my $path_info = $cgi->url(-path_info=>1);
593
	    $query_cgi = $cgi->url(-query=>1);
594
	    $query_cgi =~ s/^$path_info\?//;
595
	    $query_cgi =~ s/;/&/g;
596
	    $query_desc .= ", $limit_desc";
597
592
            if (!$borrowernumber || $borrowernumber eq '') {
598
            if (!$borrowernumber || $borrowernumber eq '') {
593
                # To a cookie (the user is not logged in)
599
                # To a cookie (the user is not logged in)
594
                if (($params->{'offset'}||'') eq '') {
600
                if (($params->{'offset'}||'') eq '') {
595
- 

Return to bug 5981