Posted by rotnme on May 13, 2010 at 2:29am
I have set up a testimonials page which, in theory, would allow clients to post a recommendation of my company and the work that was performed. My question, how do I make the page/node writeable by visitors to post their review while keeping their post subject to administrative approval. Thanks in advance. Also, my prior issues are still unresolved, 1045 error/node revision table. Any thoughts on those issues are also appreciated.
Comments
You could use comments
Enable comments on the node type and then give authenticated users (if you want your clients to log in) or anonymous (if otherwise) the "post comments" permission and NOT post comments without approval. Any comments posted to the site will go to the comment administration queue. I suggest doing this in conjunction with Mollum or reCaptcha.
As far as your db problems go, I'm pretty convinced whatever method you're doing for import/export either isn't exporting your table data or isn't importing it. Getting a full db dump out of phpMyAdmin isn't as straightforward as it should be IMHO. That's why I use mysqldump and mysql commandline to handle this sort of thing.
Workflow
I would also suggest the same thing about using comments for your testimonials. If, however, you need your testimonials to be nodes for any reason, you might want to take a look at the Workflow module: http://drupal.org/project/workflow
+1 Workflow.
+1 Workflow.