Post page blank!
- This topic has 19 replies, 5 voices, and was last updated 1 month, 2 weeks ago by .
June 8, 2022 at 3:30 pm #7558CWM73
Today my Posts page mysteriously went blank! I have another Publii site, which works, but this specific one has disappeared! Maybe is a corrupted preferences file? But I have no idea. Has this happened to anyone else? How can I solve it?!?!?June 17, 2022 at 12:37 am #7588kradeelav
A shame, as I really loved what this CMS is on paper. Maybe I’ll try it again in a few years.June 17, 2022 at 4:54 am #7593Tomasz Dziuda
Seems to be some JS issue while generating posts view. To debug this – please go to the app settings and under developer options please enable option to open Dev Tools with main window. Then restart the app, navigate to posts view and check if the dev tools do you get some JS errors.
Later you can disable dev tools option to avoid two windows opening while opening Publii app.June 17, 2022 at 5:06 am #7594kradeelav
Thank you for replying! Just did as you instructed, Tomasz, and screenshotted the devtools part. I don’t know enough about coding to decipher it, but hope it’s useful for debugging in the future, and happy to take more screenshots / be a monkey if needed.June 17, 2022 at 5:25 am #7596Tomasz Dziuda
Do you have the same error if you open the app then go to the site settings and come back to the posts view?June 17, 2022 at 2:32 pm #7597CWM73
Here’s my error, for both the Posts and Author view. And I opened the app, went to site settings, then came back to Post view and got the same error.June 17, 2022 at 4:58 pm #7599Tomasz Dziuda
Could you sent me in a private reply backup of your website with this issue? I thought that it was some race condition, but if it is repeatable issue after initial page load I think that there is a different reason of this problem and I need backup to try reproduce this issue on my local installation.June 17, 2022 at 6:55 pm #7600CWM73This reply has been marked as private.June 17, 2022 at 8:05 pm #7601Tomasz DziudaThis reply has been marked as private.June 17, 2022 at 8:07 pm #7603Tomasz Dziuda
CWM73 – the problem is connected with fact that one of your posts is almost fully filled with NULL values. Do you remember what you did before the problem occurred?June 17, 2022 at 9:56 pm #7604kradeelavThis reply has been marked as private.June 17, 2022 at 11:02 pm #7605CWM73
Thanks so much, Tomasz, I’ll replace it. And I figured out where the error was. I created a new post, then I created a new Menu Item. It added it to the bottom of the Menu Items, as expected, then I dragged it up into the sub-menu. Then I previewed it and there were identical menu items both in the sub-menu and as the last item in the main list. And when I would delete one, both would be deleted. That’s when everything when messy.
And I really like Publii, thanks so much for making it! I’m an old-school web designer, and I learned way back in 1993 (!). I’ve taken a bit of time off from making websites, and I wanted a way back in that was easy yet flexible, and Publii does the trick.June 18, 2022 at 6:18 pm #7607Tomasz Dziuda
@kradeelav – I have attached in your private reply fixed DB file – please just replace db.sqlite in your input/ catalog with the attached one.
I will look for a possible reasons why these empty posts appears, but at this moment I do not see any obvious reason. So the current (temporary) solution for this bug is manually edit posts table and remove the posts with NULL values.June 18, 2022 at 7:44 pm #7608kradeelav
Thank you, Tomaz! Just wondering how I would go about doing that? Is there a folder or page I need to look for to insert the db file?June 18, 2022 at 7:57 pm #7609Tomasz Dziuda
Under sites directory you must find catalog with your website, and under input catalog you will find db.sqlite file to replaceAugust 1, 2022 at 6:12 pm #7931akawee
I have the same problem, do you need my sqlite database or can I find the NULL post myself and delete it from the database?August 2, 2022 at 10:33 am #7936Tomasz Dziuda
@akawee – in fact you can backup your website, and then open the sqlite database in any SQLite editor and remove all rows on the posts table which mostly contains NULL values – it should fix the problem.
BTW – do you remember when the error started to occur? In fact I am still unable to reproduce it on my local instance.August 3, 2022 at 11:53 am #7954akawee
Thank you very much it worked. Unfortunately I do not know what I did. It may have been a menu entry but I am not sure. I’ll make a backup and work on the website if it occurs again I’ll let you know. Funny thing is that the two entries were in the middle of an import from a wordpress instance.
cheers akaweeAugust 11, 2022 at 6:11 am #8036djx
@Tomasz – I just had this issue as well. The only thing I did was import a backup from WordPress.August 13, 2022 at 2:36 pm #8056Tomasz Dziuda
Thanks for the feedback – in the next version we will fix this issue – just by ignoring posts which contains too much null values in DB.
- You must be logged in to reply to this topic.