Time Nick Message
08:35 reiveune hello
13:53 eythian hi
15:11 reiveune bye
15:23 KotH a wonderful good afternoon!
15:24 KotH I have a little problem with my koha instance: it seems that a few of the db schema updates in the past were not applied correctly and now, with the last update things stopped working completely...
15:24 KotH I am thinking to just dump the db, reinstall koha to get a clean state and restore the db
15:25 KotH (restoring without dropping the tables and recreating them, so they are up to date in the schema)
15:25 KotH would that be a good idea or is this asking for more trouble?
15:26 mbridge [mattermost] <caroline> KotH do you have error messages or something when you run the updatedatabase script?
15:28 KotH mbridge: nope
15:28 KotH mbridge: but i get a "Error: you must provide at least one instance name" when i restart koha
15:29 KotH mbridge: and koha tells me it's in maintenance mode: https://lib.kinali.ch/
15:29 mbridge [mattermost] <caroline> yes it does that when the database is not up to date
15:30 KotH i do know, though, that my db is not completely up to date.. i run into problems previously and checked against the schema and there were differences
15:30 KotH yeah.. but koha-upgrade-schema returns with no error message... not even a single line of output
15:31 KotH *facepalm*
15:31 KotH yeah.. i should read the doc..
15:31 mbridge [mattermost] <caroline> The error you mention is because the command is missing the instance name
15:31 KotH --
15:31 KotH # koha-upgrade-schema kinalilib
15:31 KotH Upgrading database schema for kinalilib
15:31 KotH Upgrade to 23.12.00.023 [17:31:19]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL
15:31 huginn` 04Bug https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32132 normal, P5 - low, ---, emmi.takkinen, Needs documenting , Missing budget_period_id in aqbudgets kills lateorders.pl
15:31 KotH ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'budget_period_id': used in a foreign key constraint 'aqbudgetperiods_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 741
15:31 KotH --
15:35 mbridge [mattermost] <caroline> You could comment on the mentioned bug with the error. The people who wrote it could help