Post page blank!
-
June 8, 2022 at 3:30 pm #7558[anonymous]
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 4:54 am #7593[anonymous]Hi,
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:25 am #7596[anonymous]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 #7597[anonymous]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 #7599[anonymous]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 #7600[anonymous]This reply has been marked as private.June 17, 2022 at 8:05 pm #7601[anonymous]This reply has been marked as private.June 17, 2022 at 8:07 pm #7603[anonymous]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 11:02 pm #7605[anonymous]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 #7607[anonymous]@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:57 pm #7609[anonymous]Under sites directory you must find catalog with your website, and under input catalog you will find db.sqlite file to replace
August 1, 2022 at 6:12 pm #7931[anonymous]Hi @Tomasz,
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 #7936[anonymous]@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 #7954[anonymous]Hi @Tomasz
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 akawee
August 11, 2022 at 6:11 am #8036[anonymous]@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 #8056[anonymous]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.