phpBB.de

Code: Alles auswählen

SQL Error : 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key

CREATE TABLE phpbb_banlist( meta_id int(11) NOT NULL, ban_id mediumint(8) unsigned NOT NULL auto_increment, ban_userid mediumint(8) NOT NULL, ban_ip char(8) NOT NULL, ban_email varchar(255), KEY ban_ip_user_id (ban_ip, ban_userid) )

Code: Alles auswählen

Error importing backup file

DEBUG MODE

SQL Error : 1146 Table 'phpbb.phpbb_auth_access' doesn't exist

INSERT INTO phpbb_auth_access (group_id, forum_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate, auth_attachments, auth_mod) VALUES('2', '8', '1', '1', '1', '1', '1', '1', '1', '0', '1', '1', '0', '0')

Line : 980
File : admin_db_utilities.php

Code: Alles auswählen

DROP TABLE IF EXISTS phpbb_auth_access;
CREATE TABLE phpbb_auth_access(
	group_id mediumint(8) NOT NULL,
	forum_id smallint(5) unsigned NOT NULL,
	auth_view tinyint(1) NOT NULL,
	auth_read tinyint(1) NOT NULL,
	auth_post tinyint(1) NOT NULL,
	auth_reply tinyint(1) NOT NULL,
	auth_edit tinyint(1) NOT NULL,
	auth_delete tinyint(1) NOT NULL,
	auth_sticky tinyint(1) NOT NULL,
	auth_announce tinyint(1) NOT NULL,
	auth_vote tinyint(1) NOT NULL,
	auth_pollcreate tinyint(1) NOT NULL,
	auth_attachments tinyint(1) NOT NULL,
	auth_mod tinyint(1) NOT NULL, 
	KEY group_id (group_id), 
	KEY forum_id (forum_id)
);

Code: Alles auswählen

Fehler

SQL-Befehl:

# # Table Data for phpbb2_users # INSERT INTO phpbb2_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_login_tries, user_last_login_try, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('-1', '0', 'Anonymous', '', '0', '0', '0', '0', '0', '2', '0.00', NULL, 'german', '', '0', '0', '0', '0', '0', NULL, '0', '0', '0', '1', '1', '1', '0', '1', '0', '1', '0', NULL, '', '0', '', '', '', '', '', NULL, '', '', '', '',[...]

MySQL meldet: Dokumentation
#1054 - Unknown column 'user_login_tries' in 'field list' 

Code: Alles auswählen

DROP TABLE IF EXISTS phpbb_sessions_keys;
CREATE TABLE phpbb_sessions_keys (
  key_id varchar(32) DEFAULT '0' NOT NULL,
  user_id mediumint(8) DEFAULT '0' NOT NULL,
  last_ip varchar(8) DEFAULT '0' NOT NULL,
  last_login int(11) DEFAULT '0' NOT NULL,
  PRIMARY KEY (key_id, user_id),
  KEY last_login (last_login)
);

ALTER TABLE phpbb_users ADD user_login_tries smallint(5) UNSIGNED DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_users ADD user_last_login_try int(11) DEFAULT '0' NOT NULL;

INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_login_attempts', '5');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('login_reset_time', '30');

Code: Alles auswählen

[phpBB Debug] PHP Notice: in file /install/convertors/functions_phpbb20.php on line 412: include(./../../phpBB2/language/lang_german/lang_main.php) [function.include]: failed to open stream: No such file or directory
[phpBB Debug] PHP Notice: in file /install/convertors/functions_phpbb20.php on line 412: include() [function.include]: Failed opening './../../phpBB2/language/lang_german/lang_main.php' for inclusion (include_path='.;C:/xampp/php/PEAR')