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 (+7 lines)
Lines 5452-5457 if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { Link Here
5452
    SetVersion($DBversion);
5452
    SetVersion($DBversion);
5453
}
5453
}
5454
5454
5455
$DBversion = "3.09.00.XXX";
5456
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
5457
    $dbh->do("ALTER TABLE search_history MODIFY COLUMN query_cgi text NOT NULL");
5458
    print "Upgrade to $DBversion done (Change search_history.query_cgi type to text. bug 5981)\n";
5459
    SetVersion($DBversion);
5460
}
5461
5455
=head1 FUNCTIONS
5462
=head1 FUNCTIONS
5456
5463
5457
=head2 TableExists($table)
5464
=head2 TableExists($table)
(-)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