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
Quote:
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'
|
Code:
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