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

January 9, 2024 at 9:47 pm #11521

[anonymous]

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.

January 10, 2024 at 1:02 am #11524

[anonymous]

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

January 10, 2024 at 6:37 pm #11529

[anonymous]

Hi

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

January 10, 2024 at 9:03 pm #11532

[anonymous]

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

January 11, 2024 at 8:41 am #11536

[anonymous]

No

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

January 11, 2024 at 8:42 am #11537

[anonymous]

Is there any way of defining the installation folder?

January 11, 2024 at 6:29 pm #11539

[anonymous]

You can specify location of the sites under App Settings 🙂

January 12, 2024 at 9:37 am #11542

[anonymous]

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?

January 13, 2024 at 9:47 am #11544

[anonymous]

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

January 13, 2024 at 12:14 pm #11546

[anonymous]

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…!?!

January 13, 2024 at 6:48 pm #11559

[anonymous]

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.

January 15, 2024 at 9:24 am #11563

[anonymous]

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

January 15, 2024 at 1:43 pm #11566

[anonymous]

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.

January 15, 2024 at 2:43 pm #11567

[anonymous]

@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

January 17, 2024 at 2:57 pm #11574

[anonymous]

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.

January 17, 2024 at 3:04 pm #11575

[anonymous]

@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

January 17, 2024 at 6:51 pm #11583

[anonymous]

Thanks I’ll give that a go.

Are previous versions available anywhere?

January 19, 2024 at 2:00 pm #11595

[anonymous]

[anonymous] 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.

January 19, 2024 at 2:52 pm #11596

[anonymous]

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

January 20, 2024 at 1:05 am #11597

[anonymous]

[anonymous] 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

January 21, 2024 at 6:37 pm #11611

[anonymous]

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

January 27, 2024 at 6:59 pm #11660

[anonymous]

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.

January 28, 2024 at 4:54 pm #11664

[anonymous]

Great, thanks