[Koha-devel] Migrate/Upgrade from 2.2.3 to latest.
Rodrigo Santellan
rsantellan at gmail.com
Tue Sep 13 17:34:28 CEST 2016
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/
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20160913/8b5f6885/attachment.html>
More information about the Koha-devel
mailing list