Download
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.

Error creating 1st site – database issue

  • #11344
    Avatar photo[anonymous]

    Just installed Publii on a Linux machine using apt.  There is no real-time antivirus software running.

    Upon attempting to create the first website the error, below, was returned.

    Publii did create the new site directory and subdirectories.

    An error occurred during site database creation. Please check your antivirus
    software and try again. You can also need to remove the invalid website’s folder from the Publii sites directory.

    Any suggestions are most welcome.

    #11348
    Avatar photo[anonymous]

    Hi,

    Do you have the same issue during creating any new websites?

    Or only for the first website?

    The website directories contains any files?

    #11354
    Avatar photo[anonymous]

    Hello Tomaz,

    Thanks  for your reply.

    The same issue and error message is returned when attempting to create a second or third website.

    Attempts to create a second and third site resulted in the same error.

    Website directory is creates.  Some of those directories also have initial files generated.

    The ../input/config has the following files created:

    site.plugins.json
    menu.config.json
    theme.config.json

    The above files have a contents of:  {}

    site.config.json contains:

    {
        "uuid": "uuid-1703153118239-779535752",
        "name": "second-site",
        "displayName": "Second site",
        "logo": {
            "icon": "web-pizza",
            "color": 1
        },
        "theme": "simple"
    }

    These directories are empty:

    ../languages
    ../media
    ../root-files

    The ../input/config/themes directory has files for the ‘simple’ theme installed and totals ~4.9M.

    The following directories are also empty:

    ../output
    ../preview

    #11376
    Avatar photo[anonymous]

    Could you try to run the app through CLI? And then check if you have any lines starting with “DB error”?

    #11391
    Avatar photo[anonymous]

    It appears the best move is upgrading from LMDE5 to LMDE6 in order to have the latest GLIBC installed.  Will upgrade and run Publii again.

    Thanks Tomasz

    DB error Error: /lib/x86_64-linux-gnu/libc.so.6: version `GLIBC_2.33' not found (required by /opt/Publii/resources/app.asar.unpacked/node_modules/better-sqlite3/build/Release/better_sqlite3.node)
    #11392
    Avatar photo[anonymous]

    We will release soon v.0.44.2 which uses WASM sqlite3 implementation, which does not require native module so it will also solve this issue 🙂

    #11393
    Avatar photo[anonymous]

    Cheers Tomasz!  Good news.  There rarely seems to be a good time for a major OS upgrade even with LMDE (and Mint) being well behaved.  🙂

    Nothing pressing on the web editing front now so I’ll wait until there’s a comfortable amount of time to do the entire backup and system upgrade routine … safely.  🙂