[Koha-devel] Migrate/Upgrade from 2.2.3 to latest.
Jonathan Druart
jonathan.druart at bugs.koha-community.org
Wed Sep 14 09:16:32 CEST 2016
These errors are fixes by 3.01.00.009, certainly because MySQL
strictness has changed since 3.00.00.068
Try to change the 2 code columns to default null.
If it works, please open a new bug report (and attach a patch if you
know how to do it :))
Cheers,
Jonathan
2016-09-13 16:34 GMT+01:00 Rodrigo Santellan <rsantellan at gmail.com>:
> I found out that on the upgrade 3.00.00.068 the script for creating the
> table permissions is wrong:
>
> DBD::mysql::db do failed: All parts of a PRIMARY KEY must be NOT NULL; if
> you need NULL in a key, use UNIQUE instead [for Statement "CREATE TABLE
> `permissions` (
> `module_bit` int(11) NOT NULL DEFAULT 0,
> `code` varchar(30) DEFAULT NULL,
> `description` varchar(255) DEFAULT NULL,
> PRIMARY KEY (`module_bit`, `code`),
> CONSTRAINT `permissions_ibfk_1` FOREIGN KEY (`module_bit`)
> REFERENCES `userflags` (`bit`)
> ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8"] at updatedatabase.pl
> line 1273.
> DBD::mysql::db do failed: Cannot add foreign key constraint [for Statement
> "CREATE TABLE `user_permissions` (
> `borrowernumber` int(11) NOT NULL DEFAULT 0,
> `module_bit` int(11) NOT NULL DEFAULT 0,
> `code` varchar(30) DEFAULT NULL,
> CONSTRAINT `user_permissions_ibfk_1` FOREIGN KEY
> (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`)
> ON DELETE CASCADE ON UPDATE CASCADE,
> CONSTRAINT `user_permissions_ibfk_2` FOREIGN KEY
> (`module_bit`, `code`)
> REFERENCES `permissions` (`module_bit`, `code`)
> ON DELETE CASCADE ON UPDATE CASCADE
> ) ENGINE=InnoDB DEFAULT CHARSET=utf8"] at updatedatabase.pl
> line 1281.
>
> Has anybody has the correct definition of the table permissions?
>
> Regards.
>
> On Tue, Sep 13, 2016 at 11:35 AM, Rodrigo Santellan <rsantellan at gmail.com>
> wrote:
>>
>> Hi,
>>
>> I have changed: 3.00.00.053 to remove the constraint to labels_templates
>> and now it goes smooth on that part. I'll add more logging when the db query
>> are executed because there are some tables like permissions that are not
>> created.
>>
>> Thanks a lot!
>>
>> On Tue, Sep 13, 2016 at 4:29 AM, Jonathan Druart
>> <jonathan.druart at bugs.koha-community.org> wrote:
>>>
>>> It has been removed by
>>> commit c102b61ef58dc34860e8acf6cab6bd9a96dae0a1
>>> Date: Mon Jan 4 14:18:01 2010 -0500
>>> [26/30] Updating kohastructure.sql to reflect changes introduced
>>> in Patron Card Creator work
>>>
>>> But indeed these changes have not been put in the updatedatabase.pl file.
>>> You can ignore this table.
>>>
>>> 2016-09-13 0:02 GMT+01:00 Michael Hafen <michael.hafen at washk12.org>:
>>> > There's also update 61 which references the labels_templates table.
>>> > You'd
>>> > have to omit that one too.
>>> > That table is gone, but I don't know when it gets dropped. I looked
>>> > through
>>> > updatedatabase.pl and didn't see it get dropped. So I don't know. If
>>> > you
>>> > are aiming for a recent release then it should be ok to omit the table
>>> > and
>>> > those two updates.
>>> >
>>> > On Mon, Sep 12, 2016 at 1:04 PM, Rodrigo Santellan
>>> > <rsantellan at gmail.com>
>>> > wrote:
>>> >>
>>> >> Passing the conditions in true (1 == 1 ) on lines 2623 and 3418 I'm
>>> >> able
>>> >> to pass further on the updatedatabase.pl
>>> >>
>>> >> But the problems are on migrating to 3.00.00.053 the definitions that
>>> >> are
>>> >> needed on that table are on 3.00.00.059. My intuition says to change
>>> >> the
>>> >> order, but I have to be honest that I don't know the consequences and
>>> >> according to the IRC chat the table labels_templates is gone.
>>> >>
>>> >> Should I ommit them both?
>>> >>
>>> >> Thanks!
>>> >>
>>> >> On Mon, Sep 12, 2016 at 1:56 PM, Michael Hafen
>>> >> <michael.hafen at washk12.org>
>>> >> wrote:
>>> >>>
>>> >>> Have you looked in the /installer/data/mysql directory at the
>>> >>> labels_upgrade.pl and patroncards_upgrade.pl scripts. I think those
>>> >>> where
>>> >>> supposed to be run by the updatedatabase.pl script, but I seem to
>>> >>> recall
>>> >>> having trouble with that myself.
>>> >>>
>>> >>> On Mon, Sep 12, 2016 at 7:07 AM, Rodrigo Santellan
>>> >>> <rsantellan at gmail.com>
>>> >>> wrote:
>>> >>>>
>>> >>>> Hi,
>>> >>>>
>>> >>>> I'm trying to do a migration or upgrade from koha 2.2.3 to koha 3. I
>>> >>>> know is a daunting task that I have embarked but I'm trying to bring
>>> >>>> back a
>>> >>>> library to the latest updates of the community.
>>> >>>>
>>> >>>> So far this are the steps I have done:
>>> >>>> 1 - I dump an empty schema of the DB and create a new one with the
>>> >>>> name
>>> >>>> koha3.
>>> >>>> 2 - Apply the update22to30.pl
>>> >>>> 3 - Import all the tables I could, the one that not been deleted.
>>> >>>> 4 - Run updatedatabase.pl
>>> >>>>
>>> >>>> And now I'm stuck there, I'm missing the table: labels_templates and
>>> >>>> the
>>> >>>> table printers_profile is different.
>>> >>>>
>>> >>>> I have asked on the IRC channel and they say that table
>>> >>>> labels_templates
>>> >>>> is gone on 3.18.
>>> >>>>
>>> >>>> I'm heading on a good direction? Or I should do a clean install and
>>> >>>> then
>>> >>>> try to import all the old data?
>>> >>>>
>>> >>>> I will appreciate any help! Thanks in advance!
>>> >>>>
>>> >>>> Regards.
>>> >>>>
>>> >>>> Rodrigo Santellán.
>>> >>>>
>>> >>>> _______________________________________________
>>> >>>> Koha-devel mailing list
>>> >>>> Koha-devel at lists.koha-community.org
>>> >>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> >>>> website : http://www.koha-community.org/
>>> >>>> git : http://git.koha-community.org/
>>> >>>> bugs : http://bugs.koha-community.org/
>>> >>>
>>> >>>
>>> >>>
>>> >>>
>>> >>> --
>>> >>> Michael Hafen
>>> >>> Washington County School District Technology Department
>>> >>> Systems Analyst
>>> >>>
>>> >>
>>> >
>>> >
>>> >
>>> > --
>>> > Michael Hafen
>>> > Washington County School District Technology Department
>>> > Systems Analyst
>>> >
>>> >
>>> > _______________________________________________
>>> > Koha-devel mailing list
>>> > Koha-devel at lists.koha-community.org
>>> > http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> > website : http://www.koha-community.org/
>>> > git : http://git.koha-community.org/
>>> > bugs : http://bugs.koha-community.org/
>>> _______________________________________________
>>> Koha-devel mailing list
>>> Koha-devel at lists.koha-community.org
>>> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
>>> website : http://www.koha-community.org/
>>> git : http://git.koha-community.org/
>>> bugs : http://bugs.koha-community.org/
>>
>>
>
More information about the Koha-devel
mailing list