ACP Site Announcement Centre v1.2.3

my MODS validated or going for validation at phpbb.com. Please note that support has ended for phpbb2 mods
MODs die schon überprüft wurden oder eingereichte MODs zur Überprüfung auf phpbb.com. Support für phpbb2 mods wurde eingestellt.

Re: ACP Site Announcement Centre v1.2.3

Postby Hysteria » Tue Jul 29, 2008 11:21 am

Hi Lefty,
I've used your mod previously (a few years ago) on a phpNuke website with integrated BB2Nuke forums & am trying to include it in my new phpNuke forums (BB2Nuke) but I keep getting the following error.

Code: Select all
phpBB : Critical Error

Could not query site announcement information

DEBUG MODE

SQL Error : 1146 Table 'gazanimal1.announcement_centre' doesn't exist

SELECT * FROM announcement_centre

Line : 227
File : common.php


I've double & triple checked the code & it's all there but I'm wondering if there is an issue with the SQL code.

All my tables in my database begin with "nuke" prefix so I tried the following:

Code: Select all
CREATE TABLE `nuke_announcement_centre` (
  `announcement_desc` varchar(255) NOT NULL default '',
  `announcement_value` text NOT NULL,
  PRIMARY KEY  (`announcement_desc`));
 
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_text', '[size=18][color=red][b]Change your announcements via your admin panel.   :) [/b][/color][/size]');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_status', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_access', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_guest_text', '[size=18][color=blue][b]Change your guest announcements via your admin panel.   :) [/b][/color][/size]');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_guest_status', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_text_draft', '[size=18][color=red][b]Preview in the ACP   :) [/b][/color][/size]');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_mod_version', 'v1.2.3');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_forum_id', '');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_topic_id', '');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_forum_topic_first_latest', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_title', 'Site Announcements');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_guest_title', 'Site Announcements');


Even doing that & creating the tables it still errors with the same error above, saying it's can't find gazanimal1.announcement_centre even though gazanimal1 is not the prefix but the actual database name.

Here's the config.php file from my website:

Code: Select all
$dbhost = '************************';
$dbuname = '****************';
$dbpass = '***********';
$dbname = 'gazanimal1';
$prefix = 'nuke';
$user_prefix = 'nuke';
$dbtype = 'MySQL';
$sitekey = '*******************************************';
$gfx_chk = 7;
$subscription_url = '';
$admin_file = 'admin';
$tipath = 'images/topics/';
$display_errors = false;  /


As you can see the "prefix" is nuke but creating tables with that prefix still does not work.

I appreciate I'm trying to get your mod to work with BB2Nuke & not what was originally intended for PHPBB2 but some mods I've been able to get working & I'm hoping you can point me in the right direction.

Thanks.
Last edited by Hysteria on Sun Aug 03, 2008 11:45 pm, edited 1 time in total.
Hysteria
Newbie/Neuling
 
Posts: 1
Joined: Tue Jul 29, 2008 11:10 am

Re: ACP Site Announcement Centre v1.2.3

Postby routers » Fri Aug 01, 2008 10:29 pm

hi ; thx for announcement centre ;

i'm forum admin, announcement centre in use, no problem & very nice..

but help me :)

hmm my other group forum moderators ( 3 member )..

forum moderators administrator panel, some permission ok.. but announcement centre how for forum moderators ?

pls help me..

very thx..
routers
Newbie/Neuling
 
Posts: 2
Joined: Fri Aug 01, 2008 10:22 pm

Re: ACP Site Announcement Centre v1.2.3

Postby Abera » Tue Aug 05, 2008 5:01 am

Just asking. Will v 123 work with phpbb302? I just looked at the install. No XML on this one (making it hard to figure) and no language/lang_english/lang_admin.php. I really wanted to use this. Do you plan on any updates to this?
Thanks
Abera
Newbie/Neuling
 
