[Koha-bugs] [Bug 17313] New: 3.18.x to master upgrade errors

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17313

            Bug ID: 17313
           Summary: 3.18.x to master upgrade errors
 Change sponsored?: ---
           Product: Koha
           Version: unspecified
          Hardware: All
                OS: All
            Status: NEW
          Severity: enhancement
          Priority: P5 - low
         Component: Installation and upgrade (web-based installer)
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: mtompset at hotmail.com
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com

Upgrade to 3.23.00.005 done (Bug 11569 - Typo in userpermissions.sql)
<h1>Software error:</h1>
<pre>DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.itemtype' in
'field list' at /home/mtompset/kohaclone/installer/data/mysql/updatedatabase.pl
line 11473
</pre>
<p>
For help, please send mail to the webmaster (<a
href="mailto:webmaster at debian">webmaster at debian</a>), giving this error message
and the time and date of the error.
</p>
Update errors :

[Sat Sep 17 14:37:26 2016] updatedatabase.pl: DBD::mysql::st execute failed:
Unknown column 'me.itemtype' in 'field list' [for Statement "SELECT
`me`.`biblionumber`, `me`.`subscriptionid`, `me`.`librarian`, `me`.`startdate`,
`me`.`aqbooksellerid`, `me`.`cost`, `me`.`aqbudgetid`, `me`.`weeklength`,
`me`.`monthlength`, `me`.`numberlength`, `me`.`periodicity`,
`me`.`countissuesperunit`, `me`.`notes`, `me`.`status`, `me`.`lastvalue1`,
`me`.`innerloop1`, `me`.`lastvalue2`, `me`.`innerloop2`, `me`.`lastvalue3`,
`me`.`innerloop3`, `me`.`firstacquidate`, `me`.`manualhistory`,
`me`.`irregularity`, `me`.`skip_serialseq`, `me`.`letter`,
`me`.`numberpattern`, `me`.`locale`, `me`.`distributedto`,
`me`.`internalnotes`, `me`.`callnumber`, `me`.`location`, `me`.`branchcode`,
`me`.`lastbranch`, `me`.`serialsadditems`, `me`.`staffdisplaycount`,
`me`.`opacdisplaycount`, `me`.`graceperiod`, `me`.`enddate`, `me`.`closed`,
`me`.`reneweddate`, `me`.`itemtype`, `me`.`previousitemtype` FROM
`subscription` `me`"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832.
[Sat Sep 17 14:37:26 2016] updatedatabase.pl:
DBIx::Class::Storage::DBI::_dbh_execute(): Unknown column 'me.itemtype' in
'field list' at /home/mtompset/kohaclone/installer/data/mysql/updatedatabase.pl
line 11473

To reduplicate:
get a git install koha working for master
git checkout -b my_3.18.x origin/3.18.x
in the mysql client drop and create the koha database
go to the web client
install missing dependencies as needed.
should end up with a 3.18.x DB
git checkout this bug from origin/master
go to the web cient
run through the steps and at the last step before logging into to Koha, you'll
get an error similar to above.

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.