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.

SQLite3 can only bind numbers, strings, Buffers and null at

  • #2951
    Avatar photo[anonymous]

    When clicking “Save & Close” or “Save”, this error occurs.

    It happens for 1 specific post, not all posts.

    Here is my website input folder. Please check the hidden post called “In Memoriam”:

    Avatar photo[anonymous]

    Have you been able to reproduce the issue?

    Avatar photo[anonymous]

    Are you making any progress here please? I noticed that this is affecting MOST of my posts and rendering Publii totally unusable. I’m going to have to revert to an older version.

    Avatar photo[anonymous]

    I reverted to version 0.35.3 and now no longer experiencing issues. There must be something in the new version which is causing problems.

    Avatar photo[anonymous]

    Hi Mathias,

    Your issue is as I suppose connected with fact that you have did some manual work in the database. In the post table for the “template” column you have null values  instead of empty strings. This leads to the problem.

    Avatar photo[anonymous]

    Thanks Tomasz. This is a website I migrated and it could be that I initially loaded the posts using SQL, indeed. I will reinstall the newest version and see if I can fix it.

    Avatar photo[anonymous]

    The problem is solved!