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 <dcowen...@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, <dcowen...@gmail.com <mailto:dcowen...@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, <dcowen...@gmail.com
        <mailto:dcowen...@gmail.com>

            <mailto:dcowen...@gmail.com <mailto:dcowen...@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@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
        <mailto:Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>>

https://lists.katipo.co.nz/mailman/listinfo/koha
        ------------------------------------------------------------------------
        Koha mailing list http://koha-community.org
        Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz>
https://lists.katipo.co.nz/mailman/listinfo/koha
    ------------------------------------------------------------------------
    Koha mailing listhttp://koha-community.org
    Koha@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.

_______________________________________________
Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to