Stuck on "Update temporary item data" (post installation)

Hi there,

[problem]
I am stuck on a loop of "Update temporary item data" post installation messages, when I want to enter backend > content items.
I have a freshly installed website under development.

[setup]- Joomla! 4.2.3
- FC 4.1.3   Release date: 2022-09-13
- php 8.0.23
- sql 8.0.30

[what I tried already]
- FC > post-installation > clicked on "update"
- Joomla > cleared all caches
- akeeba admin tools > purged all sessions

[what happend before]
- Last night I did not save a started new content item, and I did not log out of Joomla.

[EDIT: sql-info]Database Collationutf8mb4_unicode_ciDatabase Connection Collationutf8mb4_unicode_ci

just deconnect ... clean cache and reconnect ... sometime need a little time or try an other browser

micker wrote:

just deconnect ... clean cache and reconnect ... sometime need a little time or try an other browser
 

I cleared all caches, logged out, waited 1 day, logged in. The error is still there.
Same on a freshly installed Chrome (not addons), and Edge.
This is a fresh joomla 4.2.3 installation.
 

hello is it online send me a link to test ?

micker wrote:

hello is it online send me a link to test ?
 

Yes, it's online and in dev-mode. I made you a super user and pm'd you.
Thanks a lot for having a look!

hello
can you test and repair your table via phpmyadmin ? like this topic : www.flexicontent.org/forum/21-troublesho...item-data.html#75655

micker wrote:

hello
can you test and repair your table via phpmyadmin ? like this topic : www.flexicontent.org/forum/21-troublesho...item-data.html#75655
 

Ok, good and bad news:

Good news: I solved the 'post-installation-screen' like so:
1)  In phpmyadmin, I manually compared tables '_content' and '_flexicontent_items_tmp'.
All my items have no publish_down date, so table '_content' -> field 'publish_down' was NULL in all rows.
But table '_flexicontent_items_tmp' -> field 'publish_down' had '0000-00-00 00:00:00'.
Neither of those values were accepted by my db, so I entered ~today ('2022-09-30 00:00:00') in both tables, all rows. That fixed the screen.

Bad news: Now all my items are published down. A CMS-user can not change that, because the above mentioned publish_down date can not be removed via CMS.

you can select all item and use change state ?

micker wrote:

you can select all item and use change state ?
 

Nope, No effect when I try, and the message "0 records changed to Published".

you have a problem in your bdd ...
try change state of content via phpmyadmin (published is state 1)