MyBB Community Forums
mybbh6_templates showing large - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: mybbh6_templates showing large (/thread-234355.html)

Pages: 1 2

RE: mybbh6_templates showing large - Matt - 2021-11-29

This query might show the results more clearly - will show a count of rows by template name:

select title, count(*) as count from mybb_templates group by title order by count desc;

Can we see the first 20 or so rows from this?

RE: mybbh6_templates showing large - gour - 2021-11-30

(2021-11-29, 08:03 PM)Matt Wrote: This query might show the results more clearly - will show a count of rows by template name:

select title, count(*) as count from mybb_templates group by title order by count desc;

Can we see the first 20 or so rows from this?

Thank you for putting me in the right direction. After running this query I got this.


[Image: 2103581b602207c444655801e08998cc.png]

I saw that there are two titles which having huge number counts. Should I delete them or?

Waiting for your response.

RE: mybbh6_templates showing large - Matt - 2021-11-30

Hm, can you run both of these:

select title, template from mybb_templates where title = 'ubh' limit 1;
select title, template from mybb_templates where title = 'err' limit 1;

Those aren't default templates so not sure where they've come from.

RE: mybbh6_templates showing large - codedude - 2021-11-30

Is your forum darkforums.net?
I believe your database has been breached by some hacking forum, you should remove all plugins which are not from mybb.com as some plugin is compromising your site.

RE: mybbh6_templates showing large - gour - 2021-11-30

(2021-11-30, 02:38 PM)Matt Wrote: Hm, can you run both of these:

select title, template from mybb_templates where title = 'ubh' limit 1;
select title, template from mybb_templates where title = 'err' limit 1;

Those aren't default templates so not sure where they've come from.

Here is the output of both:
http://prntscr.com/215htqo
http://prntscr.com/215hxix

I can't edit them, it says reached memory limit. Shall I delete both entries?
(2021-11-30, 09:03 PM)codedude Wrote: Is your forum darkforums.net?
I believe your database has been breached by some hacking forum, you should remove all plugins which are not from mybb.com as some plugin is compromising your site.

Thanks for your suggestion, I will try to disable all third-party plugins and check it and update you asap.
please help me guys