fout met a.auth_lock

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:39

ik heb net een nieuwe mod geinstaleerd, maar als ik nu op een catorgorie drukt zegt ie:

Failed obtaining forum access control lists

DEBUG MODE

SQL Error : 1054 Unknown column 'a.auth_lock' in 'field list'

SELECT a.forum_id, a.auth_view, a.auth_read, a.auth_post, a.auth_reply, a.auth_edit, a.auth_delete, a.auth_lock, a.auth_sticky, a.auth_announce, a.auth_vote, a.auth_pollcreate, a.auth_mod FROM phpbb_aauth_access a, phpbb_auser_group ug WHERE ug.user_id = 2 AND ug.user_pending = 0 AND a.group_id = ug.group_id AND a.forum_id = 1

Line : 160
File : auth.php

Hoe ga ik dit oplossen?

Bee · Bericht door **Bee** » 03 jul 2006, 10:42

Heb je de SQL wel gedaan?

Pino1990 · Bericht door **Pino1990** » 03 jul 2006, 10:43

Zet eerst ff een backup file terug. Heb je het problem dan nog? Zoniet dan zit het in Auth.php. Kijk dan ff na wat je in dat betand moest veranderen. Kijk dat goed na. Waarschijnlijk heb je daar een foutje gemaakt. Als alles goed is kun je eventueel de veranderingen in de backup file toepassen.

Zo ja, dan zit het dus niet in dat bestand en wordt het een hele uitzoekerij...

Zucces :thumb:

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:44

Bee schreef:Heb je de SQL wel gedaan?

ja die heb ik gedaan....

Bee · Bericht door **Bee** » 03 jul 2006, 10:46

Deze foutmelding zegt van niet. Ik denk dat je de prefix niet goed heb aangepast.

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:46

kijk het enigste wat ik niet heb gedaan is dit:

in de installatie staat dat in het bestand viewtopic.php deze code zit:

Code: Selecteer alles

// START (UN)LOCK POST BY TOPIC STARTER

$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
$lock = ( isset($HTTP_POST_VARS['lock']) ) ? TRUE : FALSE;
$unlock = ( isset($HTTP_POST_VARS['unlock']) ) ? TRUE : FALSE;

if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
	$mode = htmlspecialchars($mode);
}
else
{
	if ( $lock )
	{
		$mode = 'lock';
	}
	else if ( $unlock )
	{
		$mode = 'unlock';
	}
	else
	{
		$mode = '';
	}
}

switch( $mode )
{
	case 'lock':
		if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}

		$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ?  $HTTP_POST_VARS['topic_id_list'] : array($topic_id);

		$topic_id_sql = '';
		for($i = 0; $i < count($topics); $i++)
		{
			$topic_id_sql .= ( ( $topic_id_sql != '' ) ? ', ' : '' ) . intval($topics[$i]);
		}

		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET topic_status = " . TOPIC_LOCKED . " 
			WHERE topic_id IN ($topic_id_sql) 
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

		if ( !empty($topic_id) )
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}
		else
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}

		$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');

		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
		);

		message_die(GENERAL_MESSAGE, $lang['Topics_Locked'] . '<br /><br />' . $message);

		break;

	case 'unlock':
		if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}

		$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ?  $HTTP_POST_VARS['topic_id_list'] : array($topic_id);

		$topic_id_sql = '';
		for($i = 0; $i < count($topics); $i++)
		{
			$topic_id_sql .= ( ( $topic_id_sql != "") ? ', ' : '' ) . intval($topics[$i]);
		}

		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET topic_status = " . TOPIC_UNLOCKED . " 
			WHERE topic_id IN ($topic_id_sql) 
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

		if ( !empty($topic_id) )
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}
		else
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}

		$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');

		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
		);

		message_die(GENERAL_MESSAGE, $lang['Topics_Unlocked'] . '<br /><br />' . $message);

		break;
}

	if ( $forum_topic_data['topic_poster'] == $userdata['user_id'] && $forum_topic_data['topic_status'] == TOPIC_UNLOCKED)
    {	
		$temp_url = "viewtopic.$phpEx?mode=lock&" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
        $lock_img = '<a href="' . $temp_url . '"><img src="' . $images['topic_mod_lock'] . '" alt="' . $lang['Lock_topic'] . '" title="' . $lang['Lock_topic'] . '" border="0" /></a>';
        $lock = '<a href="' . $temp_url . '">' . $lang['Lock_topic'] . '</a>';
    }
	else
	{
	    $lock_img = '';
		$lock = '';
	}
	
