Quick Moderation Modules

[Mysterious Ride]

Hello,

I'm having a bit of a problem with the Quick Moderation Modules. Its not really serious, but I was wondering if anyone could help me figure out how to fix it. For some reason it always says that there's two post that needs to be moderated, but then you click on it and there isn't any post. Its been like that for a while now. I'd really appreciate it if someone helped me with this.

[Brian]

http://www.vbadvanced.com/forum/show...ick+moderation

[Mysterious Ride]

Sorry, but I still don't understand exactly what I should do. I've looked everywhere for what's talked about in that thread, but I can't find exactly what I'm suppose to do. You said Delete from Moderation and that you can do it from either Execute SQL Query withing vba CP or in phpmyadmin for the Moderation table. I'm not sure how to do either of these things.

I have Execute SQL Query under Maintenance, but when I click on it it says that I am not authorized to execute SQL queries. Could you please explain to me a little more at how to go about doing either way to fix this problem.

[Brian]

http://www.vbulletin.com/docs/html/m...ntenance_query

[Mysterious Ride]

I've tried going to Maintenance > Execute SQL Query, but it keeps saying that I am not authorized to execute SQL queries. Is there something I have to do to make it so that it lets me do it?

[Brian]

That's explained in the link I posted above, in the second box with the bold "Note" heading.

[Mysterious Ride]

I'm sorry. I know I'm probably getting on your nerves, but its still not working and I don't know what I'm doing wrong. I edited the config.php file by just putting in the #1... $config['SpecialUsers']['canrunqueries'] = '1'; I saved it and uploaded it to my server and overwritten the old file so that it has the edited data, but it still says that I am not authorized to execute SQL queries. I've read through everything and still can't figure out what I could be doing wrong.

[Brian]

Are you sure that 1 is your userid on the site? As long as you have the correct userid entered then there shouldn't be any reason you can't execute queries. If you're not sure of what your userid is, just go to a page like the 'Forum Leaders' link on your site, hold your mouse over your username, and you'll see your userid in your browsers status bar at the end of the URL.

[Mysterious Ride]

Yeah, I'm positive. I'm the first member and it says it when I look at the end of my profile url as well as a lot of the things that I do in the ACP. Could there be something else that's stopping me from being able to do queries?

[Brian]

There shouldn't be anything else necessary to run queries. If it's not working then the best thing I can suggest would be to ask in the vBulletin.com support forums.