Thread

I’d like to set the edit_date of a specific comment (comment_id is known) in exp_comments. I try this, for example:

{exp:query sql="UPDATE exp_comments SET edit_date=NOW() WHERE comment_id='6'"}{/exp:query}

..and the entry_date for comment_id 6 does not get set to NOW() (I’m looking in phpMyAdmin, and refreshing the view of course). The above code is on its own in a template, and I’m simplying viewing the rendered template to run the query.

Any ideas what I’m doing wrong?

For security reasons, the query module only supports SELECT statements, UPDATE or DELETE queries will be ignored.

For security reasons, the query module only supports SELECT statements, UPDATE or DELETE queries will be ignored.

Ah, ok, I’ll write a quick plugin for it then. Thanks Ingmar.