Sign in

“no such column: xxxxx” error

Forum › General Inquiry

  • This topic has 5 replies, 3 voices, and was last updated 2 months ago by .
Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • July 10, 2023 at 10:01 pm #10286
    Avatar photosugimoto

    I’m using the theme “portfolio” and perhaps there is an issue with the theme, but all of a sudden, I’m getting this rendering process failed error, and says no such column: xxxx (where xxxx is the name/title of a post).  If I hide the post, it previews fine.

    I’ve deleted all posts, and remade them, and it previews, but then, every now and then, it shows this error when I haven’t honestly done any changes..

    https://snipboard.io/Mb1Z6q.jpg

     

    Seems like it is a database error but the column in question exists when you check the SQL file… Help!

    July 11, 2023 at 1:35 pm #10289
    Avatar photosugimoto

    UPDATE:
    So I realised that when you select front page post order by title, it fails to process. But if by date, it seems to render fine…any tips?

    July 11, 2023 at 9:36 pm #10291
    Avatar photoitips3727

    @sugimoto

    Can you provide some details about your Publii installation? For example, your Publii version, your computer operating system and version numbers. Presumably, you’re using Portfolio v1.4.1.0, yes? Also, perhaps check if there is an entry for your error in ‘Log viewer’ in ‘Tools & Plugins’.

    July 12, 2023 at 9:34 am #10292
    Avatar photosugimoto

    Hi, latest publii version, and mac os, no other errors.  If I goto post order and select by name, it results in the ‘no column’ error.  If I do by post id, it works fine, so I adjusted the sequence of adding my posts.

    July 12, 2023 at 9:25 pm #10296
    Avatar photoitips3727

    Looks like a bug (at least when using MacOS): Maybe some updates are needed.

    Steps to reproduce for Portfolio theme v1.4.1.0 with Publii v: 0.42.1 (build 16233):

    Site Settings > Advanced options > Posts Listing > then in ‘Posts order by:’ choose ‘Post title’.

    Any other choice doesn’t seem to generate the error you mention. So ‘Post creation date’, ‘Post modification date’, and ‘Post ID’ display preview normally without the error.

    Can @Bob or @@Tomasz Dziuda check it out?

    July 23, 2023 at 11:16 pm #10364
    Avatar photoTomasz Dziuda

    Ok, finally I was able to reproduce this issue – this seems to be a Portfolio theme related issue, because it not occur on all themes. I will deeper investigate what is a reason in this case next week

    --
    Do you appreciate the support you've received today? If so, consider donating to the Publii team by clicking here; we'll be sure to use your donation to make Publii even better!

  • Author
    Posts
Viewing 6 posts - 1 through 6 (of 6 total)
  • You must be logged in to reply to this topic.