got error while running query

Hello
when I run this query to set a default avatar for my users :

Code:

UPDATE `mybb_users` SET `avatar` = 'images/avatars/invalid_url.gif' WHERE `avatar` = ''

I got this error in avatar gallery :

Code:

Warning [2] opendir(images/avatars/invalid_url.gif) [function.opendir]: failed to open dir: Not a directory - Line: 2016 - File: usercp.php PHP 5.3.28 (Linux)

and now I can't access to gallery

would you help me ?

Find

Reply

Hi what is this some kind of plugin? The query appears to be OK I need to see the rest of the code? Bad query will return: "You have an error in your SQL syntax"

Are you talking about PHPmyadmin here?

Try this query:

PHP Code:

UPDATE mybb_users SET avatar = 'images/default_avatar.gif' WHERE avatar = ''; 


Make sure this image exists!!!!!!!! images/default_avatar.gif

Find

Reply

Hi try this one:

PHP Code:

UPDATE mybb_users SET avatar = 'images/avatars/invalid_url.gif' WHERE avatar = '' 


Reply

Thanks for your help
Solved

Find

Reply