Bugzilla – Attachment 53639 Details for
Bug 16573
Web installer fails to load structure and sample data on MySQL 5.7
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 16573: Define virtualshelves.created_on as datetime for existing installs
Bug-16573-Define-virtualshelvescreatedon-as-dateti.patch (text/plain), 961 bytes, created by
Jonathan Druart
on 2016-07-22 08:52:07 UTC
(
hide
)
Description:
Bug 16573: Define virtualshelves.created_on as datetime for existing installs
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2016-07-22 08:52:07 UTC
Size:
961 bytes
patch
obsolete
>From fa40421a9cda645613920d7748f46f36d7cf2a5e Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >Date: Fri, 22 Jul 2016 09:51:00 +0100 >Subject: [PATCH] Bug 16573: Define virtualshelves.created_on as datetime for > existing installs > >--- > installer/data/mysql/updatedatabase.pl | 2 +- > 1 file changed, 1 insertion(+), 1 deletion(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index c84fc3b..770bc6f 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -10387,7 +10387,7 @@ $DBversion = "3.19.00.038"; > if ( CheckVersion($DBversion) ) { > $dbh->do(q| > ALTER TABLE virtualshelves >- ADD COLUMN created_on TIMESTAMP NOT NULL AFTER lastmodified >+ ADD COLUMN created_on DATETIME NOT NULL AFTER lastmodified > |); > # Set created_on = lastmodified > # I would say it's better than 0000-00-00 >-- >2.8.1
<b>You cannot view the attachment while viewing its details because your browser does not support IFRAMEs. <a href="attachment.cgi?id=53639">View the attachment on a separate page</a>.</b>
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 16573
:
51727
|
51728
|
51741
|
51751
|
51760
|
51761
|
51762
|
53639
|
53664
|
53676
|
53677
|
53678
|
53679
|
54658