Forum Mod Sql Question

[apoc]

Ok Im tryin to setup a mod on my forum called : ACP Announcement Centre
for phpBB ive done all the relavant Editing to my files but im stuck on the very first bit.

SQL
Code: Select All
CREATE TABLE phpbb_announcement_centre (
announcement_show tinyint (1) NOT NULL,
announcement_enable_guests tinyint (1) NOT NULL,
announcement_show_birthdays tinyint (1) NOT NULL,
announcement_birthday_avatar tinyint (1) NOT NULL,
announcement_draft text NOT NULL,
announcement_draft_bbcode_uid varchar(8) NOT NULL,
announcement_draft_bbcode_bitfield varchar(255) NOT NULL,
announcement_draft_bbcode_options mediumint(4) NOT NULL,
announcement_text text NOT NULL,
announcement_text_bbcode_uid varchar(8) NOT NULL,
announcement_text_bbcode_bitfield varchar(255) NOT NULL,
announcement_text_bbcode_options mediumint(4) NOT NULL,
announcement_text_guests text NOT NULL,
announcement_text_guests_bbcode_uid varchar(8) NOT NULL,
announcement_text_guests_bbcode_bitfield varchar(255) NOT NULL,
announcement_text_guests_bbcode_options mediumint(4) NOT NULL,
announcement_title varchar(255) NOT NULL default '',
announcement_title_guests varchar(255) NOT NULL default '',
announcement_show_group varchar(255) NOT NULL default '')
CHARACTER SET utf8 COLLATE utf8_bin;


INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '0', '0', 'Site Announcements', 'Site Announcements can be seen here!! :mrgreen:', 'Draft Announcements can be seen here!! :mrgreen:', 'Guest Announcements', 'Guest Announcements can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_show_index', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_enable', '1');

I dont understand what this means??? this is the only thing i havent done as i dont know what to do here? Im assuming it has to be applied somewhere but im unsure where

General Error
SQL ERROR [ mysql4 ]

Table '10330_truefa.phpbb_announcement_centre' doesn't exist [1146]

SQL

SELECT * FROM phpbb_announcement_centre

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/acp/acp_announcements_centre.php
LINE: 114
CALL: dbal_mysql->sql_query()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_announcements_centre->main()

FILE: adm/index.php
LINE: 74
CALL: p_master->load_active()

is the error i get within the ACP .MOD section of my ACP.

I have spoke to phpbb support who cant offer support because its a mod.. but have told me to speak to the server provider summit to do with 'myphpadmin'

Any help will be much appriecated and i think ive posted this in the correct section.

Thanx

[Tyler]

You should login to phpMyAdmin in your control panel and enter that SQL information in the phpMyAdmin area.

[Victor01469]

Insert this as an SQL query in the database of your forum, via phpmyadmin:

CREATE TABLE phpbb_announcement_centre (
announcement_show tinyint (1) NOT NULL,
announcement_enable_guests tinyint (1) NOT NULL,
announcement_show_birthdays tinyint (1) NOT NULL,
announcement_birthday_avatar tinyint (1) NOT NULL,
announcement_draft text NOT NULL,
announcement_draft_bbcode_uid varchar(8) NOT NULL,
announcement_draft_bbcode_bitfield varchar(255) NOT NULL,
announcement_draft_bbcode_options mediumint(4) NOT NULL,
announcement_text text NOT NULL,
announcement_text_bbcode_uid varchar(8) NOT NULL,
announcement_text_bbcode_bitfield varchar(255) NOT NULL,
announcement_text_bbcode_options mediumint(4) NOT NULL,
announcement_text_guests text NOT NULL,
announcement_text_guests_bbcode_uid varchar(8) NOT NULL,
announcement_text_guests_bbcode_bitfield varchar(255) NOT NULL,
announcement_text_guests_bbcode_options mediumint(4) NOT NULL,
announcement_title varchar(255) NOT NULL default '',
announcement_title_guests varchar(255) NOT NULL default '',
announcement_show_group varchar(255) NOT NULL default '')
CHARACTER SET utf8 COLLATE utf8_bin;


INSERT INTO phpbb_announcement_centre (announcement_show, announcement_enable_guests, announcement_show_birthdays, announcement_birthday_avatar, announcement_title, announcement_text, announcement_draft, announcement_title_guests, announcement_text_guests, announcement_show_group) VALUES ('0', '1', '0', '0', 'Site Announcements', 'Site Announcements can be seen here!! :mrgreen:', 'Draft Announcements can be seen here!! :mrgreen:', 'Guest Announcements', 'Guest Announcements can be seen here!! :wink:', '2');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_show_index', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('announcement_enable', '1');To get to phpmyadmin, follow this link: http://account.ulmb.com/mysql/

And click phpmyadmin for your forum database. In there look for something that says query, insert, or something of the like, and paste the above code in.

EDIT: Tyler beats me to it once again :p

[apoc]

Thank You both so much :)