MyBB Community Forums

Full Version: mybbh6_templates showing large
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
i delete all forum and users. but still in phpmyadmin mybbh6_templates showing large size
[Image: e796f76e2da9b4a57866ed5e6946a7cb.png]

what should i do to reduce database and run the forum without error.
but i dont need any old post and user. i have only admin id there
Remove all unnecessary templates
Admin Control Panel -> Templates & Style -> Templates
If you don't need posts or users it'd probably be easier to re-install wouldn't it? Can't think how you would possibly have managed to have 15 million templates created.
there is only 3 template

[Image: 327428d60820de64caa03d138008a841.png]
[Image: 19413da4136c0075d62d58616f8ea756.png]
They're the template sets, the templates are within those.
global template showing blank

[Image: 7dbd5a97b98e5001e920a511636c80b6.png]
here is blade templates

[Image: 3e572fd70ed201af5cb3f4a5eed0103d.png]



i just want all my theme setting and new pages to be there. so what to do?
if i dump that mybbh6_templates and reupload the theme it will work?
(2021-11-29, 12:11 PM)Matt Wrote: [ -> ]If you don't need posts or users it'd probably be easier to re-install wouldn't it? Can't think how you would possibly have managed to have 15 million templates created.

Yes I think that's weird, too. Don't know if crashed table would have that stats?

OP please use phpMySQL to browse into that table for two or three pages and get a screenshot.
[Image: 31b0c5499b88f5820cc27490dfb99ca4.png]

[Image: 41d4f5e8194fa664ed2e0111e9b74b6e.png]

[Image: 40278cf8e5f1008b309a6c065a66ddc0.png]

[Image: e0dcd41bdd8832272854a64e92748465.png]
Team members looking at this, so will stay clear.  Must say curious about that theme.  Got a link?
Sorry, it seems those screenshots didn't help at all.

Now let's try some SQL query. In phpMySQL, get into the database, run the following queries separately and get screenshots of the results:
select * from mybbh6_templates where title='forumdisplay';

select * from mybbh6_templatesets;
Pages: 1 2