// END

maar die zit er niet, dus dat kan ik ook niet bewerken.... maar oor de rest heb ik alles gedaan......

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:47

Bee schreef:Deze foutmelding zegt van niet. Ik denk dat je de prefix niet goed heb aangepast.

sorry maar ik weet niet wat een prefix is, wat is dat?

Bee · Bericht door **Bee** » 03 jul 2006, 10:48

Nee, die code moet je juist TOEVOEGEN

marijntjuh55 schreef:
Bee schreef:Deze foutmelding zegt van niet. Ik denk dat je de prefix niet goed heb aangepast.
sorry maar ik weet niet wat een prefix is, wat is dat?

dat is het phpbb_ gedeelte. Bij jouw is dat echter phpbb_a

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:49

Bee schreef:Nee, die code moet je juist TOEVOEGEN

die moet je niet toevoegen, dit staat er in de instalatie:

Code: Selecteer alles

#-----[ OPEN ]------------------------------------------ 
# 
viewtopic.php

# 
#-----[ FIND ]------------------------------------------ 
# 
$order_sql = ( empty($post_id) ) ? '' : "GROUP BY p.post_id, t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
f.auth_delete,

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
 f.auth_lock,

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "SELECT t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id, f.forum_name, f.forum_status, f.forum_id, f.auth_view, f.auth_read, f.auth_post, f.auth_reply, f.auth_edit, f.auth_delete, f.auth_sticky, f.auth_announce, f.auth_pollcreate, f.auth_vote, f.auth_attachments" . $count_sql . " 

# 
#-----[ IN-LINE FIND ]--------------------------------------------------- 
# 
t.topic_id, t.topic_title, t.topic_status, t.topic_replies, t.topic_time, t.topic_type, t.topic_vote, t.topic_last_post_id 

# 
#-----[ IN-LINE REPLACE WITH ]--------------------------------------------------- 
# 
t.*

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
f.auth_delete,

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
 f.auth_lock,

# 
#-----[ FIND ]------------------------------------------ 
# 
// START (UN)LOCK POST BY TOPIC STARTER

$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
$lock = ( isset($HTTP_POST_VARS['lock']) ) ? TRUE : FALSE;
$unlock = ( isset($HTTP_POST_VARS['unlock']) ) ? TRUE : FALSE;

if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
	$mode = htmlspecialchars($mode);
}
else
{
	if ( $lock )
	{
		$mode = 'lock';
	}
	else if ( $unlock )
	{
		$mode = 'unlock';
	}
	else
	{
		$mode = '';
	}
}

switch( $mode )
{
	case 'lock':
		if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}

		$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ?  $HTTP_POST_VARS['topic_id_list'] : array($topic_id);

		$topic_id_sql = '';
		for($i = 0; $i < count($topics); $i++)
		{
			$topic_id_sql .= ( ( $topic_id_sql != '' ) ? ', ' : '' ) . intval($topics[$i]);
		}

		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET topic_status = " . TOPIC_LOCKED . " 
			WHERE topic_id IN ($topic_id_sql) 
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

		if ( !empty($topic_id) )
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}
		else
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}

		$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');

		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
		);

		message_die(GENERAL_MESSAGE, $lang['Topics_Locked'] . '<br /><br />' . $message);

		break;

	case 'unlock':
		if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}

		$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ?  $HTTP_POST_VARS['topic_id_list'] : array($topic_id);

		$topic_id_sql = '';
		for($i = 0; $i < count($topics); $i++)
		{
			$topic_id_sql .= ( ( $topic_id_sql != "") ? ', ' : '' ) . intval($topics[$i]);
		}

		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET topic_status = " . TOPIC_UNLOCKED . " 
			WHERE topic_id IN ($topic_id_sql) 
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

		if ( !empty($topic_id) )
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}
		else
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}

		$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');

		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
		);

		message_die(GENERAL_MESSAGE, $lang['Topics_Unlocked'] . '<br /><br />' . $message);

		break;
}

	if ( $forum_topic_data['topic_poster'] == $userdata['user_id'] && $forum_topic_data['topic_status'] == TOPIC_UNLOCKED)
    {	
		$temp_url = "viewtopic.$phpEx?mode=lock&" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
        $lock_img = '<a href="' . $temp_url . '"><img src="' . $images['topic_mod_lock'] . '" alt="' . $lang['Lock_topic'] . '" title="' . $lang['Lock_topic'] . '" border="0" /></a>';
        $lock = '<a href="' . $temp_url . '">' . $lang['Lock_topic'] . '</a>';
    }
	else
	{
	    $lock_img = '';
		$lock = '';
	}
	
