phpBB.de

Code: Alles auswählen

# Table: phpbb_1acl_groups
DROP TABLE IF EXISTS phpbb_1acl_groups;
CREATE TABLE `phpbb_1acl_groups` (
  `group_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` mediumint(8) unsigned NOT NULL default '0',
  `auth_option_id` mediumint(8) unsigned NOT NULL default '0',
  `auth_role_id` mediumint(8) unsigned NOT NULL default '0',
  `auth_setting` tinyint(2) NOT NULL default '0',
  KEY `group_id` (`group_id`),
  KEY `auth_opt_id` (`auth_option_id`),
  KEY `auth_role_id` (`auth_role_id`)
) TYPE=MyISAM;

Code: Alles auswählen

INSERT INTO phpbb_1acl_groups (group_id, forum_id, auth_option_id, auth_role_id, auth_setting)

Code: Alles auswählen

# Table: phpbb_1acl_options
DROP TABLE IF EXISTS phpbb_1acl_options;
CREATE TABLE `phpbb_1acl_options` (
  `auth_option_id` mediumint(8) unsigned NOT NULL auto_increment,
  `auth_option` varchar(50) binary NOT NULL default '',
  `is_global` tinyint(1) unsigned NOT NULL default '0',
  `is_local` tinyint(1) unsigned NOT NULL default '0',
  `founder_only` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`auth_option_id`),
  KEY `auth_option` (`auth_option`)
) TYPE=MyISAM AUTO_INCREMENT=118;

Code: Alles auswählen

Allgemeiner Fehler
SQL ERROR [ mysqli ]

Unknown column 'a.auth_role_id' in 'field list' [1054]

SQL

SELECT a.forum_id, a.auth_option_id, a.auth_role_id, a.auth_setting FROM phpbb_1acl_groups a, phpbb_1user_group ug, phpbb_1groups g WHERE a.group_id = ug.group_id AND g.group_id = ug.group_id AND ug.user_pending = 0 AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 224

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/auth.php
LINE: 838
CALL: dbal_mysqli->sql_query()

FILE: includes/acp/auth.php
LINE: 1252
CALL: auth->acl_raw_data_single_user()

FILE: ucp.php
LINE: 203
CALL: auth_admin->ghost_permissions()

Code: Alles auswählen

General Error
SQL ERROR [ mysqli ]

Unknown column 'a.auth_role_id' in 'field list' [1054]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.