What version of phpBB are you using? phpBB 3.0.9
What is your board's URL? http://www.nova-nilla.com/Members/phpBB3
Who do you host your board with? Front Range Internet, Inc
How did you install your board? I used the download package from phpBB.com
Is your board a fresh install or a conversion? Update from a previous version of phpBB3
Do you have any MODs installed? Yes
Is registration required to reproduce this issue? No
What version of phpBB3 did you update from? phpBB 3.0.8
What MODs do you have installed? NV gallery
Social Network Mod
Board 3 Portal
What styles do you currently have installed? Proformell (enabled), ProSilver, SubSilver2
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
When did your problem begin? I used to use Glacier as a style (one year ago), but that wasn't supported as well as others, and I had trouble refreshing my templates with it so I changed to ProFormell.
Please describe your problem. I'm having trouble refreshing my style templates. It takes way tooooo long. I looked through some database backup files and discovered my phpbb3_styles_template_data file is 400 megabytes, which is about 90% of my database. For some reason it's not getting cleared out, and I don't know why. My permissions are 755 for all the directories. I'd like to know if I can run a modified restore file to rebuild the table to an empty state and start over?
Generated by SRT Generator
Can I just run this SQL querey to blow away the template data and start over?
Code: Select all
# # phpBB Backup Script # Dump of tables for phpbb3_ # DATE : 29-12-2011 14:24:31 GMT # # Table: phpbb3_styles_template_data DROP TABLE IF EXISTS phpbb3_styles_template_data; CREATE TABLE `phpbb3_styles_template_data` ( `template_id` mediumint(8) unsigned NOT NULL default '0', `template_filename` varchar(100) collate utf8_bin NOT NULL default '', `template_included` text collate utf8_bin NOT NULL, `template_mtime` int(11) unsigned NOT NULL default '0', `template_data` mediumtext collate utf8_bin NOT NULL, KEY `tid` (`template_id`), KEY `tfn` (`template_filename`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;