Cant access admin controlls. Please help.

This shoutbox, fully integrates in phpbb2, support smilies and bbcode
this shoutbox is a shoutbox written for phpbb2, therefor it makes uses of templates and language files

Moderator: Moderators

Forum rules
The content in this forum is dated Dec. 21 2005 and can be used as Archive only. This Forum is LOCKED and READ ONLY !

Cant access admin controlls. Please help.

Postby Yellow-wellie on Fri 04. Mar, 2005 01:52

OK I have installed the latest version of the shout box and it is on my site and working great, but in my admin controll panel I cant access any of the shoutbox controlls. when I click on the shoutbox link in admin panel i get this error displayed in my main window.

phpBB : Critical Error

Could not query shoutbox config information

DEBUG MODE

SQL Error : 1146 Table 'cborrett_phpb1.SHOUTBOX_CONFIG_TABLE' doesn't exist

SELECT * FROM SHOUTBOX_CONFIG_TABLE

Line : 36
File : /home/cborrett/public_html/forum/admin/admin_shoutbox.php

Can someone please help me to fix this??

Many thanks in advance.

Chris
Yellow-wellie
Poster
Poster
 
Posts: 1
Joined: Fri 04. Mar, 2005 01:45

Postby Metshrine on Sun 06. Mar, 2005 15:38

I also cannot access any shoutbox config options, there isnt even a config section for the shoutbox in my admin panel
Metshrine
Poster
Poster
 
Posts: 21
Joined: Mon 12. May, 2003 23:41

Postby wyre1t on Sun 20. Mar, 2005 21:43

Can we have some input from anyone regarding these lack of admin problems

Alan
wyre1t
Poster
Poster
 
Posts: 2
Joined: Sun 20. Mar, 2005 21:39

Postby concretemonkey on Sun 18. Sep, 2005 00:54

Same here. Just downloaded and installed the latest version from this forum. Looks like the shoutbox_db_update.php file is missing the SQL for the admin panel bit.

Code: Select all
phpBB : Critical Error

Could not query shoutbox config information

DEBUG MODE

SQL Error : 1146 Table 'gareth_viptp.SHOUTBOX_CONFIG_TABLE' doesn't exist

SELECT * FROM SHOUTBOX_CONFIG_TABLE

Line : 36
File : admin_shoutbox.php


Looks to me like the SHOUTBOX_CONFIG_TABLE table hasn't been created by the SQL. I checked the shoutbox_db_update.php file and found it isn't in it. It also isn't in the 1.1.5 version on phpbbhacks.com.

Niels, can you please post the correct SQL command that we need please. Everything is fantastic except for this bit.

Thanks in advance.
concretemonkey
Poster
Poster
 
Posts: 8
Joined: Mon 25. Oct, 2004 22:21

Postby Beeveer on Mon 19. Sep, 2005 09:41

includes/constants.php not editted correctly.
Nee, ik geef geen antwoorden in het Nederlands, die horen thuis op www.phpbb.nl ;)
User avatar
Beeveer
brilliant supporter
 
Posts: 264
Joined: Tue 30. Nov, 2004 19:13
Location: Boskoop, South-Holland, the Netherlands

Postby concretemonkey on Mon 19. Sep, 2005 20:40

I have checked that file, and then checked again and all modifications have been completed.

I am still of the opinion that it is a missing piece of SQL in the shoutbox_db_update.php file, hence the SQL error message.
concretemonkey
Poster
Poster
 
Posts: 8
Joined: Mon 25. Oct, 2004 22:21

Postby concretemonkey on Mon 19. Sep, 2005 20:51

This is the SQL code in the latest release:
Code: Select all
$sql=array(

"CREATE TABLE ".SHOUTBOX_TABLE." (
shout_id MEDIUMINT(8) UNSIGNED NOT NULL auto_increment,
shout_username VARCHAR(25) NOT NULL,
shout_user_id MEDIUMINT(8) NOT NULL,
shout_group_id MEDIUMINT(8) NOT NULL,
shout_session_time INT(11) NOT NULL,
shout_ip CHAR(8) NOT NULL,
shout_text TEXT NOT NULL,
shout_active MEDIUMINT(8) NOT NULL,
enable_bbcode TINYINT (1) NOT NULL,
enable_html TINYINT (1) NOT NULL,
enable_smilies TINYINT (1) NOT NULL,
enable_sig TINYINT (1) NOT NULL,
shout_bbcode_uid VARCHAR(10) NOT NULL,
INDEX (shout_id)
)",
"INSERT INTO ".CONFIG_TABLE." (config_name, config_value) VALUES ('prune_shouts', '0')",
);

$mods = array (
'fully integrated shoutbox','fully integrated shoutbox','fully integrated shoutbox'
);


As you can see from the error messages the admin_shoutbox.php page is doing the following query:
Code: Select all
SELECT * FROM SHOUTBOX_CONFIG_TABLE


Since the SQL only created the table "SHOUTBOX_TABLE", the query will fail. If anyone has a working admin panel, can they either
A) Give us the code from their installation docs
or
B) Log into phpMyAdmin and create the SQL command we need for the table.

Please?
concretemonkey
Poster
Poster
 
Posts: 8
Joined: Mon 25. Oct, 2004 22:21

Please lock this topic.

Postby concretemonkey on Mon 19. Sep, 2005 22:52

I have figured out that this problem is NOT a problem with the Fully Integrated Shoutbox from Niels.

If you are using the Fully Integrated Shoutbox by Niels, and you have a menu called "Shoutbox" in the General Admin section of you admin panel, this will be from another mod.

To remove it, go to your FTP and delete the following file from yout admin folder : admin_shoutbox.php

The only admin features that this mod should have is the "Auto Prune Shouts" option in "General Admin > Configuration" part of the ACP.

---------

My apologies for any inconvenience caused.
concretemonkey
Poster
Poster
 
Posts: 8
Joined: Mon 25. Oct, 2004 22:21

Next

Return to Fully integrated shoutbox [2.0.6/EM]

Who is online

Users browsing this forum: No registered users and 1 guest

cron