Remove article expiration date multiple articles

General questions relating to Joomla! 4.x.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting.
Forum Post Assistant - If you are serious about wanting help, you should use this tool to help you post.
Windows Defender SmartScreen Issues <-- please read this if using Windows 10
Post Reply
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Fri Feb 19, 2010 3:03 pm

Remove article expiration date multiple articles

Post by hittolo1 » Mon Nov 20, 2023 4:49 pm

i have around 400 article published but expired. How can i remote that and re - publish all article?

User avatar
Joomla! Master
Joomla! Master
Posts: 28159
Joined: Wed Aug 13, 2008 2:57 am
Location: Chennai, India

Re: Remove article expiration date multiple articles

Post by imanickam » Mon Nov 20, 2023 8:48 pm

If you want to re-publish all the articles, you could make use of SQL to accomplish what you want.

The following SQL would re-publish all the articles. xyz_ is the database/table prefix for your site.

Code: Select all

UPDATE `xyz_content` SET `publish_down` = NULL;
This could be accomplished using tools such as phpMyAdmin.

If needed, you could add WHERE clause to the SQL statement if only certain rows that meet specific criteria are to be affected.

(a) Test this in a development/test environment before making changes to the production site's database.
(b) Be aware that this SQL does not update the publish date of the articles. The date of publishing is stored in the column publich_up.
Ilagnayeru (MIG) Manickam | இளஞாயிறு மாணிக்கம்
Joomla! - Global Moderators Team | Joomla! Core - Tamil (தமிழ்) Translation Team Coordinator
Former Joomla! Translations Coordination Team Lead
Eegan - Support the poor and underprivileged

Post Reply

Return to “General Questions/New to Joomla! 4.x”