Bug 17313 - 3.18.x to master upgrade errors
Summary: 3.18.x to master upgrade errors
Status: RESOLVED DUPLICATE of bug 17292
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: unspecified
Hardware: All All
: P5 - low major (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-09-17 18:44 UTC by Mark Tompsett
Modified: 2016-09-19 03:31 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Tompsett 2016-09-17 18:44:45 UTC
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@debian">webmaster@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.
Comment 1 Mark Tompsett 2016-09-19 03:31:17 UTC

*** This bug has been marked as a duplicate of bug 17292 ***