Page 8 of 8

Re: ACP Site Announcement Centre v1.2.3

PostPosted: Tue Jul 29, 2008 11:21 am
by Hysteria
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.

Re: ACP Site Announcement Centre v1.2.3

PostPosted: Fri Aug 01, 2008 10:29 pm
by routers
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..

Re: ACP Site Announcement Centre v1.2.3

PostPosted: Tue Aug 05, 2008 5:01 am
by Abera
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

Re: ACP Site Announcement Centre v1.2.3

PostPosted: Sat Aug 09, 2008 3:52 pm
by lefty
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:

Re: ACP Site Announcement Centre v1.2.3

PostPosted: Sun Feb 08, 2009 12:01 am
by wrestlefanatics
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()

Re: ACP Site Announcement Centre v1.2.3

PostPosted: Thu Feb 12, 2009 11:45 am
by lefty
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 ;)