Posts: 5
Joined: Tue Aug 05, 2008 1:54 am

Re: ACP Site Announcement Centre v1.2.3

Postby lefty » Sat Aug 09, 2008 3:52 pm

Hysteria wrote:Hi Lefty,
I've used your mod previously (a few years ago) on a phpNuke website with integrated BB2Nuke forums & am trying to include it in my new phpNuke forums (BB2Nuke) but I keep getting the following error.

Code: Select all
phpBB : Critical Error

Could not query site announcement information

DEBUG MODE

SQL Error : 1146 Table 'gazanimal1.announcement_centre' doesn't exist

SELECT * FROM announcement_centre

Line : 227
File : common.php


I've double & triple checked the code & it's all there but I'm wondering if there is an issue with the SQL code.

All my tables in my database begin with "nuke" prefix so I tried the following:

Code: Select all
CREATE TABLE `nuke_announcement_centre` (
  `announcement_desc` varchar(255) NOT NULL default '',
  `announcement_value` text NOT NULL,
  PRIMARY KEY  (`announcement_desc`));
 
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_text', '[size=18][color=red][b]Change your announcements via your admin panel.   :) [/b][/color][/size]');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_status', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_access', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_guest_text', '[size=18][color=blue][b]Change your guest announcements via your admin panel.   :) [/b][/color][/size]');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_guest_status', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_text_draft', '[size=18][color=red][b]Preview in the ACP   :) [/b][/color][/size]');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_mod_version', 'v1.2.3');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_forum_id', '');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_topic_id', '');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_forum_topic_first_latest', '1');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_title', 'Site Announcements');
INSERT INTO nuke_announcement_centre (announcement_desc, announcement_value) VALUES('announcement_guest_title', 'Site Announcements');


Even doing that & creating the tables it still errors with the same error above, saying it's can't find gazanimal1.announcement_centre even though gazanimal1 is not the prefix but the actual database name.

Here's the config.php file from my website:

Code: Select all
$dbhost = '************************';
$dbuname = '****************';
$dbpass = '***********';
$dbname = 'gazanimal1';
$prefix = 'nuke';
$user_prefix = 'nuke';
$dbtype = 'MySQL';
$sitekey = '*******************************************';
$gfx_chk = 7;
$subscription_url = '';
$admin_file = 'admin';
$tipath = 'images/topics/';
$display_errors = false;  /


As you can see the "prefix" is nuke but creating tables with that prefix still does not work.

I appreciate I'm trying to get your mod to work with BB2Nuke & not what was originally intended for PHPBB2 but some mods I've been able to get working & I'm hoping you can point me in the right direction.

Thanks.

hi, you could try nukeannouncement_centre instead of nuke_announcement_centre as the prefix does not say nuke_ but just nuke
routers wrote:hi ; thx for announcement centre ;

i'm forum admin, announcement centre in use, no problem & very nice..

but help me :)

hmm my other group forum moderators ( 3 member )..

forum moderators administrator panel, some permission ok.. but announcement centre how for forum moderators ?

pls help me..

very thx..

hi, thats not possible. only admins can post announcements.
Abera wrote:Just asking. Will v 123 work with phpbb302? I just looked at the install. No XML on this one (making it hard to figure) and no language/lang_english/lang_admin.php. I really wanted to use this. Do you plan on any updates to this?
Thanks

no, you will need this one for v302.
viewtopic.php?f=51&t=394

p.s. sorry for the delay, was on holidays without internet access :whistle2:
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Re: ACP Site Announcement Centre v1.2.3

Postby wrestlefanatics » Sun Feb 08, 2009 12:01 am

heym i'm getting the following errors;

Code: Select all
General Error
SQL ERROR [ mysql4 ]

Table 'wrestlef_main.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

