Na poging installatie shoutbox foutmelding

Installatie lukt niet? Plotseling een foutmelding. Of weet je niet hoe iets werkt. Problemen met phpBB2 kun je in dit archief opzoeken.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.phpBB2.0.x
Gesloten
Carina
Berichten: 103
Lid geworden op: 24 apr 2005, 17:40
Contacteer:
Contacteer Carina

Na poging installatie shoutbox foutmelding

Bericht door Carina » 26 apr 2005, 00:54

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
Omhoog
Coen
Berichten: 5387
Lid geworden op: 03 aug 2004, 10:25

Bericht door Coen » 26 apr 2005, 07:39

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!
Omhoog
Carina
Berichten: 103
Lid geworden op: 24 apr 2005, 17:40
Contacteer:
Contacteer Carina

Bericht door Carina » 26 apr 2005, 08:51

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='</span></td><td align="left"><span class="gen"><b>Install results:</b><br/><br/>';
while($sql[$n])
{
$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : '';
if(!$result = $db->sql_query($sql[$n]))
$message .= '<b><font color=#FF0000>[failed]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />';
else $message .='<b><font color=#0000fF>[done]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />';
$n++;
}

message_die(GENERAL_MESSAGE, $message);
}
?>
Omhoog
Gebruikersavatar
AarClay
Berichten: 789
Lid geworden op: 10 feb 2005, 17:12

Bericht door AarClay » 26 apr 2005, 09:57

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='</span></td><td align="left"><span class="gen"><b>Install results:</b><br/><br/>';
while($sql[$n])
{
$message .= ($mods[$n-1] != $mods[$n]) ? '<p><b><font size=3>'.$mods[$n].'</font></b><br/>' : '';
if(!$result = $db->sql_query($sql[$n]))
$message .= '<b><font color=#FF0000>[failed]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />';
else $message .='<b><font color=#0000fF>[done]</font></b><font size="1"> line: '.($n+1).' , '.$sql[$n].'</font><br />';
$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.
Omhoog
Carina
Berichten: 103
Lid geworden op: 24 apr 2005, 17:40
Contacteer:
Contacteer Carina

Bericht door Carina » 26 apr 2005, 10:15

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
Omhoog
Carina
Berichten: 103
Lid geworden op: 24 apr 2005, 17:40
Contacteer:
Contacteer Carina

Bericht door Carina » 26 apr 2005, 10:29

Denk dat ik eerst maar eens het forum opnieuw ga installeren.....We komen er wel......ooit. :roll:
Omhoog
Gebruikersavatar
AarClay
Berichten: 789
Lid geworden op: 10 feb 2005, 17:12

Bericht door AarClay » 26 apr 2005, 10:41

Carina schreef:Denk dat ik eerst maar eens het forum opnieuw ga installeren.....We komen er wel......ooit. :roll:
ik denk dat je iets in constants.php moest toevoegen?
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20316
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 26 apr 2005, 12:09

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 ;)
Omhoog
Gesloten

Terug naar “2.0 Support”