MyBB Community Forums

Hello everyone,

I read this thread: http://community.mybb.com/thread-90299.html

However, I've never really used PHPMyAdmin, so I'm not sure if what I will do is right or wrong.

Could anyone explain where exactly to click and run the query? I've clicked on the 'Query' tab up the top. Would I then just submit the query in that textfield box?

Yes, just insert the query inside the text box and hit submit or I believe run but remember to select your database then click the query option on the top and then run the query.

It has an error saying "You have to choose at least one column to display"

My bad. You have to click on SQL after you select your database then run the query. I've provided a screenshot below

Screenshot: http://puu.sh/3IuOK.png

This query will set the avatar of the user with the ID of 1 to an image at the following location:

Image Location (change the location to suit your needs)

images/avatars/default.png

Query to change user ID 1

UPDATE `mybb_users` SET `avatar`= "images/avatars/default.png" WHERE `uid` = "1"

If you want to set all users with the same avatar run this query:
Query to change ALL USERS

UPDATE `mybb_users` SET `avatar`= "images/avatars/default.png" WHERE `uid`