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.

Post page blank!

  • #7558
    Avatar photo[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?!?!?

    #7593
    Avatar photo[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.

    #7596
    Avatar photo[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?

    #7597
    Avatar photo[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.

    #7599
    Avatar photo[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.

    #7600
    Avatar photo[anonymous]
    This reply has been marked as private.
    #7601
    Avatar photo[anonymous]
    This reply has been marked as private.
    #7603
    Avatar photo[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?

    #7605
    Avatar photo[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.

    #7607
    Avatar photo[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.

    #7609
    Avatar photo[anonymous]

    Under sites directory you must find catalog with your website, and under input catalog you will find db.sqlite file to replace

    #7931
    Avatar photo[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?

    #7936
    Avatar photo[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.

    #7954
    Avatar photo[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

    #8036
    Avatar photo[anonymous]

    @Tomasz – I just had this issue as well. The only thing I did was import a backup from WordPress.

    #8056
    Avatar photo[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.