phpBB.nl

Code: Selecteer alles

Could not select Calendar permission from user/usergroup table 

DEBUG MODE 

SQL Error : 1054 Unknown column 'group_calendar_perm' in 'field list' 

SELECT group_calendar_perm FROM phpbb_user_group ug, phpbb_groups g WHERE ug.user_id = '20' AND g.group_id = ug.group_id 

Line : 1271 
File : cal_lite.php

Code: Selecteer alles

ALTER TABLE phpbb_groups ADD group_calendar_perm TINYINT(1) UNSIGNED DEFAULT "0" NOT NULL;
ALTER TABLE phpbb_users ADD user_calendar_perm TINYINT(1) UNSIGNED DEFAULT "0" NOT NULL;

Code: Selecteer alles

ALTER TABLE phpbb_groups ADD group_calendar_perm TINYINT(1) UNSIGNED DEFAULT "0" NOT NULL; 
ALTER TABLE phpbb_users ADD user_calendar_perm TINYINT(1) UNSIGNED DEFAULT "0" NOT NULL;

Code: Selecteer alles

Fout 
SQL-query: 

ALTER TABLE phpbb_groups ADD group_calendar_perm TINYINT( 1 ) UNSIGNED DEFAULT "0" NOT NULL 
MySQL retourneerde:  

#1060 - Duplicate column name 'group_calendar_perm' 
 

Code: Selecteer alles

	if ( !($result = $db->sql_query($sql)) )
	{
		message_die(GENERAL_ERROR, 'Could not select Calendar permission from user table', '', __LINE__, __FILE__, $sql);
	}
	$row = $db->sql_fetchrow($result);

	// Get the group permissions second.
	$sql2 = 'SELECT group_calendar_perm FROM ' . $table_prefix. 'user_group ug, ' . $table_prefix. "groups g 
		WHERE ug.user_id = '$user_id' AND g.group_id = ug.group_id";
	if ( !($result2 = $db->sql_query($sql2)) )
	{
		message_die(GENERAL_ERROR, 'Could not select Calendar permission from user/usergroup table', '', __LINE__, __FILE__, $sql2);
	}
	$topgroup = 0;
	while($rowg = $db->sql_fetchrow($result2)) {
		if($topgroup < $rowg['group_calendar_perm']) {
			$topgroup = $rowg['group_calendar_perm']; 
			}
		}

	// Use whichever value is highest.

Code: Selecteer alles

   // Get the group permissions second.
   $sql2 = 'SELECT group_calendar_perm FROM ' . $table_prefix. 'user_group ug, ' . $table_prefix. "groups g
      WHERE ug.user_id = '$user_id' AND g.group_id = ug.group_id"; 

Code: Selecteer alles

   // Get the group permissions second.
   $sql2 = 'SELECT g.group_calendar_perm FROM ' . $table_prefix. 'user_group ug, ' . $table_prefix. "groups g
      WHERE ug.user_id = '$user_id' AND g.group_id = ug.group_id";