Code: Select all
SQL ERROR [ mysql4 ]
Table 'a4333557_phpbb9.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()
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) DEFAULT '' NOT NULL,
announcement_draft_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
announcement_draft_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
announcement_text text NOT NULL,
announcement_text_bbcode_uid varchar(8) DEFAULT '' NOT NULL,
announcement_text_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL,
announcement_text_bbcode_options mediumint(4) DEFAULT 0 NOT NULL,
announcement_text_guests text NOT NULL,
announcement_text_guests_bbcode_uid varchar(8) DEFAULT 0 NOT NULL,
announcement_text_guests_bbcode_bitfield varchar(255) DEFAULT 0 NOT NULL,
announcement_text_guests_bbcode_options mediumint(4) DEFAULT 0 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 '');
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', '[color=red][b]Site Announcements[/b][/color] can be seen here!! :mrgreen:', '[color=red][b]Draft Announcements[/b][/color] can be seen here!! :mrgreen:', 'Guest Announcements', '[color=green][b]Guest Announcements[/b][/color] 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');
that won't be possible unless you give them admin rights.Ring of Fire wrote:Hi there,
I installed this mod and it's working great. My only question now is how can I grant access to just the Announcement Centre Module to specific people (as in, I want certain people, groups, or roles to be able to change the announcement).
Thanks!
Has the post tie been implemented? I read this thread every few days, and do not see where it was added.lefty74 wrote:that won't be possible unless you give them admin rights.Ring of Fire wrote:Hi there,
I installed this mod and it's working great. My only question now is how can I grant access to just the Announcement Centre Module to specific people (as in, I want certain people, groups, or roles to be able to change the announcement).
Thanks!
below might be useful for what you would like
http://www.phpbb.com/community/viewtopi ... 5#p6785505
I apologise, that was not meant to be a dig, the thanks was sincere so was the mistake with the name, i am sorryBob_La_Londe wrote:P.S. While the cute name dig was noticed, it is hardly original.
lefty74 wrote:no, it hasnt yet implemented. i have been busy with other mods that i want to get done first.I apologise, that was not meant to be a dig, the thanks was sincere so was the mistake with the name, i am sorryBob_La_Londe wrote:P.S. While the cute name dig was noticed, it is hardly original.
I didnt see anything about a installer on page 3 but if ur talking about the modx installer i had no luck with it before cause if the mod fails i cant figure out how to take it off without restoring the entire boardlefty74 wrote:could you one more time doublecheck your edits, then use the installer referred to in post 3.
if you still have that problem after that, is there any chance of getting maybe temp ftp access and a temp admin account?