phpBB.nl

Nederlandstalige phpBB Support
https://www.phpbb.nl/forums/

fout met a.auth_lock

https://www.phpbb.nl/forums/viewtopic.php?f=45&t=30463

Pagina 1 van 1

fout met a.auth_lock

Geplaatst: 03 jul 2006, 10:39
door marijntjuh55
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?

Geplaatst: 03 jul 2006, 10:42
door Bee
Heb je de SQL wel gedaan?

Geplaatst: 03 jul 2006, 10:43
door Pino1990
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:

Geplaatst: 03 jul 2006, 10:44
door marijntjuh55
Bee schreef:Heb je de SQL wel gedaan?
ja die heb ik gedaan....

Geplaatst: 03 jul 2006, 10:46
door Bee
Deze foutmelding zegt van niet. Ik denk dat je de prefix niet goed heb aangepast.

Geplaatst: 03 jul 2006, 10:46
door marijntjuh55
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......

Geplaatst: 03 jul 2006, 10:47
door marijntjuh55
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? :oops:

Geplaatst: 03 jul 2006, 10:48
door Bee
Nee, die code moet je juist TOEVOEGEN :wink:
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? :oops:
dat is het phpbb_ gedeelte. Bij jouw is dat echter phpbb_a

Geplaatst: 03 jul 2006, 10:49
door marijntjuh55
Bee schreef:Nee, die code moet je juist TOEVOEGEN :wink:
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

Geplaatst: 03 jul 2006, 10:51
door Bee
Volgens mij heb jij een update geinstalleerd, niet een nieuwe installatie.

Geplaatst: 03 jul 2006, 10:53
door marijntjuh55
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 :cry:

Geplaatst: 03 jul 2006, 10:59
door marijntjuh55
Bee schreef:Volgens mij heb jij een update geinstalleerd, niet een nieuwe installatie.
je hebt gelijk dit is een update :shock: f*ck moet ik het hele forum voor de 10 keer opnieuw instaleren :roll:

Geplaatst: 03 jul 2006, 10:59
door Coen
Je kunt ook alle wijzigingen van de update andersom uitvoeren en het zo ongedaan maken... :roll:

Geplaatst: 03 jul 2006, 11:03
door marijntjuh55
Prophecy schreef:Je kunt ook alle wijzigingen van de update andersom uitvoeren en het zo ongedaan maken... :roll:
dan ben ik nog 1 uur bezig....... ik ga het anders aanpakken, gewoon alle bestanden die ik heb bewerkt opnieuw der in zetten
Alle tijden zijn UTC+01:00
Pagina 1 van 1
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/