Bugzilla – Attachment 9163 Details for
Bug 5668
Star ratings in the opac
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
[SIGNED-OFF] Bug 5668 Error during during insall with web installer, Step 3
SIGNED-OFF-Bug-5668-Error-during-during-insall-wit.patch (text/plain), 2.25 KB, created by
Katrin Fischer
on 2012-04-13 05:39:50 UTC
(
hide
)
Description:
[SIGNED-OFF] Bug 5668 Error during during insall with web installer, Step 3
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2012-04-13 05:39:50 UTC
Size:
2.25 KB
patch
obsolete
>From 83febd14d8eb9d3dd60cf2f17f049302e31855b6 Mon Sep 17 00:00:00 2001 >From: mveron <veron@veron.ch> >Date: Thu, 12 Apr 2012 22:17:02 +0200 >Subject: [PATCH] [SIGNED-OFF] Bug 5668 Error during during insall with web > installer, Step 3 > >Signed-off-by: Katrin Fischer <Katrin.Fischer.83@web.de> >Before patch web installer dies with error message on creating >database tables: >ERROR 1064 (42000) at line 2821: You have an error in your SQL >syntax; check the manual that corresponds to your MySQL server >version for the right syntax to use near '- biblionumber int(11) >NOT NULL, - rating_value tinyint(1) NOT NULL, - ' at line 2 > >After patch installation completes normally. I also checked >that tables ratings and pending_offline_operations were >created correctly. > >Note: This is Marc Veron's first patch for Koha - congratulations! >--- > installer/data/mysql/kohastructure.sql | 7 ++++--- > 1 files changed, 4 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/kohastructure.sql b/installer/data/mysql/kohastructure.sql >index 71eaeb0..a210293 100644 >--- a/installer/data/mysql/kohastructure.sql >+++ b/installer/data/mysql/kohastructure.sql >@@ -1545,6 +1545,7 @@ CREATE TABLE `patronimage` ( > -- this table is MyISAM, InnoDB tables are growing only and this table is filled/emptied/filled/emptied... > -- so MyISAM is better in this case > >+DROP TABLE IF EXISTS `pending_offline_operations`; > CREATE TABLE `pending_offline_operations` ( > `operationid` int(11) NOT NULL AUTO_INCREMENT, > `userid` varchar(30) NOT NULL, >@@ -2819,9 +2820,9 @@ CREATE TABLE IF NOT EXISTS `social_data` ( > > DROP TABLE IF EXISTS ratings; > CREATE TABLE ratings ( >- borrowernumber int(11) NOT NULL, --- the borrower this rating is for >- biblionumber int(11) NOT NULL, --- the biblio it's for >- rating_value tinyint(1) NOT NULL, --- the rating, from 1-5 >+ borrowernumber int(11) NOT NULL, -- the borrower this rating is for >+ biblionumber int(11) NOT NULL, -- the biblio it's for >+ rating_value tinyint(1) NOT NULL, -- the rating, from 1-5 > timestamp timestamp NOT NULL default CURRENT_TIMESTAMP, > PRIMARY KEY (borrowernumber,biblionumber), > CONSTRAINT ratings_ibfk_1 FOREIGN KEY (borrowernumber) REFERENCES borrowers (borrowernumber) ON DELETE CASCADE ON UPDATE CASCADE, >-- >1.7.5.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5668
:
3034
|
3035
|
5097
|
5098
|
5136
|
5137
|
5792
|
5794
|
5833
|
7116
|
7165
|
7166
|
7215
|
7604
|
7798
|
8027
|
8199
|
8202
|
8312
|
8326
|
8359
|
8459
|
8514
|
8537
|
8548
|
8613
|
8704
|
8705
|
8706
|
9159
|
9163
|
9164