No Code Attached Yet bug
avatar oorzaak
oorzaak
22 Nov 2021

In specific circumstances the publish_down date is not removed correctly. This involves both one or more Joomla core tags being assigned to the article and the version management being engaged.

Steps to reproduce the issue

  • Engage version management for articles
  • Create one tag in com_tags
  • Create an article and assign one tag to this article
  • Make the article featured
  • Save the article
  • Create a menu item of the Featured Articles type
  • Create a menu item of the Tagged items type, pointing at the tag as assigned to this article
  • Check that you can see the article on both menu items indeed
  • Set the Finish publishing date of the article to a date in the past and save the article
  • Check that you cannot see the article on either menu item
  • Remove the Finish publishing date from the article and save
  • Notice that the article will appear again on the Featured articles menu item, but not on the Tagged items menu item.
  • If you check in the database, in the content table the publish_down date is set to NULL but in the ucm_content table the date is still present in the core_publish_down field
  • When removing the date from the ucm_content table using PhpMyAdmin, you’ll get a warming: #1265 Data truncated for column 'core_publish_down' at row 1 This results in the field containing “0000-00-00 00:00:00” instead of NULL
  • The article is being displayed again on the Tagged items menu item.

Expected result

  • When removing the Finish publishing date from the article, I expect the article to be displayed on the Tagged items menu item

Actual result

  • When removing the Finish publishing date from the article, the article will not be displayed on the Tagged items menu item unless you remove it’s core_publish_down date from the ucm_content table.

System information (as much as possible)

  • Joomla 404
  • PHP 7.4.25 / mysql 5.7.32-35-log and, on another hosing:
  • PHP 7.3.31 / mysql 5.6.27

Additional comments

  • When changing the date instead of removing it, this is processed correctly.
  • I noticed that, when removing the tag from the article, the records from the ucm_content and ucm_base tables for this article are removed completely. It is beyond my knowledge to know if this is normal behavior or not, yet I thought I should mention it.
  • Thanks to Roland D for finding out what happened in the database.
avatar oorzaak oorzaak - open - 22 Nov 2021
avatar oorzaak oorzaak - change - 22 Nov 2021
Labels Removed: ?
avatar joomla-cms-bot joomla-cms-bot - change - 22 Nov 2021
Labels Added: No Code Attached Yet
avatar joomla-cms-bot joomla-cms-bot - labeled - 22 Nov 2021
avatar richard67
richard67 - comment - 23 Nov 2021

When removing the date from the ucm_content table using PhpMyAdmin

@oorzaak Could you explain that step more detailed? What means removing the date?

avatar oorzaak
oorzaak - comment - 24 Nov 2021

I mean that, in the field core_publish_down I try to replace the date with NULL or make it totally empty. The result of both actions is that the field is filled with "0000-00-00 00:00:00" and I get the warning.

The first thing I tried was to replace the date with NULL, as that is what I see in this field for articles that never had a Finish Publishing date. Because of the warning I also tried making it empty.

Although the result is not the same as the other articles, the article is displayed in the Tagged items menu item.

avatar Hackwar Hackwar - change - 22 Feb 2023
Labels Added: bug
avatar Hackwar Hackwar - labeled - 22 Feb 2023

Add a Comment

Login with GitHub to post a comment