[CWM73]

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?!?!?

 

 

[Tomasz Dziuda]

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.

--
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!

[Tomasz 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?

--
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!

[CWM73]

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.

[Tomasz 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.

--
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!

[CWM73]

This reply has been marked as private.

[Tomasz Dziuda]

This reply has been marked as private.

[Tomasz 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?

--
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!

[CWM73]

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.

[Tomasz 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.

--
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!

[Tomasz Dziuda]

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

--
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!

[akawee]

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?

[Tomasz 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.

--
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!

[akawee]

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

[djx]

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

[Tomasz 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.

--
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