OK, found the issue: the problem arise when saving an article content by usinf Flexicontent, due to the fact FC doesn't save in NULL mode some empty fields. I have found this:
When you save an article using standrad Joomla 4 editor, there are some specific ##_content table fields saved by Joomla core component as NULL when empty (checked_out - checked_out_time - publish_up - publish_down). When you enable FC, those field ar saved filling the field with zeroed values, and this makes the other plugin non interpreting that value as correct)
This is a sample ##_content row when saving in Joomla mode and in FC mode, where you can see FC adds '0000-00-00 00:00:00' instead of adding NULL:
AS SAVED BY FC (not working):
Code:
(1197, 257, 'test', 'test', '<p>prova</p>', '', 1, 67, '2022-03-13 13:13:30', 150, '', '2022-03-27 11:06:31', 150, 0, '0000-00-00 00:00:00', '2022-03-13 13:13:30', '0000-00-00 00:00:00', '{\"image_intro\":\"images\\/giulio-andreotti-logo.jpg\",\"float_intro\":\"\",\"image_intro_alt\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"images\\/giulio-andreotti-logo-2.jpg\",\"float_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"image_fulltext_caption\":\"\"}', '{\"urla\":\"\",\"urlatext\":\"\",\"targeta\":\"\",\"urlb\":\"\",\"urlbtext\":\"\",\"targetb\":\"\",\"urlc\":\"\",\"urlctext\":\"\",\"targetc\":\"\"}', '{\"show_title\":\"\",\"show_intro\":\"\",\"article_layout\":\"\",\"link_titles\":\"\",\"show_tags\":\"\",\"info_block_position\":\"\",\"info_block_show_title\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"alternative_readmore\":\"\",\"article_page_title\":\"\",\"show_publishing_options\":\"\",\"show_article_options\":\"\",\"show_urls_images_backend\":\"\",\"show_urls_images_frontend\":\"\",\"show_print_icon\":\"\",\"show_email_icon\":\"\",\"show_editbutton\":\"\",\"show_deletebutton\":\"\",\"show_state_icon\":\"\",\"readmore\":\"\",\"comments\":\"\",\"automatic_pathways\":\"\",\"view_extra_css_fe\":\"\",\"view_extra_js_fe\":\"\",\"microdata_itemtype\":\"\",\"override_title\":\"\",\"custom_ititle\":\"\",\"addcat_title\":\"\",\"add_canonical\":\"\",\"ilayout\":\"\",\"__field43\":\"\",\"__field44\":\"\",\"__field45\":\"\",\"__field46\":\"\",\"__field47\":\"\",\"__field48\":\"\",\"__field49\":\"\",\"__field50\":\"\",\"ilayout_mobile\":\"\"}', 14, 1196, '', '', 1, 0, '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\",\"xreference\":\"\"}', 0, '*', ''),
AS SAVED BY JOOMLA (working)
Code:
(1197, 257, 'test', 'test', '<p>prova</p>', '', 1, 67, '2022-03-13 13:13:30', 150, '', '2022-04-16 09:02:58', 150, NULL, NULL, '2022-03-13 13:13:30', NULL, '{\"image_intro\":\"images\\/giulio-andreotti-logo.jpg\",\"image_intro_alt\":\"\",\"float_intro\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"images\\/giulio-andreotti-logo-2.jpg\",\"image_fulltext_alt\":\"\",\"float_fulltext\":\"\",\"image_fulltext_caption\":\"\"}', '{\"urla\":\"\",\"urlatext\":\"\",\"targeta\":\"\",\"urlb\":\"\",\"urlbtext\":\"\",\"targetb\":\"\",\"urlc\":\"\",\"urlctext\":\"\",\"targetc\":\"\"}', '{\"article_layout\":\"\",\"show_title\":\"\",\"link_titles\":\"\",\"show_tags\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"info_block_show_title\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_hits\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"alternative_readmore\":\"\",\"article_page_title\":\"\",\"show_publishing_options\":\"\",\"show_article_options\":\"\",\"show_urls_images_backend\":\"\",\"show_urls_images_frontend\":\"\"}', 15, 1196, '', '', 1, 0, '{\"robots\":\"\",\"author\":\"\",\"rights\":\"\"}', 0, '*', ''),
I have simply edited in phpmyadmin the 4 wrong fields, setting their values to NULL, and it worked for me.
Could you please verify this and provide a fix asap?
Thank you in advance.
Regards[/code]
