By dylan_thomas on

As many have pointed out, RM works great with nodes created after it's installation.

What can I do to let the few hundred existing nodes work as well?

One thing I have tried, which did not work, was manually adding nodes to the revision_moderation table with revision #0 (which seems to be what RM does with new nodes.)

I suspect there is some other SQL magic that I'm missing. Can anyone help?

⋅ Categories: Drupal 6.x

Comments

dylan_thomas’s picture

dylan_thomas commented

What I ended up doing which worked was exporting a list of node ids and then building SQL queries around them to put them at "revision 0"

INSERT INTO revision_moderation (nid, revision_moderation) VALUES ( X , 0);

(in this query, substitute the node id for X)

inaxio’s picture

inaxio commented

You can do it whith one query:

REPLACE INTO revision_moderation SELECT nid, 1 FROM node WHERE type IN ("page", "story")