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.

SQLite3 can only bind numbers, strings, Buffers and null at Post.save

  • #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”:

    https://ln2.sync.com/dl/65d5245d0/2xxitw8p-7xtw4y8e-2c4gzsxp-iymnjnkh

    #2984
    Avatar photo[anonymous]

    Have you been able to reproduce the issue?

    #2993
    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.

    #2994
    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.

    #3038
    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.

    #3050
    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.

    #3061
    Avatar photo[anonymous]

    The problem is solved!