https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17656 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Needs Signoff |Failed QA --- Comment #298 from David Nind <david@davidnind.com> --- Still getting this error when saving subscription (as in comment #293): DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Unknown column 'permanent_irregularity' in 'INSERT INTO' at /kohadevbox/koha/Koha/Object.pm line 174 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 Output from running the database update - note no success messages (to me, it doesn't look like the new column has been added): updatedatabase DEV atomic update /kohadevbox/koha/installer/data/mysql/atomicupdate/Bug_17656-add-permanent-irregularities.perl [19:33:49] Database structure: MariaDB [koha_kohadev]> describe subscription; +---------------------------------------+--------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------------------------------+--------------+------+-----+---------+----------------+ | biblionumber | int(11) | NO | MUL | NULL | | | subscriptionid | int(11) | NO | PRI | NULL | auto_increment | | librarian | varchar(100) | YES | | | | | startdate | date | YES | | NULL | | | aqbooksellerid | int(11) | YES | MUL | NULL | | | cost | int(11) | YES | | 0 | | | aqbudgetid | int(11) | YES | | 0 | | | weeklength | int(11) | YES | | 0 | | | monthlength | int(11) | YES | | 0 | | | numberlength | int(11) | YES | | 0 | | | periodicity | int(11) | YES | MUL | NULL | | | countissuesperunit | int(11) | NO | | 1 | | | notes | longtext | YES | | NULL | | | status | varchar(100) | NO | | | | | lastvalue1 | int(11) | YES | | NULL | | | innerloop1 | int(11) | YES | | 0 | | | lastvalue2 | int(11) | YES | | NULL | | | innerloop2 | int(11) | YES | | 0 | | | lastvalue3 | int(11) | YES | | NULL | | | innerloop3 | int(11) | YES | | 0 | | | firstacquidate | date | YES | | NULL | | | manualhistory | tinyint(1) | NO | | 0 | | | irregularity | mediumtext | YES | | NULL | | | skip_serialseq | tinyint(1) | NO | | 0 | | | letter | varchar(20) | YES | | NULL | | | numberpattern | int(11) | YES | MUL | NULL | | | locale | varchar(80) | YES | | NULL | | | distributedto | mediumtext | YES | | NULL | | | internalnotes | longtext | YES | | NULL | | | callnumber | mediumtext | YES | | NULL | | | location | varchar(80) | YES | | | | | branchcode | varchar(10) | NO | | | | | lastbranch | varchar(10) | YES | | NULL | | | serialsadditems | tinyint(1) | NO | | 0 | | | staffdisplaycount | int(11) | YES | | NULL | | | opacdisplaycount | int(11) | YES | | NULL | | | graceperiod | int(11) | NO | | 0 | | | enddate | date | YES | | NULL | | | closed | tinyint(1) | NO | | 0 | | | reneweddate | date | YES | | NULL | | | itemtype | varchar(10) | YES | | NULL | | | previousitemtype | varchar(10) | YES | | NULL | | | mana_id | int(11) | YES | | NULL | | | ccode | varchar(80) | YES | | NULL | | | published_on_template | text | YES | | NULL | | | preselect_issues_in_collections_table | tinyint(1) | NO | | 0 | | +---------------------------------------+--------------+------+-----+---------+----------------+ 46 rows in set (0.001 sec) -- You are receiving this mail because: You are watching all bug changes.