phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Code: Alles auswählen
MySQL meldet: Dokumentation
#1054 - Unknown column 'field_show_on_pm' in 'field list' phpbb_profile_fieldsCode: Alles auswählen
INSERT INTO `phpbb_profile_fields` (`field_id`, `field_name`, `field_type`, `field_ident`, `field_length`, `field_minlen`, `field_maxlen`, `field_novalue`, `field_default_value`, `field_validation`, `field_required`, `field_show_on_reg`, `field_hide`, `field_no_view`, `field_active`, `field_order`, `field_show_profile`, `field_show_on_vt`, `field_show_novalue`, `field_show_on_pm`, `field_show_on_ml`, `field_is_contact`, `field_contact_desc`, `field_contact_url`) VALUES
(1, 'phpbb_location', 'profilefields.type.string', 'phpbb_location', '20', '2', '100', '', '', '.*', 0, 0, 0, 0, 1, 1, 1, 1, 0, 1, 1, 0, '', ''),
(2, 'phpbb_website', 'profilefields.type.url', 'phpbb_website', '40', '12', '255', '', '', '', 0, 0, 0, 0, 1, 2, 1, 1, 0, 1, 1, 1, 'VISIT_WEBSITE', '%s'),
(3, 'phpbb_interests', 'profilefields.type.text', 'phpbb_interests', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 3, 1, 0, 0, 0, 0, 0, '', ''),
(4, 'phpbb_occupation', 'profilefields.type.text', 'phpbb_occupation', '3|30', '2', '500', '', '', '.*', 0, 0, 0, 0, 0, 4, 1, 0, 0, 0, 0, 0, '', ''),
(5, 'phpbb_aol', 'profilefields.type.string', 'phpbb_aol', '40', '5', '255', '', '', '.*', 0, 0, 0, 0, 0, 5, 1, 1, 0, 1, 1, 1, '', ''),
(6, 'phpbb_icq', 'profilefields.type.string', 'phpbb_icq', '20', '3', '15', '', '', '[0-9]+', 0, 0, 0, 0, 0, 6, 1, 1, 0, 1, 1, 1, 'SEND_ICQ_MESSAGE', 'https://www.icq.com/people/%s/'),
(7, 'phpbb_wlm', 'profilefields.type.string', 'phpbb_wlm', '40', '5', '255', '', '', '.*', 0, 0, 0, 0, 0, 7, 1, 1, 0, 1, 1, 1, '', ''),
(8, 'phpbb_yahoo', 'profilefields.type.string', 'phpbb_yahoo', '40', '5', '255', '', '', '.*', 0, 0, 0, 0, 0, 8, 1, 1, 0, 1, 1, 1, 'SEND_YIM_MESSAGE', 'ymsgr:sendim?%s'),
(9, 'phpbb_facebook', 'profilefields.type.string', 'phpbb_facebook', '20', '5', '50', '', '', '[a-zA-Z0-9.]+', 0, 0, 0, 0, 1, 9, 1, 1, 0, 1, 1, 1, 'VIEW_FACEBOOK_PROFILE', 'http://facebook.com/%s/'),
(10, 'phpbb_twitter', 'profilefields.type.string', 'phpbb_twitter', '20', '1', '15', '', '', '[\\w]+', 0, 0, 0, 0, 1, 10, 1, 1, 0, 1, 1, 1, 'VIEW_TWITTER_PROFILE', 'http://twitter.com/%s'),
(11, 'phpbb_skype', 'profilefields.type.string', 'phpbb_skype', '20', '6', '32', '', '', '[a-zA-Z][\\w\\.,\\-]+', 0, 0, 0, 0, 1, 11, 1, 1, 0, 1, 1, 1, 'VIEW_SKYPE_PROFILE', 'skype:%s?userinfo'),
(12, 'phpbb_youtube', 'profilefields.type.string', 'phpbb_youtube', '20', '3', '60', '', '', '[a-zA-Z][\\w\\.,\\-]+', 0, 0, 0, 0, 1, 12, 1, 1, 0, 1, 1, 1, 'VIEW_YOUTUBE_CHANNEL', 'http://youtube.com/user/%s'),
(13, 'phpbb_googleplus', 'profilefields.type.googleplus', 'phpbb_googleplus', '20', '3', '255', '', '', '[a-zA-Z0-9]+', 0, 0, 0, 0, 1, 13, 1, 1, 0, 1, 1, 1, 'VIEW_GOOGLEPLUS_PROFILE', 'http://plus.google.com/%s');
Code: Alles auswählen
CREATE TABLE IF NOT EXISTS `phpbb_profile_fields` (
`field_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`field_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_type` varchar(100) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_ident` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_length` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_minlen` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_maxlen` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_novalue` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_default_value` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_validation` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_required` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_show_on_reg` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_hide` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_no_view` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_order` mediumint(8) unsigned NOT NULL DEFAULT '0',
`field_show_profile` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_show_on_vt` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_show_novalue` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_show_on_pm` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_show_on_ml` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_is_contact` tinyint(1) unsigned NOT NULL DEFAULT '0',
`field_contact_desc` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`field_contact_url` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
PRIMARY KEY (`field_id`),
KEY `fld_type` (`field_type`),
KEY `fld_ordr` (`field_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=14 ;Code: Alles auswählen
MySQL meldet: Dokumentation
#1054 - Unknown column 'field_show_on_pm' in 'field list'
SQL-Befehl(e) in Datenbank dbXXXXXXXXX ausführen: