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 <[email protected]>: > 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 <[email protected]> > 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 >> <[email protected]> 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 <[email protected]>: >>> > 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 >>> > <[email protected]> >>> > 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 >>> >> <[email protected]> >>> >> 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 >>> >>> <[email protected]> >>> >>> 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 >>> >>>> [email protected] >>> >>>> 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 >>> > [email protected] >>> > 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 >>> [email protected] >>> 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 [email protected] 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/
