phpBB.nl

phpBB : Critical Error

Could not query SP config information

DEBUG MODE

SQL Error : 1146 Table 'megmouse_phpbb2010.ALBUM_SP_CONFIG_TABLE' doesn't exist

SELECT * FROM ALBUM_SP_CONFIG_TABLE

Line : 42
File : /home/megmouse/public_html/phpBB2/admin/admin_album_clown_SP.php

//
// Let's set the root dir for phpBB
//
$phpbb_root_path = '../';
require($phpbb_root_path . 'extension.inc');
require('./pagestart.' . $phpEx);
require($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_album.' . $phpEx);
require($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_admin_album.' . $phpEx);

//update values for config
$sql = "SELECT * FROM " . ALBUM_SP_CONFIG_TABLE;
if(!$result = $db->sql_query($sql))
{
message_die(CRITICAL_ERROR, "Could not query SP config information", "", __LINE__, __FILE__, $sql);
}
else
{
while( $row = $db->sql_fetchrow($result) )
{
$config_name = $row['config_name'];
$config_value = $row['config_value'];
$default_config[$config_name] = $config_value;

de database geupdate enzovoorts

##
## Files To Edit: 2
## viewonline.php
## admin/index.php
##

sp_db_install.php schreef:

Code: Selecteer alles

<?php
//copyright © 2003 Volodymy (CLowN) Skoryk
//this update template copyright : ©2003 Freakin' Booty ;-P & Antony Bailey

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 for CLowN\' SP1';
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[] = "DROP TABLE IF EXISTS `" . $table_prefix . "album_sp_config`";
$sql[] = "CREATE TABLE `" . $table_prefix . "album_sp_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`config_name`)
) TYPE=MyISAM";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('disp_late', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('rate_type', '2')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('disp_high', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('disp_rand', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('img_rows', '2')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('img_cols', '4')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('use_watermark', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('wut_users', '0')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('disp_watermark_at', '3')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('hon_rate_times', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('hon_rate_sep', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('hon_rate_where', '')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('hon_rate_users', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('midthumb_use', '1')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('midthumb_height', '600')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('midthumb_width', '800')";
$sql[] = "INSERT INTO `" . $table_prefix . "album_sp_config` VALUES ('midthumb_cache', '1')";
$sql[] = "ALTER TABLE `" . $table_prefix . "album_rate` ADD `rate_hon_point` TINYINT(3) DEFAULT '0' NOT NULL";
$sql[] = "ALTER TABLE `" . $table_prefix . "album_comment` ADD `comment_cat_id` INT( 11 ) NOT NULL AFTER `comment_pic_id`";

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>Finish</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.</span></td></tr></table>';

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

?>

sp_db_install_fix.php schreef:

Code: Selecteer alles

<?php
//copyright © 2003 Volodymy (CLowN) Skoryk
//this script will upgrade your album database to work with CLowN's SP1

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 for CLowN\' SP1 Part 2';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

if (isset($_GET['step']))
{
	echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
	echo '<tr><th>Patching the comment table to work with SP1</th></tr><tr><td><span class="genmed"><ul type="circle">';

	//get all picture ids from every comment in system
	$sql = "SELECT comment_id, comment_pic_id FROM ". ALBUM_COMMENT_TABLE;
	if( !($result = $db->sql_query($sql)) )
		message_die(GENERAL_ERROR, 'Could not query the comments table.', '', __LINE__, __FILE__, $sql);

	for ($x = 0; $x < mysql_num_rows($result); $x++) 
	{ 
	   	$row = mysql_fetch_assoc($result);
	   	$comment_id = $row['comment_id'];
	   	$pic_id = $row['comment_pic_id'];
		
		//get category id from album table
		$sql = "SELECT pic_cat_id FROM " . ALBUM_TABLE . " WHERE pic_id = " . $pic_id;
		if( !($result_album = $db->sql_query($sql)) )
			echo '<li><font color="#FF0000">Errored on comment #' . $comment_id . '. Can\'t select category id from album table.</font></li>';
		$row_album = mysql_fetch_assoc($result_album);
		$cat_id = $row_album['pic_cat_id'];
	   
	   	//update the category id in comment table
	   	$sql = "UPDATE " . ALBUM_COMMENT_TABLE . " SET comment_cat_id = " . $cat_id . " WHERE comment_pic_id = " . $pic_id;
		if( !($db->sql_query($sql)) )
			echo '<li><font color="#0000FF">Errored on comment #' . $comment_id . '. Failed updating category id.</font></li>';
		
		echo '<li><font color="#00FF00">Succsessfully updated comment #' . $comment_id . '.</font></li>';
	}

	echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';
	echo '<tr><th>Finish</th></tr><tr><td><span class="genmed">Updating comment table is now finished. Please be sure to delete this file now.<br /><br />If any of the text is red or blue, write down the comment ids that it says, and you may update them manually..or just remove those pictures.</span></td></tr></table>';
}
else
{
	echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
	echo '<tr><th>You are about to patch your albums database to work with CLowN\'s SP1.</th></tr><tr><td><span class="genmed">';
	echo 'I STRONGLY suggest that you make backup of your database before continuing running this file. <br />Depending on how many comments you have in your album, this next screen might take a while to load.';
	echo '<br />If for any reason your computer crashes, i suggest you restore your backup and try running this file again. <br />If you have alot of comments, dont expect this screen to load very fast...give it some time...GOOD LUCK!';
	echo '<br /><br /><a href="?step=2">Click here go run the script</a>';
	echo '</span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr></table>';
}

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

?>

Updating the database
DROP TABLE IF EXISTS `phpbb_album_sp_config`
+++ Successfull
CREATE TABLE `phpbb_album_sp_config` ( `config_name` varchar(255) NOT NULL default '', `config_value` varchar(255) NOT NULL default '', PRIMARY KEY (`config_name`) ) TYPE=MyISAM
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('disp_late', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('rate_type', '2')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('disp_high', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('disp_rand', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('img_rows', '2')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('img_cols', '4')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('use_watermark', '0')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('wut_users', '0')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('disp_watermark_at', '3')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('hon_rate_times', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('hon_rate_sep', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('hon_rate_where', '')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('hon_rate_users', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('midthumb_use', '1')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('midthumb_height', '600')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('midthumb_width', '800')
+++ Successfull

INSERT INTO `phpbb_album_sp_config` VALUES ('midthumb_cache', '1')
+++ Successfull

ALTER TABLE `phpbb_album_rate` ADD `rate_hon_point` TINYINT(3) DEFAULT '0' NOT NULL
+++ Error: Duplicate column name 'rate_hon_point'

ALTER TABLE `phpbb_album_comment` ADD `comment_cat_id` INT( 11 ) NOT NULL AFTER `comment_pic_id`
+++ Error: Duplicate column name 'comment_cat_id'

SQL Error : 1146 Table 'megmouse_phpbb2010.ALBUM_SP_CONFIG_TABLE' doesn't exist

DROP TABLE IF EXISTS `phpbb_album_sp_config