Re-publish all records

4 posts by 3 authors in: Forums > CMS Builder
Last Post: July 26, 2016   (RSS)

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?

Cheers,
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?

Cheers,

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/