Mind blowing SEO improving and Google rank increasing Signature Rotator SEO Tool.

Thread: 

got error while running query

Ads
lion Offline referral

Posts: 122
Joined: May 2014
Reputation: 0

#1
Member
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 ?
Heart
marcus_avrelius Offline referral

Posts: 2,424
Joined: May 2013
Reputation: 102

#2
Support Team
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
Guest referral

 

#3
Unregistered
Hi try this one:
PHP Code:
UPDATE mybb_users SET avatar 'images/avatars/invalid_url.gif' WHERE avatar '' 
lion Offline referral

Posts: 122
Joined: May 2014
Reputation: 0

#4
Member
Thanks for your help
Solved
Heart





User(s) browsing this thread: 1 Guest(s)