Help with "Execute SQL Query"

[TeddyKGB]

I am trying to run a custom SQL in the AdminCP panel to clear out some specific rows from my moderator log. Basically I have a hidden dump forum where all the news feeds go and I use that to selectively move the ones I want users to see. However when I run the below code I get the following error message

An error occurred while attempting to execute your query. The following information was returned.
error number: 1142
error desc: DELETE command denied to user 'XXXXXXXXX@'localhost' for table 'moderatorlogid'

DELETE vb_moderatorlog.moderatorlogid, vb_moderatorlog.dateline, vb_moderatorlog.userid, vb_moderatorlog.forumid, vb_moderatorlog.threadid, vb_moderatorlog.postid, vb_moderatorlog.pollid, vb_moderatorlog.attachmentid, vb_moderatorlog.action, vb_moderatorlog.type, vb_moderatorlog.threadtitle, vb_moderatorlog.ipaddress
FROM vb_moderatorlog
WHERE (((vb_moderatorlog.userid)="1") AND ((vb_moderatorlog.forumid)="74") AND ((vb_moderatorlog.type)="15"));

Is there something I am doing wrong in my query? I can run the canned queries no problem. Thanks

[Dismounted]

The MySQL user you specified in config.php cannot execute DELETE commands. Basically, it means your MySQL user doesn't have the permission to delete.

[Marco van Herwaarden]

Try:

[sql]DELETE FROM vb_moderatorlog
WHERE (((vb_moderatorlog.userid)="1") AND ((vb_moderatorlog.forumid)="74") AND ((vb_moderatorlog.type)="15"));[/sql]

[TeddyKGB]

Marco- that worked! Thanks,