Unless you really don't mind starting over all the time, you really shouldn't forget about EM's Restore Backups utility. It could definitely save you a lot of time and work...
You need to apply these SQL queries to your database. If you use a different table prefix other than phpbb_, then you will want to change the table names before applying the SQL code in phpMyAdmn...
Code: Select all
CREATE TABLE phpbb_news (
config_name varchar(255) NOT NULL default '',
config_value varchar(255) NOT NULL default '',
PRIMARY KEY (config_name)
) TYPE=MyISAM;
INSERT INTO phpbb_news (config_name, config_value)
VALUES ('news_block', ''),
('news_title', ''),
('news_color', ''),
('news_style', ''),
('news_bold', ''),
('news_ital', ''),
('news_under', ''),
('news_size', ''),
('scroll_speed', ''),
('scroll_action', ''),
('scroll_behavior', ''),
('scroll_size', '');
phpMyAdmin - Manually Applying SQL Code
The following is how you apply your SQL code manually to your phpMyAdmin database. You can get into your database through your CPanel by clicking on phpMyAdmin. Follow the following instructions:
I'm sure that every host is different. I will tell you how I run my queries manually and hopefully it will be close to what you have available to you. The following may or may not be similar to what you have...
Log into your domain Control Panel and find the database icons. You should be able to find the phpMyAdmin icon. Click on it...
Hopefully that will log you into your phpAdmin panel. You may need to provide a username and password...
In the phpMyAdmin panel, click on the Databases hyperlink...
Hopefully that should take you where you can select your database. You may only have one. Select your database hyperlink...
That should open up the display of all the tables in your database. Ignore them. Somewhere on the page, you should see something similar to this:
Click on the SQL tab to display something like the following where you can copy all of the SQL commands in at once:
Click on the Go button and the queries will be run. If all goes well, you will be told that the commands were executed successfully. Otherwise you will see a screen that tells you which command failed. If the columns that you are trying to add already exist, a duplicate will not be added...
Hopefully my instructions above are close to what you would see on your domain. If not, perhaps you could provide some screenshots of what you have available and we can figure out what you need to do. I use
Gadwin Printscreen to create the screenshots and
www.ImageShack.us to host them so they can be posted here...