Bug 8289

Summary: Upgrading from 2.2 does not work anymore
Product: Koha Reporter: Paul Poulain <paul.poulain>
Component: Installation and upgrade (command-line installer)Assignee: Paul Poulain <paul.poulain>
Status: CLOSED FIXED QA Contact:
Severity: critical    
Priority: P5 - low CC: chris, m.de.rooy
Version: 3.8   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Attachments: Bug 8289 Upgrading from 2.2 does not work anymore
Bug 8289 Upgrading from 2.2 does not work anymore

Description Paul Poulain 2012-06-22 09:08:51 UTC
The updatedatabase22to30.pl script update the engine from MyISAM to InnoDB for most tables.

However, the TYPE=InnoDB was deprecated, and is not removed.
The correct syntax is now ENGINE=InnoDB
Comment 1 Paul Poulain 2012-06-22 09:10:39 UTC Comment hidden (obsolete)
Comment 2 Chris Cormack 2012-06-24 07:05:50 UTC
Created attachment 10446 [details] [review]
Bug 8289 Upgrading from 2.2 does not work anymore

The updatedatabase22to30.pl script update the engine from MyISAM to InnoDB for most tables.

However, the TYPE=InnoDB was deprecated, and is not removed.
The correct syntax is now ENGINE=InnoDB

Signed-off-by: Chris Cormack <chris@bigballofwax.co.nz>
Comment 3 Marcel de Rooy 2012-06-25 06:36:08 UTC
Passed QA
Comment 4 Chris Cormack 2012-06-25 21:35:13 UTC
Simple but useful change, pushing to 3.8.x will be in 3.8.3