DEBUG MODE

[aidacha]

Als ich forum tour installierte und dann testete und auf forum tour danach klickte, kam ein popup fenster da stand:

Could not obtain forum tour data.

DEBUG MODE

SQL Error : 1146 Table 'usr_web3129_1.phpbb_forum_tour' doesn't exist

SELECT count(page_subject) as max_page FROM phpbb_forum_tour

Line : 64
File : /var/www/web3129/html/phpbb2.0.8/tour.php


was hab' ich falsch gmacht?

[kratzer54847]

hast du die notwendigen Datenbankänderungen vorgenommen?

[aidacha]

?? welche datenbank änderungen? in der anleitung stand glaub ich nix..

[kratzer54847]

es fehlt zweifelsohne eine Datenbanktabelle...
kannst du mir mal den Link zum Mod geben?

[aidacha]

ööhm.. ja wart muss gschwind suchen

[aidacha]

hier klicken

[kratzer54847]

ok...speichere das hier als db_update.php ab

Code: Alles auswählen

<?php
/***************************************************************************
 *                               db_update.php
 *                            -------------------
 *
 *   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey
 *   project              : http://sourceforge.net/projects/dbgenerator
 *   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
	$header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
	header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
	exit;
}

if( $userdata['user_level'] != ADMIN )
{
	message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "CREATE TABLE " . $table_prefix . "forum_tour (
  page_id mediumint(8) unsigned NOT NULL,
  page_subject varchar(60) NULL,
  page_text text,
  page_sort mediumint(8) NOT NULL,
  bbcode_uid varchar(10) NULL,
  KEY page_id (page_id)
) TYPE=MyISAM";

for( $i = 0; $i < count($sql); $i++ )
{
	if( !$result = $db->sql_query ($sql[$i]) )
	{
		$error = $db->sql_error();

		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
	}
	else
	{
		echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />';
	}
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>End</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbsupport.co.uk" target="_phpbbsupport">phpBBSupport.co.uk</a> and ask someone for help.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>

in den Rootindex(wo auch index.phph und viewtopic.php sind) hoch und führe sie aus

[aidacha]

oke gut.. hab ich gemacht.. jetzt kommt wenn ich das ausführ':

Updating the database
CREATE TABLE phpbb_forum_tour ( page_id mediumint(8) unsigned NOT NULL, page_subject varchar(60) NULL, page_text text, page_sort mediumint(8) NOT NULL, bbcode_uid varchar(10) NULL, KEY page_id (page_id) ) TYPE=MyISAM
+++ Successfull


End
Installation is now finished. Please be sure to delete this file now.
If you have run into any errors, please visit the phpBBSupport.co.uk and ask someone for help.
Have a nice day

jah lol.. und jetzt?! :S

[kratzer54847]

jetzt sollte das funktionieren

[aidacha]

löl also wenn ich db_update.php öffne kommt eben das von voher und wenn ich oben wo FAQ usw steht immernoch dasselbe debug problem..