Sign in
We're evolving to serve you better! This current forum has transitioned to read-only mode. For new discussions, support, and engagement, we've moved to GitHub Discussions.

Javascript errors following upgrade to .44.4 on Windows 10

  • This topic has 22 replies, 5 voices, and was last updated 3 weeks, 6 days ago by .
Viewing 23 posts - 1 through 23 (of 23 total)
  • Author
    Posts
  • #11521
    Avatar photosibo999

    Hi

    Just installed new theme (photos) and had to upgrade base publii. Used the latest download but subsequently site won’t load and generates lots of errors.

    A JavaScript error occurred in the main process
    Uncaught Exception:
    SQlite3Error: database is locked
    at Database._handleError
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\node_modules\n … :5979)
    at new Statement
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\node_modules\n … :6099)
    at Database.prepare
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\node_modules\n … :5363)
    at Database._query
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\node_modules\n … :5703)
    at Database.all
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\node_modules\n … :5538)
    at DBUtils.all
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\back-end\helpers\ … :24)
    at Posts.load
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\back-end\posts.js:38:42)
    at App.switchSite
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\back-end\app.js:241 :26)
    at App.reloadSite
    (C:\ Users\ US ER\App Data\Local\Programs\ Pu blii\resources\ap p.asar\back-end\ap p.js: 191 :29)
    at lpcMainlmpl. <anonymous>
    (C:\Users\USER\AppData\Local\Programs\Publii\resources\app.asar\back-end\events\si … :38)

     

    Tried various reinstalls, reloads on new install etc and still the same issue. Noticed a similar thread refering to Linux. This is windows 10. Suspect might be an installation issue.

    #11524
    Avatar photoTomasz Dziuda

    Hi,

    Please check if your AV/antimalware software does not block the sqlite database. We had to change SQLite engine and maybe it triggers your AV/antimalware software which blocks/quarantine the SQLite file

    --
    Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!

    #11529
    Avatar photosibo999

    Hi

    Tried it on a couple of machines running basic windows AV with everthing turned off and unfortunately no difference.

    #11532
    Avatar photoTomasz Dziuda

    Are you using One Drive to sync folders which stores Publii websites data?

    --
    Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!

    #11536
    Avatar photosibo999

    No

    It just happens to be the folder path for historic reasons.

    #11537
    Avatar photosibo999

    Is there any way of defining the installation folder?

    #11539
    Avatar photoTomasz Dziuda

    You can specify location of the sites under App Settings 🙂

    --
    Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!

    #11542
    Avatar photosibo999

    Ok, thanks for that aside. Still left with the issue of a website that can’t be updated. I’ve got a client who’s running out of patience. Anything we can do to resolve the issue?

    #11544
    Avatar photoNorbert

    Hallo,

    ich habe seit einigen Tagen (nach dem Update) das gleiche Problem. Habe Publii auch schon mehrfach neu installiert und habe Sorge, dass ich meine ganze umfangreiche Blogseite verliere.

    Bisher habe ich noch keine Lösung gefunden. Auch das ausgeschaltete “Malwarebytes” bringt nichts.

    GlĂŒckauf aus Dorsten
    Norbert Großer

    #11546
    Avatar photojustme

    Updated to latest 0.44.4 (build 16557), but I recveive different javascript errors…. Examples:

    1 Uncaught javascript error when trying to install (update) the latest Editorial theme.
    Install theme is trying to create an subdirectory __TEMP__ in default directory on drive c documents…
    Pls see attachement: theme-error.png

    2. When trying to update App settings also a javascript error…. please see attachement: app-settings-error.png

    -> I’ve added publii to firewall / anti-virus, but this doesn’t help…..

     

    @Tomasz Dziuda: Where do you change the installation Directory in App settings? I see website files, backup and preview location, not the installation directory…!?!

    #11559
    Avatar photosibo999

    Thanks Norbert and Justme

    @Publii It seems that there are a few people having a very similar issue. Can we get a fast resolution please. Currently my site can’t be updated since I updated publii 10 days ago now.

    #11563
    Avatar photoNorbert

    Hallo zusammen,
    Mein Sohn konnte das Problem mit dem JavaScript-Fehler lösen. Wir haben die Datei “db.sqlite” im Ordner “Input” gelöscht. Damit ist Publii orientierungslos. Nach dem Einspielen eines Backups (mache ich regelmĂ€ĂŸig), trat der Fehler nicht mehr auf.
    Fazit: Die Datei “db.sqlite” war korrupt. Ob das durch das Update auf die neue Version entstanden ist, kann ich nicht beurteilen – es war aber sehr zeitnah.

    GlĂŒckauf aus Dorsten
    Norbert

    #11566
    Avatar photosibo999

    Unfortunately that didn’t work for me. Deleting the db.sqllite just gives an error on reload. Rerunning the restore from backup then just takes me back to the original javascript errors.

    #11567
    Avatar photoNorbert

    @sibo999-KARTON
    ich glaube, dass wir eine unterschiedliche Fehlermeldung hatten.
    Ich wĂŒrde versuchen, nach löschen der db.sqlite eine neue Datenbank anzulegen. Wenn das funktioniert, können ja die Daten dort importiert werden.

    GlĂŒckauf aus Dorsten
    Norbert

    #11574
    Avatar photoJOduMonT

    I had this kind of error before; if it’s the same issue, you could try to uninstall Publii then

    right click on the Publii installation (EXE or MSI) and run it as an Administrator

    by elevating the rights during the installation process Publii will be able to create missing directory in your profile.

     

    #11575
    Avatar photoNorbert

    @JOduMonT – hallo,
    das kann keine dauerhafte Strategie sein, wiederholt bei derartigen Problemen das Programm zu neu zu installieren. Solche Fehler mĂŒssten anderweitig abgefangen oder intern gelöst werden. Mein Publii lĂ€uft jetzt wieder, auch Dank meiner regelmĂ€ĂŸigen Datenbanksicherungen. Ich habe die vorherige Version wieder installiert.

    GlĂŒckauf aus Dorsten
    Norbert

    #11583
    Avatar photosibo999

    Thanks I’ll give that a go.

    Are previous versions available anywhere?

     

    #11595
    Avatar photoJOduMonT
    Norbert wrote:


    @JOduMonT
    – hallo, das kann keine dauerhafte Strategie sein, wiederholt bei derartigen Problemen das Programm zu neu zu installieren. Solche Fehler mĂŒssten anderweitig abgefangen oder intern gelöst werden. Mein Publii lĂ€uft jetzt wieder, auch Dank meiner regelmĂ€ĂŸigen Datenbanksicherungen. Ich habe die vorherige Version wieder installiert. GlĂŒckauf aus Dorsten Norbert

    Unless you can understand English, or you use a translator, but I definitely don’t speak German.

    From what I understand, Norbert tu as un problĂšme diffĂ©rent et tu devrais crĂ©er un nouveau topic; and from what I understand, it’s more about you sync the Publii folder which is in your Documents.

    Personally, I sync only the sites folder on my Google Drive and it works like a charm.

     

    #11596
    Avatar photosibo999

    Think this is off topic. We’re still trying to resolve why the latest system release is throwing lots of Javascript errors.

     

    #11597
    Avatar photoJOduMonT
    sibo999 wrote:

    Think this is off topic. We’re still trying to resolve why the latest system release is throwing lots of Javascript errors.

    Irony; for me, with the latest version; it’s the first time I don’t have issue 😉
    before I was always doing something funky (user habit)

    https://github.com/GetPublii/Publii/issues/1288

    by the way; if you believe that your issue is related to the last version, you could install a previous version from here: https://github.com/GetPublii/Publii/releases

    #11611
    Avatar photosibo999

    Thanks for that, great to see all the old versions. Probably a stupid question but how do I install an old version (windows).

     

    #11660
    Avatar photoTomasz Dziuda

    It seems that the locked message can appear also on Dropbox sync. After consulting with the node-sqlite3-wasm author, it is due universal method of marking DB file as locked which can have some side effects.

    In this case we have decided to use old sqlite3 library on mac OS / Windows and new library (WASM) on Linux to minimize risk of the issues.

    I will prepare prebuilds of v.0.45 with this fix next week so I will also share here for anyone who wants to test it.

    --
    Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!

    #11664
    Avatar photosibo999

    Great, thanks

Viewing 23 posts - 1 through 23 (of 23 total)
  • You must be logged in to reply to this topic.