phpBB.nl

Code: Selecteer alles

SQL ERROR [ mysql4 ]

Dubbele ingang '6-0' voor zoeksleutel 1 [1062]

SQL

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) VALUES (6, 88, 1), (6, 93, 1), (6, 109, 1), (6, 114, 1), (6, 87, 1), (6, 89, 1), (6, 92, 1), (6, 116, 1), (6, 94, 1), (6, 110, 1), (6, 111, 1), (6, 112, 1), (6, 96, 1), (6, 97, 1), (6, 98, 1), (6, 99, 1), (6, 100, 1), (6, 101, 1), (6, 102, 1), (6, 105, 1), (6, 106, 1), (6, 107, 1), (6, 108, 1), (6, 113, 1), (6, 0, 1), (6, 0, 1), (6, 85, 1)

BACKTRACE


FILE: includes/db/mysql.php
LINE: 158
CALL: dbal->sql_error()

FILE: includes/db/dbal.php
LINE: 438
CALL: dbal_mysql->sql_query()

FILE: includes/acp/auth.php
LINE: 966
CALL: dbal->sql_multi_insert()

FILE: includes/acp/acp_permission_roles.php
LINE: 214
CALL: auth_admin->acl_set_role()

FILE: includes/functions_module.php
LINE: 471
CALL: acp_permission_roles->main()

FILE: adm/index.php
LINE: 75
CALL: p_master->load_active()

Code: Selecteer alles

CREATE TABLE `phpbb_reputations` (
  `rep_id` mediumint(8) NOT NULL auto_increment,
  `rep_from` mediumint(8) NOT NULL,
  `rep_to` mediumint(8) NOT NULL,
  `rep_time` int(11) NOT NULL,
  `rep_post_id` mediumint(8) NOT NULL,
  `rep_point` int(11) NOT NULL,
  `rep_comment` mediumtext NOT NULL,
  `bbcode_uid` varchar(8) NOT NULL,
  `bbcode_bitfield` varchar(255) NOT NULL,
  `enable_bbcode` tinyint(1) unsigned NOT NULL,
  `enable_smilies` tinyint(1) unsigned NOT NULL,
  `enable_urls` tinyint(1) unsigned NOT NULL,
  PRIMARY KEY  (`rep_id`)
  ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
ALTER TABLE `phpbb_users` ADD `user_reputation` INT( 11 ) NOT NULL ;
ALTER TABLE `phpbb_users` ADD `user_hide_reputation` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_groups` ADD `group_reputation_power` TINYINT( 4 ) NOT NULL DEFAULT '0';
INSERT INTO `phpbb_acl_options` (`auth_option`, `is_global`, `is_local`, `founder_only`) VALUES
('u_rp_give', 1, 0, 0),
('u_rp_view', 1, 0, 0),
('u_rp_disable', 1, 0, 0),
('u_rp_ignore', 1, 0, 0);
INSERT INTO `phpbb_config` (`config_name`, `config_value`) VALUES
('rp_block_per_points', '50'),
('rp_comment_max_chars', '255'),
('rp_display', '2'),
('rp_enable', '0'),
('rp_max_blocks', '10'),
('rp_max_power', '5'),
('rp_membership_days', '365'),
('rp_min_posts', '100'),
('rp_recent_points', '5'),
('rp_reg_bonus', '5'),
('rp_time_limitation', '12'),
('rp_total_posts', '500'),
('rp_user_spread', '10');