// END


# 
#-----[ REPLACE WITH ]------------------------------------------ 
# 
// START (UN)LOCK POST BY TOPIC STARTER
if ( $forum_topic_data['topic_poster'] == $userdata['user_id'] && $forum_topic_data['topic_status'] == TOPIC_UNLOCKED && $is_auth['auth_lock'])
{
$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
$lock = ( isset($HTTP_POST_VARS['lock']) ) ? TRUE : FALSE;

if ( isset($HTTP_POST_VARS['mode']) || isset($HTTP_GET_VARS['mode']) )
{
	$mode = ( isset($HTTP_POST_VARS['mode']) ) ? $HTTP_POST_VARS['mode'] : $HTTP_GET_VARS['mode'];
	$mode = htmlspecialchars($mode);
}
else
{
	if ( $lock )
	{
		$mode = 'lock';
	}
	else
	{
		$mode = '';
	}
}

switch( $mode )
{
	case 'lock':
		if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}

		$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ?  $HTTP_POST_VARS['topic_id_list'] : array($topic_id);

		$topic_id_sql = '';
		for($i = 0; $i < count($topics); $i++)
		{
			$topic_id_sql .= ( ( $topic_id_sql != '' ) ? ', ' : '' ) . intval($topics[$i]);
		}

		$sql = "UPDATE " . TOPICS_TABLE . " 
			SET topic_status = " . TOPIC_LOCKED . " 
			WHERE topic_id IN ($topic_id_sql) 
				AND forum_id = $forum_id
				AND topic_moved_id = 0";
		if ( !($result = $db->sql_query($sql)) )
		{
			message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
		}

		if ( !empty($topic_id) )
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}
		else
		{
			$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
			$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
		}

		$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');

		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
		);

		message_die(GENERAL_MESSAGE, $lang['Topics_Locked'] . '<br /><br />' . $message);

		break;
}

	if ( $forum_topic_data['topic_status'] == TOPIC_UNLOCKED )
    {	
		$temp_url = "viewtopic.$phpEx?mode=lock&" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
        $lock_img = '<a href="' . $temp_url . '"><img src="' . $images['topic_mod_lock'] . '" alt="' . $lang['Lock_topic'] . '" title="' . $lang['Lock_topic'] . '" border="0" /></a>';
        $lock = '<a href="' . $temp_url . '">' . $lang['Lock_topic'] . '</a>';

    }
	else
	{
	    $lock_img = '';
		$lock = '';
	}
}
// END

Bee · Bericht door **Bee** » 03 jul 2006, 10:51

Volgens mij heb jij een update geinstalleerd, niet een nieuwe installatie.

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:53

Bee schreef:Volgens mij heb jij een update geinstalleerd, niet een nieuwe installatie.

dat weet ik niet, ik heb hem gedownload bij phpbb.com , en het erge is dat ik alleen maar een database back up heb

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 10:59

Bee schreef:Volgens mij heb jij een update geinstalleerd, niet een nieuwe installatie.

je hebt gelijk dit is een update

f*ck moet ik het hele forum voor de 10 keer opnieuw instaleren

Coen · Bericht door **Coen** » 03 jul 2006, 10:59

Je kunt ook alle wijzigingen van de update andersom uitvoeren en het zo ongedaan maken...

marijntjuh55 · Bericht door **marijntjuh55** » 03 jul 2006, 11:03

Prophecy schreef:Je kunt ook alle wijzigingen van de update andersom uitvoeren en het zo ongedaan maken...

dan ben ik nog 1 uur bezig....... ik ga het anders aanpakken, gewoon alle bestanden die ik heb bewerkt opnieuw der in zetten