I need to change the following widgetsets:
2column_layout_sidebar
3column_layout_primary_sidebar
3column_layout_secondary_sidebar
Manually doing this via the MT admin section for every blog is extremely slow.
I've tried editing them in the database, but it doesn't seem like MT actually uses the contents of the database.
Say I wanted to blank the 2column_layout_sidebar for all blogs, if I run this in the database, the records update, but the changes are not reflected in the MT admin section... which is very odd because if you change the widgetset in the MT admin area the database is updated to reflect the changes...
UPDATE mt_template
SET template_text = ''
WHERE template_identifier='2column_layout_sidebar';
How can I edit the 2column_layout_sidebar for every blog, without having to go through them one by one.
Reported on Movable Type 4.2
You could surely do it by connecting to the database with a tool like phpmyadmin and then running an SQL command over it.
As for the exact SQL command, you would have to figure it out yourself. It is just a matter of spending a little time on it.
Always make sure to backup your database before making any changes to it so that you could roll back if you damage something by accident.
Kind Regards,
Mihai Bocsaru
----------------------------------
Daily Movable Type Consultant
Web Development
Movable Type Consulting
Six Apart Partner
http://www.pro-it-service.com/
----------------------------------
Movable Type Demo
http://www.movabletypedemo.org/
----------------------------------
Open Melody Demo
http://www.openmelodydemo.org/