phpBB.nl

Wat moet ik doen?

http://www.carinahermse.nl/phpBB2/

phpBB : Critical Error

Could not query shoutbox config information

DEBUG MODE

SQL Error : 1146 Table 'carinahe_forum.phpbb_shoutbox_config' doesn't exist

SELECT * FROM phpbb_shoutbox_config

Line : 233
File : common.php

De database update draaien die bij de MOD ingesloten zit.

Mogelijk staat deze "SQL Code" in de installatie van je MOD, anders staat hij misschien in een bestand als; "shout_db_install.php, die je dan op je server moet draaien...

(Zie ook: 10 ) De "SQL" actie : in deze Kennisbank tutorial!

Dit is de code van db_intall_php die in de mod van de shoutbox staat. Als ik nu dit wil doen. Ik probeer in de browser dit te draaien http://www.mijnsite.nl/phpBB/db_install.php Maar dat lukt dus niet.

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
define('SITE_HISTORY_TABLE', $table_prefix.'site_history');

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

if ( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_ERROR, "You are not authorised");
}
else
{
$sql=array(
"CREATE TABLE ".$table_prefix."shoutbox (
id int(11) NOT NULL auto_increment,
sb_user_id int(11) NOT NULL,
msg varchar(255) NOT NULL,
timestamp int(10) unsigned NOT NULL,
sb_username varchar(255) NOT NULL,
PRIMARY KEY (id)
)",

"CREATE TABLE ".$table_prefix."shoutbox_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name)
)",

"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_guest','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_delete','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_edit','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('links_names','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('make_links','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('count_msg','100')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('delete_days','30')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('text_lenght','500')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('word_lenght','90')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('date_on','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shout_width','630')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shout_height','130')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('banned_user_id','')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','')",
);

$n=0;
$message='</td><td align="left">Install results: ';
while($sql[$n])
{
$message .= ($mods[$n-1] != $mods[$n]) ? ''.$mods[$n].' ' : '';
if(!$result = $db->sql_query($sql[$n]))
$message .= '[failed] line: '.($n+1).' , '.$sql[$n].' ';
else $message .='[done] line: '.($n+1).' , '.$sql[$n].' ';
$n++;
}

message_die(GENERAL_MESSAGE, $message);
}
?>

Carina schreef:Dit is de code van db_intall_php die in de mod van de shoutbox staat. Als ik nu dit wil doen. Ik probeer in de browser dit te draaien http://www.mijnsite.nl/phpBB/db_install.php Maar dat lukt dus niet.

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);
include($phpbb_root_path . 'includes/functions_selects.'.$phpEx);
define('SITE_HISTORY_TABLE', $table_prefix.'site_history');

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);

if ( $userdata['user_level'] != ADMIN )
{
message_die(GENERAL_ERROR, "You are not authorised");
}
else
{
$sql=array(
"CREATE TABLE ".$table_prefix."shoutbox (
id int(11) NOT NULL auto_increment,
sb_user_id int(11) NOT NULL,
msg varchar(255) NOT NULL,
timestamp int(10) unsigned NOT NULL,
sb_username varchar(255) NOT NULL,
PRIMARY KEY (id)
)",

"CREATE TABLE ".$table_prefix."shoutbox_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name)
)",

"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_guest','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_delete','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_edit','0')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('links_names','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('make_links','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('count_msg','100')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('delete_days','30')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('text_lenght','500')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('word_lenght','90')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('date_on','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shout_width','630')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('shout_height','130')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('banned_user_id','')",
"INSERT INTO ".$table_prefix."shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','')",
);

$n=0;
$message='</td><td align="left">Install results: ';
while($sql[$n])
{
$message .= ($mods[$n-1] != $mods[$n]) ? ''.$mods[$n].' ' : '';
if(!$result = $db->sql_query($sql[$n]))
$message .= '[failed] line: '.($n+1).' , '.$sql[$n].' ';
else $message .='[done] line: '.($n+1).' , '.$sql[$n].' ';
$n++;
}

message_die(GENERAL_MESSAGE, $message);
}
?>

Dat het niet lukt kan aan zoveel dingen liggen. Vertel eens meer, dan alleen maar te zeggen dat het niet lukt.

AarClay schreef: Dat het niet lukt kan aan zoveel dingen liggen. Vertel eens meer, dan alleen maar te zeggen dat het niet lukt.

Nou, ik krijg nog steeds onderstaande melding. Ik heb inmiddels wel phpmyadmin geinstalleerd. Die table phpbb_shoutbox_config die bestaat inderdaad niet maar er is wel een phpbb_shoutbox_configconfig.
Ik weet ook niet wat ik er over moet vertellen want ik ben nog een beginner.

phpBB : Critical Error

Could not query shoutbox config information

DEBUG MODE

SQL Error : 1146 Table 'carinahe_forum.phpbb_shoutbox_config' doesn't exist

SELECT * FROM phpbb_shoutbox_config

Line : 233
File : common.php

Denk dat ik eerst maar eens het forum opnieuw ga installeren.....We komen er wel......ooit.

Carina schreef:Denk dat ik eerst maar eens het forum opnieuw ga installeren.....We komen er wel......ooit.

ik denk dat je iets in constants.php moest toevoegen?

dat heeft hier niets mee te maken

voer de volgende sql query is uit in phpmyadmin(Kopje sql). Verander eventueel phpbb_ in jouw prefix

Code: Selecteer alles

CREATE TABLE phpbb_shoutbox (
id int(11) NOT NULL auto_increment,
sb_user_id int(11) NOT NULL,
msg varchar(255) NOT NULL,
timestamp int(10) unsigned NOT NULL,
sb_username varchar(255) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE phpbb_shoutbox_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name)
);
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest_view','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_guest','0')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete_all','0')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_delete','0')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit_all','0')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_edit','0')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_bbcode','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('allow_smilies','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('links_names','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('make_links','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('count_msg','100')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('delete_days','30')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('text_lenght','500')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('word_lenght','90')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_format','D G:i')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('date_on','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shoutbox_on','1')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_width','630')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('shout_height','130')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id','')
INSERT INTO phpbb_shoutbox_config (config_name, config_value) VALUES ('banned_user_id_view','')

en dan zou het moeten werken.

@AarClay, Dan zou het een heel andere foutmelding zijn, Namelijk dat tabelnaam met hoofdletters

phpBB.nl

Na poging installatie shoutbox foutmelding

Na poging installatie shoutbox foutmelding