(2017-09-19, 12:46 PM)WallBB Wrote: [ -> ]DVZ, I have found an issue with this plugin, if I use the feature "• Assign avatars to users with no avatar" when member count is greater than 50k, I see the page getting timed out. Is there any reason for that ?
Each user is updated with a separate query as the plugin fills some variables and generates a random identifier, but you can try doing this operation in database only - MySQL/MariaDB:
UPDATE `mybb_users`
SET
`avatar` = CONCAT('https://secure.gravatar.com/avatar/', MD5(RAND(10)), '?s=100|100&d=identicon&f=y'),
`avatartype` = 'gravatar',
`avatardimensions` = '100|100'
WHERE `avatar` = ''
For PostgreSQL/SQLite change
RAND to
random.
Users without avatars will be assigned 100x100
identicon ones.
Remember to backup the table beforehand.
Hi DVZ,
I am using this plugin on my forum but it is not setting random avatars.
Link of a thread for reference
https://wallbb.co.uk/forums/Thread-Focus...le-problem
Can you tell me what might be the problem ?
I am using latest version from MyBB Mods
Regards
WallBB
(2017-11-09, 11:34 AM)WallBB Wrote: [ -> ]Hi DVZ,
I am using this plugin on my forum but it is not setting random avatars.
Link of a thread for reference
https://wallbb.co.uk/forums/Thread-Focus...le-problem
Can you tell me what might be the problem ?
I am using latest version from MyBB Mods
Regards
WallBB
Does
Assign avatars to users with no avatar have any effect? Does the issue affect other places, e.g. profiles?
(2017-11-10, 04:33 PM)Devilshakerz Wrote: [ -> ] (2017-11-09, 11:34 AM)WallBB Wrote: [ -> ]Hi DVZ,
I am using this plugin on my forum but it is not setting random avatars.
Link of a thread for reference
https://wallbb.co.uk/forums/Thread-Focus...le-problem
Can you tell me what might be the problem ?
I am using latest version from MyBB Mods
Regards
WallBB
Does Assign avatars to users with no avatar have any effect? Does the issue affect other places, e.g. profiles?
Yes, it has not affect.
Also I don't see the random avatar in other places for example :- memberlist, profile, pm
Also I have removed memberlist.
Does it work after removing an avatar from the ACP with the plugin activated?
Do/did you have any other plugins installed related to default avatars?
Is the avatar column empty in the mybb_users table for affected users?
(2017-11-10, 05:39 PM)Devilshakerz Wrote: [ -> ]Does it work after removing an avatar from the ACP with the plugin activated?
Do/did you have any other plugins installed related to default avatars?
Is the avatar column empty in the mybb_users table for affected users?
1. No
2. No
3. I do see avatar changed in the users table but not in the forums.
Regards
WallBB
(2017-11-10, 05:53 PM)WallBB Wrote: [ -> ]3. I do see avatar changed in the users table but not in the forums.
Can you share some example values of
avatardimensions,
avatartype columns from rows in which avatars are set?
Is the
Profile Options → Allow Remote Avatars setting enabled?
(2017-11-10, 07:44 PM)Devilshakerz Wrote: [ -> ] (2017-11-10, 05:53 PM)WallBB Wrote: [ -> ]3. I do see avatar changed in the users table but not in the forums.
Can you share some example values of avatardimensions, avatartype columns from rows in which avatars are set?
Is the Profile Options → Allow Remote Avatars setting enabled?
Ah, that was the issue.
I am sorry for raising this, thanks DVZ
Hallo guys,
in my case it shows only a white avater after i press Assign avatars to users with no avatar
any solutions for that?
grats
Duelist