[dilbert]

Originally Posted by dilbert

I have made no changes to my site. This morning it was working fine, now I get the same error.
Were able to resolve this issue?

Thanks

Originally Posted by Makc666

http://dev.mysql.com/doc/refman/5.1/...s_denied_error

This just means that user 'iwsgamin_iwsvb'@'localhost' can't use SELECT command.
Ask you hoster why.

Thanks, I asked my host and the default user does have SELECT.
If I run this query, it works fine.

SELECT *
FROM post_thanks AS post_thanks

If I add a little more back to the query and run this, it still works fine:

SELECT *
FROM post_thanks AS post_thanks
INNER JOIN vB36_user

When I try to run the full query, that's when I get the error.

SELECT *
FROM post_thanks AS post_thanks
INNER JOIN user AS user USING (userid)
WHERE post_thanks.postid IN (0,17834)
ORDER BY post_thanks.username ASC;

In particular, when I add this back, it gives me the permission error:

USING (userid)

I don't understand MySQL very well.
What is USING (userid) doing, and why is it now causing a permission error?

Thanks