MODS.DB9.DK

[Yellow-wellie]

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

[Metshrine]

I also cannot access any shoutbox config options, there isnt even a config section for the shoutbox in my admin panel

[wyre1t]

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

Alan

[concretemonkey]

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.

[Beeveer]

includes/constants.php not editted correctly.

[concretemonkey]

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]

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]

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.