[Koha] Problem with upgrading Koha from 17.11 to 18.11
Daniel Owens
dcowens76 at gmail.com
Thu Mar 28 03:29:47 NZDT 2019
Chris,
Thanks for this suggestion. I checked, and both files contain the
RewriteRule you mention below. So I can rule that out.
But now the situation has changed to look more like a database problem.
I was away from my computer for the past few days and unable to check on
this. In the meantime, the OPAC started picking up the stylesheets fine,
but another error cropped up, one that prevents loading the staff client:
Software error:
Template process failed: undef error - DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_hbc.branches' doesn't exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 269
A similar error prevents searches in the OPAC:
*No results found!*
You did not specify any search criteria.
Error:
DBIx::Class::Storage::DBI::_dbh_execute(): Table 'koha_hbc.branches'
doesn't exist in engine at /usr/share/koha/lib/Koha/Objects.pm line 129
I am not finding much online about this particular issue. I did confirm
that there is no data in the table "koha_hbc.branches" in my present
database. However, a backup of my Koha database from 21 March does have
data in that table.
I am now concerned that the upgrade process led to data loss (thankfully
I have backups!). I did a mysqldump of the Koha database, and it
complained:
mysqldump: Got error: 1932: "Table
'koha_hbc.borrower_attribute_types' doesn't exist in engine" when using
LOCK TABLES
That data is also missing in my current database, though it is present
in a recent backup.
Any suggestions about how best to proceed? Should I roll Koha back to
before the upgrade and try again?
Daniel
On 3/24/19 11:48 AM, Chris Cormack wrote:
> Ahh those are changed by apache, it looks like one or 2 of your config
> files didn't update (maybe local changes)
>
> In /etc/koha
> Check that apache-shared-intranet.conf and apache-shared-opac.conf have
>
> RewriteRule ^(.*)_[0-9]{2}\.[0-9]{7}\.(js|css)$ $1.$2 [L]
>
> If not add that
>
> This actually means in future after upgrades you don't have to clear
> the cache :)
>
> Chris
>
> On 23 March 2019 7:48:54 AM NZDT, Daniel Owens <dcowens76 at gmail.com>
> wrote:
>
> Oh, of course.
>
> Full output is below, but looking through the errors, I found two kinds:
>
> * "Loading failed for the <script> with source...": It seems all the
> files referenced had "min_18.1103000" before the file extension. So
> I looked in the jquery folder to find those files, and none of the
> files contain "min_18.1103000".
> * "ReferenceError: $ is not defined" or "ReferenceError: _ is not defined"
>
> Daniel
>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-2.2.3.min_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:192:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-migrate-1.3.0.min_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:193:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/jquery-ui-1.11.4.min_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:194:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/shortcut/shortcut_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:195:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.cookie.min_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:196:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.highlight-3_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:197:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/bootstrap/bootstrap.min_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:198:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/lib/jquery/plugins/jquery.validate.min_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:199:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/staff-global_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:201:1 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/commons_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:202:1 <http://thuvien.hbc.edu.vn:8080/>
> ReferenceError: $ is not defined[Learn More]
> thuvien.hbc.edu.vn:8080:206:1 <http://thuvien.hbc.edu.vn:8080/>
> ReferenceError: _ is not defined[Learn More]
> thuvien.hbc.edu.vn:8080:233:13 <http://thuvien.hbc.edu.vn:8080/>
> Loading failed for the <script> with source
> “http://thuvien.hbc.edu.vn:8080/intranet-tmpl/prog/js/basket_18.1103000.js”.
> thuvien.hbc.edu.vn:8080:250:1 <http://thuvien.hbc.edu.vn:8080/>
> ReferenceError: $ is not defined[Learn More]
> thuvien.hbc.edu.vn:8080:261:9 <http://thuvien.hbc.edu.vn:8080/>
> <http://thuvien.hbc.edu.vn:8080/>
> On 3/22/19 1:02 PM, Indranil Das Gupta wrote:
>
> Keep the browser console on while you reload the page and see
> what errors show up. On Fri 22 Mar, 2019, 11:17 PM Daniel
> Owens, <dcowens76 at gmail.com <mailto:dcowens76 at gmail.com>>
> wrote: Thank you Indranil and Beda for the suggestion to clear
> my browser cache. I did clear the browser, but the page still
> has no styling. Any other ideas? Daniel On 3/22/19 10:40 AM,
> Indranil Das Gupta wrote:
>
> Hi Daniel, Did you do *the* one mandatory step after every
> major version
>
> upgrade
>
> - clear your browser cache? Hope this helps Indranil Das
> Gupta L2C2 Technologies On Fri 22 Mar, 2019, 8:59 PM
> Daniel Owens, <dcowens76 at gmail.com
>
> <mailto:dcowens76 at gmail.com>
>
> <mailto:dcowens76 at gmail.com <mailto:dcowens76 at gmail.com>>>
> wrote: I just upgraded from 17.11 to 18.11.
> Afterward, both the
>
> staff client
>
> and OPAC display very basic HTML, with no styling.
> The staff
>
> client
>
> login looks like this: Koha
> <http://koha-community.org/> Username: Password:
> Library: * English * Tiếng Việt
>
> <http://thuvien.hbc.edu.vn:8080/cgi-bin/koha/changelanguage.pl?language=vi-VN>
>
>
> I can log in to the staff client, and I can run
> searches in
>
> OPAC, but
>
> the pages are not displaying correctly. It is almost
> as if stylesheets were not included in the
> upgrade. Can anyone suggest how I can troubleshoot
> this problem? Daniel
> ------------------------------------------------------------------------
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
>
> <mailto:Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>>
>
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ------------------------------------------------------------------------
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
> ------------------------------------------------------------------------
> Koha mailing listhttp://koha-community.org
> Koha at lists.katipo.co.nz
> https://lists.katipo.co.nz/mailman/listinfo/koha
>
>
> --
> Sent from my Android device with K-9 Mail. Please excuse my brevity.
More information about the Koha
mailing list