INSERT INTO ANNOUNCEMENTS_CENTRE_TABLE (announcement_title, announcement_text, announcement_gopost, announcement_forum_id, announcement_topic_id, announcement_post_id, announcement_first_last_post, announcement_text_bbcode_uid, announcement_text_bbcode_bitfield, announcement_text_bbcode_options, announcement_draft, announcement_draft_bbcode_uid, announcement_draft_bbcode_bitfield, announcement_draft_bbcode_options, announcement_title_guests, announcement_text_guests, announcement_text_guests_bbcode_uid, announcement_text_guests_bbcode_bitfield, announcement_text_guests_bbcode_options) VALUES ('Site Announcements', '[color=red:2yk2tmm7][b:2yk2tmm7]Site Announcements[/b:2yk2tmm7][/color:2yk2tmm7] can be seen here!! :mrgreen:', 0, 0, 0, 0, 'DESC', '2yk2tmm7', 'Qg==', 7, '[color=red:3ohuah4a][b:3ohuah4a]Draft Announcements[/b:3ohuah4a][/color:3ohuah4a] can be seen here!! :mrgreen:', '3ohuah4a', 'Qg==', 7, 'Guest Announcements', '[color=green:1l3orupl][b:1l3orupl]Guest Announcements[/b:1l3orupl][/color:1l3orupl] can be seen here!! :wink:', '1l3orupl', 'Qg==', 7)

BACKTRACE

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

FILE: install/index.php
LINE: 91
CALL: dbal_mysql->sql_query()
wrestlefanatics
Newbie/Neuling
 
Posts: 2
Joined: Sat Feb 07, 2009 11:59 pm

Re: ACP Site Announcement Centre v1.2.3

Postby lefty » Thu Feb 12, 2009 11:45 am

wrestlefanatics wrote:heym i'm getting the following errors;

Code: Select all
General Error
SQL ERROR [ mysql4 ]

Table 'wrestlef_main.ANNOUNCEMENTS_CENTRE_TABLE' doesn't exist [1146]

SQL

INSERT INTO ANNOUNCEMENTS_CENTRE_TABLE (announcement_title, announcement_text, announcement_gopost, announcement_forum_id, announcement_topic_id, announcement_post_id, announcement_first_last_post, announcement_text_bbcode_uid, announcement_text_bbcode_bitfield, announcement_text_bbcode_options, announcement_draft, announcement_draft_bbcode_uid, announcement_draft_bbcode_bitfield, announcement_draft_bbcode_options, announcement_title_guests, announcement_text_guests, announcement_text_guests_bbcode_uid, announcement_text_guests_bbcode_bitfield, announcement_text_guests_bbcode_options) VALUES ('Site Announcements', '[color=red:2yk2tmm7][b:2yk2tmm7]Site Announcements[/b:2yk2tmm7][/color:2yk2tmm7] can be seen here!! :mrgreen:', 0, 0, 0, 0, 'DESC', '2yk2tmm7', 'Qg==', 7, '[color=red:3ohuah4a][b:3ohuah4a]Draft Announcements[/b:3ohuah4a][/color:3ohuah4a] can be seen here!! :mrgreen:', '3ohuah4a', 'Qg==', 7, 'Guest Announcements', '[color=green:1l3orupl][b:1l3orupl]Guest Announcements[/b:1l3orupl][/color:1l3orupl] can be seen here!! :wink:', '1l3orupl', 'Qg==', 7)

BACKTRACE

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

FILE: install/index.php
LINE: 91
CALL: dbal_mysql->sql_query()

hi, wrong topic i am afraid. i believe i already answered that one in the correct topic ;)
lefty aka The Heikze! :eyebrowe:

Heiko Carstens
http://www.lefty74.com

Would you like me to install one of my mods for you? Read here for details
lefty
Abschlussklasse R10c
 
Posts: 1357
Joined: Mon Feb 06, 2006 1:20 am
Location: Den Haag - NL

Previous

Return to my MODS & support

Who is online

Users browsing this forum: No registered users and 2 guests

cron