I am using Elgg-6.2.4 . URL : https://safalaya.com/ . My Database is getting filled up . o2d9_metadata table is taking 90% space . Can I empty this table ? How can I trim this table ? How can I optimize this table ?
info@elgg.org
Security issues should be reported to security@elgg.org!
©2014 the Elgg Foundation
Elgg is a registered trademark of Thematic Networks.
Cover image by Raül Utrera is used under Creative Commons license.
Icons by Flaticon and FontAwesome.
- Nikolai Shcherbin@rivervanrain

Nikolai Shcherbin - 0 likes
- Nirmalya Sikdar@nirmalya.sikdar

Nirmalya Sikdar - 0 likes
- elggnoob@elggnoob

elggnoob - 0 likes
- Nirmalya Sikdar@nirmalya.sikdar

Nirmalya Sikdar - 0 likes
- elggnoob@elggnoob

elggnoob - 0 likes
You must log in to post replies.Of course, you cannot empty this table. These data are the "heart" of your site. You just lose everything.
I don't know what's the purpose of your site, but it's all in spam and fake accounts.
You just need to delete fake accounts with their content and take care that such cases are not in the future.
How can I delete fake and spam accounts ?
Go to https://safalaya.com/admin/users, mark the users you want to delete and click the "delete" button.
After that, install Spam Login Filter and Spam Throttle and adjust the settings accordingly. I would also suggest one of Nikolai's Captcha plugins. I've had 0 fake accounts since I installed hCaptcha.
However, looking at your site, it would probably be easier to delete the whole Elgg installation and start all over again, as you would also have to delete hundreds of Spam entries all over the site. Is there any non-spam content at all that you would want to back up?
https://docs.hcaptcha.com/ is not clear to me how to add the code to my elgg login form ? Please help .
I can't help you with that, no idea. I bought the plugin from Nikolai for hCaptcha, installed the mod and that was it. Easy and fast.