mybbh6_templates showing large

[gour]

i delete all forum and users. but still in phpmyadmin mybbh6_templates showing large size


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

[Mostafa.Shiraali]

Remove all unnecessary templates
Admin Control Panel -> Templates & Style -> Templates

[Matt]

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.

[gour]

there is only 3 template

[Matt]

They're the template sets, the templates are within those.

[gour]

global template showing blank


here is blade templates





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?

[noyle]

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.

[gour]

[nixer55]

Team members looking at this, so will stay clear.  Must say curious about that theme.  Got a link?

[noyle]

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;