Re-publish all records
4 posts by 3 authors in: Forums > CMS Builder
Last Post: July 26, 2016 (RSS)
By Toledoh - July 25, 2016
Hey Guys.
Is there a way to update all records in a section? I've made some changes to a site which produces a sitemap.xml.php and I need to update the time-stamp for all the pages...
Tim (toledoh.com.au)
By Damon - July 25, 2016 - edited: July 25, 2016
Hi Tim,
You could use the Developer Console Add On to replace all the current records Last Updated Date (updatedDate) to a current date.
http://www.interactivetools.com/add-ons/developer-console/
Make a full backup of the database first. Then run the MySQL Console from within the Developer Console with the mySQL command.
Will this work for you?
Damon Edis - interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
By Toledoh - July 25, 2016
That'll work Damon!
What would the command look like to do that for all records in the "posts" table?
Tim (toledoh.com.au)
By ross - July 26, 2016
Hi Tim
We don't support custom SQL like this in the forums.
What you are looking for, though, is and UPDATE statement that sets your timestamp field to "NOW()".
See what you can come up with and send through a support request if you have any further questions.
Thanks!
Cheers,
Ross Fairbairn - Consulting
consulting@interactivetools.com
Hire me! Save time by getting our experts to help with your project.
Template changes, advanced features, full integration, whatever you
need. Whether you need one hour or fifty, get it done fast with
Priority Consulting: http://www.interactivetools.com/consulting/