ACP Announcement Centre

[Booch_21]

Code: Select all

SQL ERROR [ mysql4 ]

Duplicate entry 'announcement_enable' for key 1 [1062]

SQL

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

BACKTRACE

I got the same thing when installing mine. Here is what I did. I do not know if you have the same capabilities as I do.

First, go into phpMyAdmin, or some kind of admin function of your SQL databases. I did a list of the tables and emptied out phpbb_announcement_centre. I then deleted it completely from the list.

Second, I copied the SQL code from the instructions again, but left off the following from the end of the copied code:

Code: Select all

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 executed the SQL code again and it worked just fine. I may not have all of the lingo correct, but I'm learning! Good luck!

[jaason]

hey. maybe You can help me. I have problem with creating new tables under postgreSql database.
it returns me this error:

Code: Select all

ERROR:  syntax error at or near "CHARACTER"
LINE 21:   CHARACTER SET utf8 COLLATE utf8_bin;
           ^

and after deleting this line I've got error like this:

Code: Select all

ERROR:  type "tinyint" does not exist
LINE 2:   announcement_show tinyint (1) NOT NULL,
                            ^

is it postgresql syntax fault?

[Muzet]

Very good MOD.
If a member is administrator can read this announcement?

[Kojek]

Very good MOD.
If a member is administrator can read this announcement?

of course

[lefty74]

Code: Select all

SQL ERROR [ mysql4 ]

Duplicate entry 'announcement_enable' for key 1 [1062]

SQL

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

BACKTRACE

I got the same thing when installing mine. Here is what I did. I do not know if you have the same capabilities as I do.

First, go into phpMyAdmin, or some kind of admin function of your SQL databases. I did a list of the tables and emptied out phpbb_announcement_centre. I then deleted it completely from the list.

Second, I copied the SQL code from the instructions again, but left off the following from the end of the copied code:

Code: Select all

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 executed the SQL code again and it worked just fine. I may not have all of the lingo correct, but I'm learning! Good luck!

or you could just clear your cache (and refresh templates) as per install instruction

seems easier to me

hey. maybe You can help me. I have problem with creating new tables under postgreSql database.
it returns me this error:

Code: Select all

ERROR:  syntax error at or near "CHARACTER"
LINE 21:   CHARACTER SET utf8 COLLATE utf8_bin;
           ^

and after deleting this line I've got error like this:

Code: Select all

ERROR:  type "tinyint" does not exist
LINE 2:   announcement_show tinyint (1) NOT NULL,
                            ^

is it postgresql syntax fault?

apparently postgresql does not know tinyint (i googled and saw a bug report), try to change tinyint to smallint pse and see if that makes a difference.

Very good MOD.
If a member is administrator can read this announcement?

in the acp you can set the groups you would like to show the announcement to, if you only select administrator, it will show only to members of the administrator group but i am not sure if that is what you were asking.

[Kojek]

btw lefty..
can i put an html text in the announcement?

[jaason]

if I delete this line: CHARACTER SET utf8 COLLATE utf8_bin from sql stuff, it will affect to something in the future?

[Primy]

Hi, nice mod

Ive a bug after the installation:

[phpBB Debug] PHP Notice: in file /includes/acp/acp_announcements_centre.php on line 26: acp_announcements_centre::include_once(./../includes/functions_announcements.php) [function.acp-announcements-centre-include-once]: failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /includes/acp/acp_announcements_centre.php on line 26: acp_announcements_centre::include_once() [function.include]: Failed opening './../includes/functions_announcements.php' for inclusion (include_path='.:/usr/share/pear')

Fatal error: Call to undefined function group_select_options_selected() in /var/www/vhost/cinomania.net/home/html/forum/includes/acp/acp_announcements_centre.php on line 166

In local anything is ok, but online i cannot use the forum. What can i do?

[Primy]

I found the error, just my stupid oversight

Congratulations for the mod!

[ham1299]

Congrats on the release, Lefty!

[Hippie459MN]

WoW!! Thanks for this. Time to update.

[319]

style mistake in Administration Control Panel!

<br /> before text area of Drafts

[Desdenova]

lefty, when do you think you are going to code an installer for this so it is possible to use this on boards running on something other than MySQL?

I've got a script for SQL install almost done, will you want it? You'll just have to pop in the SQL queries (using the DBAL, I'd hope. ) and it's just about ready to go. I've just got to setup the language file and a few other things, but other than that, it ought to be done soon.

Of course, you may have to recode internal SQL statements yourself to use the DBAL if you wanted cross-SQL type compatibility, but I guess that wouldn't be too hard for you.

[lefty74]

btw lefty..
can i put an html text in the announcement?

i am afraid you will need to use bbcode.

if I delete this line: CHARACTER SET utf8 COLLATE utf8_bin from sql stuff, it will affect to something in the future?

have a look how your other tables are collated and do the same collation they have.
i dont have .

lefty, when do you think you are going to code an installer for this so it is possible to use this on boards running on something other than MySQL?

I've got a script for SQL install almost done, will you want it? You'll just have to pop in the SQL queries (using the DBAL, I'd hope. ) and it's just about ready to go. I've just got to setup the language file and a few other things, but other than that, it ought to be done soon.

Of course, you may have to recode internal SQL statements yourself to use the DBAL if you wanted cross-SQL type compatibility, but I guess that wouldn't be too hard for you.

i wasn't going to code an installer but if you have something that people can use, why not publish it and they can put the SQL in there if they like.

[Desdenova]

i wasn't going to code an installer but if you have something that people can use, why not publish it and they can put the SQL in there if they like.

That's what I was planning.

Will you want me to let you know when it is done, though?