@luc@UnderDog That's an unrelated issue with the vf.org theme that'll hopefully get sorted soon.
Yep, that would be good, because not having time to come often lately, I don't know what I've read or not, so basically I don't read anything, hence I don't reply :).
Since it doesn't look like it's in this release, any chance of a fix coming to either all the activity queries or a way to flat out disable all usage of the activities tables soon? Not using indexes to query a table with over 4million rows and the slow queries locking up mysql for 30-240s is pretty unbearable.
If I just nightly empty out the Activity table, will that horrible break vanilla? I see no other solution at this time.
No, I want to disable activity entirely. I pulled that commit out awhile, that fixed only one or two queries. The global activity page is also pretty bad, I removed any links in my theme to it to fix that as well. In general usage of the site there are still queries hitting the activity table, and rather slowly at that. It's really the only source of entries in my mysql slow query log.
@Lincoln the avatar issue wasn't filed on github because:
1. I assume it's the plugin rather than the core, The plugin should be adapted, instead of having to hack core files, or there will be hell upgrading to future vanilla releases.
2. its a minor inconvenience, certainly not critical, and given the turnaround on github issues, unlikely to be rectified before the next release is due anyway, which just might fix it.
Interesting... Taking @camo suggestion above, I created a role "new user" and it appeared in the registration tab. Removing the permission to sign in, removes the option from "require users to confirm their email addresses", however, if you keep the permission to sign in, and just remove the permission to add comments or create posts, you get the same anti-spam result.
Comments
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •http://vanillaforums.org/discussion/17424/userlist-0.5-facebook-login-avatar-issue#Item_2
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •Developer at Vanilla Forums, Inc. [GitHub, Twitter]
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •If I just nightly empty out the Activity table, will that horrible break vanilla? I see no other solution at this time.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •https://github.com/vanillaforums/Garden/commit/747436011860d4f4fc99b3546f751b463547a480
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •In general usage of the site there are still queries hitting the activity table, and rather slowly at that. It's really the only source of entries in my mysql slow query log.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •1. I assume it's the plugin rather than the core, The plugin should be adapted, instead of having to hack core files, or there will be hell upgrading to future vanilla releases.
2. its a minor inconvenience, certainly not critical, and given the turnaround on github issues, unlikely to be rectified before the next release is due anyway, which just might fix it.
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •Just for your info, there's a dedicated addon github too (for some plugins, some are in the "Garden" repo):
https://github.com/vanillaforums/Addons
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •https://github.com/vanillaforums/Addons/issues/26
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •Developer at Vanilla Forums, Inc. [GitHub, Twitter]
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •Thanks for all the bug reports and help! We're working hard to make this our most stable release to date.
Developer at Vanilla Forums, Inc. [GitHub, Twitter]
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •My 0.02 :)
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •Developer at Vanilla Forums, Inc. [GitHub, Twitter]
- Spam
- Abuse
- Troll
0 • Off Topic Insightful Awesome LOL •