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@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@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.
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
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@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
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@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@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
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
2016-09-13 0:02 GMT+01:00 Michael Hafen <michael.hafen@washk12.org>: through the the 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@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@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@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/