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

(-)a/installer/data/mysql/kohastructure.sql (-1 / +1 lines)
Lines 1640-1646 CREATE TABLE IF NOT EXISTS `search_history` ( Link Here
1640
  `userid` int(11) NOT NULL,
1640
  `userid` int(11) NOT NULL,
1641
  `sessionid` varchar(32) NOT NULL,
1641
  `sessionid` varchar(32) NOT NULL,
1642
  `query_desc` varchar(255) NOT NULL,
1642
  `query_desc` varchar(255) NOT NULL,
1643
  `query_cgi` varchar(255) NOT NULL,
1643
  `query_cgi` text NOT NULL,
1644
  `total` int(11) NOT NULL,
1644
  `total` int(11) NOT NULL,
1645
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1645
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
1646
  KEY `userid` (`userid`),
1646
  KEY `userid` (`userid`),
(-)a/installer/data/mysql/updatedatabase.pl (+7 lines)
Lines 4446-4451 if (C4::Context->preference("Version") < TransformToNum($DBversion)) { Link Here
4446
    SetVersion($DBversion);
4446
    SetVersion($DBversion);
4447
}
4447
}
4448
4448
4449
$DBversion = "3.05.00.xxx";
4450
if (C4::Context->preference("Version") < TransformToNum($DBversion)) {
4451
    $dbh->do("ALTER TABLE search_history MODIFY COLUMN query_cgi text NOT NULL");
4452
    print "Upgrade to $DBversion done (Change search_history.query_cgi type to text. bug 9581)\n";
4453
    SetVersion($DBversion);
4454
}
4455
4449
4456
4450
=head1 FUNCTIONS
4457
=head1 FUNCTIONS
4451
4458
(-)a/opac/opac-search.pl (-1 / +6 lines)
Lines 509-514 for (my $i=0;$i<@servers;$i++) { Link Here
509
 	    }
509
 	    }
510
 
510
 
511
 	    # Adding the new search if needed
511
 	    # Adding the new search if needed
512
	    my $path_info = $cgi->url(-path_info=>1);
513
	    $query_cgi = $cgi->url(-query=>1);
514
	    $query_cgi =~ s/^$path_info\?//;
515
	    $query_cgi =~ s/;/&/g;
516
	    $query_desc .= ", $limit_desc";
517
512
           if (!$borrowernumber || $borrowernumber eq '') {
518
           if (!$borrowernumber || $borrowernumber eq '') {
513
 	    # To a cookie (the user is not logged in)
519
 	    # To a cookie (the user is not logged in)
514
 
520
 
515
- 

Return to bug 5981