Arch Linux User Repository

When I try to use the search bar, Notesnook crashes and gives the error below. Is this error related to this package, or is the cause upstream?

Failed to construct 'Statement': no such function: regexp (query: select "results"."id", "results"."type", 1 as "rank" from (select "id", 'title' as "type" from "notes" where "id" in (select "id" from "notes" where ("dateDeleted" is null or "dateDeleted" == 0) and ("deleted" is null or "deleted" == 0) and ("archived" is null or "archived" == 0)) and "title" regexp ? union all select "noteId" as "id", 'content' as "type" from "content" where "content"."locked" != ? and "noteId" in (select "id" from "notes" where ("dateDeleted" is null or "dateDeleted" == 0) and ("deleted" is null or "deleted" == 0) and ("archived" is null or "archived" == 0)) and "data" regexp ?) as "results")
SqliteError: Failed to construct 'Statement': no such function: regexp (query: select "results"."id", "results"."type", 1 as "rank" from (select "id", 'title' as "type" from "notes" where "id" in (select "id" from "notes" where ("dateDeleted" is null or "dateDeleted" == 0) and ("deleted" is null or "deleted" == 0) and ("archived" is null or "archived" == 0)) and "title" regexp ? union all select "noteId" as "id", 'content' as "type" from "content" where "content"."locked" != ? and "noteId" in (select "id" from "notes" where ("dateDeleted" is null or "dateDeleted" == 0) and ("deleted" is null or "deleted" == 0) and ("archived" is null or "archived" == 0)) and "data" regexp ?) as "results")
    at Database.prepare (/usr/lib/notesnook/app/node_modules/better-sqlite3-multiple-ciphers/lib/methods/wrappers.js:5:21)
    at z.<anonymous> (https://app.notesnook.com/assets/sqlite.worker.desktop-JHv0zQDB.js:1:858)
    at Generator.next (<anonymous>)
    at https://app.notesnook.com/assets/sqlite.worker.desktop-JHv0zQDB.js:1:298
    at new Promise (<anonymous>)
    at h (https://app.notesnook.com/assets/sqlite.worker.desktop-JHv0zQDB.js:1:95)
    at z.prepare (https://app.notesnook.com/assets/sqlite.worker.desktop-JHv0zQDB.js:1:675)
    at z.<anonymous> (https://app.notesnook.com/assets/sqlite.worker.desktop-JHv0zQDB.js:1:1286)
    at Generator.next (<anonymous>)
    at https://app.notesnook.com/assets/sqlite.worker.desktop-JHv0zQDB.js:1:298

@ashwinkj Thanks for your feedback, I have fixed it.

@zxp19821005

Currently, it is not able to make the AppImage executable because lines 40 and 41 is checking for the wrong files. I had to change the check to respect the architecture like below.

diff --git a/PKGBUILD b/PKGBUILD
index 70bf4cd..c126623 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -37,8 +37,8 @@ prepare() {
         s/@cfgdirname@/${_appname}/g
         s/@options@/env ELECTRON_OZONE_PLATFORM_HINT=auto/g
     " "${srcdir}/${pkgname%-bin}.sh"
-    if [ ! -x "${srcdir}/${pkgname%-bin}-${pkgver}.AppImage" ];then
-        chmod +x "${srcdir}/${pkgname%-bin}-${pkgver}.AppImage"
+    if [ ! -x "${srcdir}/${pkgname%-bin}-${pkgver}-${CARCH}.AppImage" ];then
+        chmod +x "${srcdir}/${pkgname%-bin}-${pkgver}-${CARCH}.AppImage"
     fi
     "${srcdir}/${pkgname%-bin}-${pkgver}-${CARCH}.AppImage" --appimage-extract > /dev/null
     sed -i "s/AppRun --no-sandbox/${pkgname%-bin}/g;s/Icon=${_pkgname}/Icon=${pkgname%-bin}/g" -i "${srcdir}/squashfs-root/${_pkgname}.desktop"

Thank you! The runtime error has been fixed.

@taivlam Thanks for your feedback, fixed it.

So the previous build error is gone, but now Notesnook's UI opens up to a blank window. When I launch Notesnook through a terminal emulator, below is what I see in stdout. Is there a way to fix this error upon launch?

$ notesnook 
[9439:0415/114515.701591:ERROR:object_proxy.cc(576)] Failed to call method: org.freedesktop.DBus.Properties.Get: object_path= /org/freedesktop/portal/desktop: org.freedesktop.DBus.Error.InvalidArgs: No such interface “org.freedesktop.portal.FileChooser”
[9439:0415/114515.702178:ERROR:select_file_dialog_linux_portal.cc(291)] Failed to read portal version property
App ready. Opening window.
https protocol inteception "successful"
Intercepting request: https://app.notesnook.com/
unhandledRejection: Error:  (-2) loading 'https://app.notesnook.com/'
    at rejectAndCleanup (node:electron/js2c/browser_init:2:79183)
    at finishListener (node:electron/js2c/browser_init:2:79345)
    at WebContents.stopLoadingListener (node:electron/js2c/browser_init:2:79732)
    at WebContents.emit (node:events:519:28) {
  errno: -2,
  code: '',
  url: 'https://app.notesnook.com/'
}

The build error has been fixed, thank you!

@taivlam Thanks for your feedback, fixed it, will you please try again?

Below is the tail of stdout when I try to build this package. What can I do to fix this?

⚡ Done in 80ms
  • electron-builder  version=25.1.8 os=6.13.6-1-MANJARO
  • writing effective config  file=dist/builder-effective-config.yaml
  • executing @electron/rebuild  electronVersion=31.7.4 arch=x64 buildFromSource=false appDir=./
  • installing native dependencies  arch=x64
  • preparing       moduleName=better-sqlite3-multiple-ciphers arch=x64
  • finished        moduleName=better-sqlite3-multiple-ciphers arch=x64
  • completed installing native dependencies
  • packaging       platform=linux arch=x64 electron=31.7.4 appOutDir=dist/linux-unpacked
  • copying Electron  source=/usr/lib/electron31 destination=/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/dist/linux-unpacked
  ⨯ Application entry file "dist/cjs/index.js" in the "/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/dist/linux-unpacked/resources/app.asar" does not exist. Seems like a wrong configuration.  failedTask=build stackTrace=Error: Application entry file "dist/cjs/index.js" in the "/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/dist/linux-unpacked/resources/app.asar" does not exist. Seems like a wrong configuration.
    at error (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/asar/asarFileChecker.ts:7:12)
    at checkFileInArchive (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/asar/asarFileChecker.ts:31:11)
    at LinuxPackager.checkFileInPackage (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/platformPackager.ts:527:7)
    at LinuxPackager.sanityCheckPackage (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/platformPackager.ts:575:5)
    at LinuxPackager.doPack (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/platformPackager.ts:329:5)
    at LinuxPackager.pack (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/platformPackager.ts:138:5)
    at Packager.doBuild (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/packager.ts:459:9)
    at executeFinally (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/builder-util/src/promise.ts:12:14)
    at Packager.build (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/app-builder-lib/src/packager.ts:393:31)
    at executeFinally (/home/tai/AUR/notesnook/src/notesnook-3.0.32/apps/desktop/node_modules/builder-util/src/promise.ts:12:14)
==> ERROR: A failure occurred in build().
    Aborting...

@0hlov3 Thanks for your feedback, it's my mistake, fixed it.