Your suggestion for unchecking the “promoted to” will prevent all future content of that type to not be promoted to the front page, but will not clear all existing content of that type from being shown on the front page.
The node table has a column named “promote” that has it’s value set to “1” when a node is promoted to the front page. To “bulk clear” a number of nodes without having to go to each node individually and removing the “promoted to front page setting”, a simple SQL statement could be used, for example:
UPDATE node SET promote = 0 WHERE type = '[desired content type]' and promote = 1
So, to clear all content of type “story” from being promoted to the front page, the SQL would be:
UPDATE node SET promote = 0 WHERE type = 'story' and promote = 1
Hope this helps clarify…
As always, users are urged to test on their test ( sandbox ) first, and to make a database backup before running any SQL statements against their production database…
Comments
go to
go to yoursite/admin/content/types and uncheck the Promoted to Front Page in the Workflow settings box.
~silverwing
_____________________________________________
MisguidedThoughts
Your suggestion for
Your suggestion for unchecking the “promoted to” will prevent all future content of that type to not be promoted to the front page, but will not clear all existing content of that type from being shown on the front page.
The node table has a column named “promote” that has it’s value set to “1” when a node is promoted to the front page. To “bulk clear” a number of nodes without having to go to each node individually and removing the “promoted to front page setting”, a simple SQL statement could be used, for example:
UPDATE node SET promote = 0 WHERE type = '[desired content type]' and promote = 1So, to clear all content of type “story” from being promoted to the front page, the SQL would be:
UPDATE node SET promote = 0 WHERE type = 'story' and promote = 1Hope this helps clarify…
As always, users are urged to test on their test ( sandbox ) first, and to make a database backup before running any SQL statements against their production database…
Well, I actually fixed it by
Well, I actually fixed it by demoting all promoted content using the promoted filter in content, but thanks for the tip.