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.

“no such column: xxxxx” error

July 10, 2023 at 10:01 pm #10286

[anonymous]

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

[anonymous]

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

[anonymous]

@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

[anonymous]

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

[anonymous]

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

[anonymous]

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