[3.2] "doesn't have default value" und Bug in mysql-updater?

Fragen rund um die Installation, Administration und Benutzung von phpBB 3.1.x und höher und die Konvertierung zu phpBB 3.2.x.
Forumsregeln
Bitte im Thementitel den Präfix deiner phpBB-Version [3.1.x] oder [3.2.x] angeben.
Semako
Mitglied
Beiträge: 16
Registriert: 01.05.2019 11:47

[3.2] "doesn't have default value" und Bug in mysql-updater?

Beitragvon Semako » 14.05.2019 11:19

Ich habe es nun geschafft, mithilfe des World4You-Supports die MySQL-Big-Select-Fehlermeldung beim Ansehen eines Themas, während man eingeloggt ist, zu beheben.
Nun habe ich das nächste Problem: Wenn ich einen Beitrag posten will, gibt es eine MySQL-Fehlermeldung

Code: Alles auswählen

SQL ERROR [ mysqli ]

Field 'post_id' doesn't have a default value [1364]

SQL

INSERT INTO phpbb3_posts (forum_id, poster_id, icon_id, poster_ip, post_time, post_visibility, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, post_username, post_subject, post_text, post_checksum, post_attachment, bbcode_bitfield, bbcode_uid, post_postcount, post_edit_locked, topic_id) VALUES (100, 23407, 0, '78.104.15.100', 1557825249, 1, 1, 1, 1, 1, '', 'Re: ECTS in VO+UE Lateinische Formenlehre und Syntax', '<t>Test</t>', '0cbc6611f5540bd0809a388dc95a615b', 0, '', '1pflivf', 1, 0, 159277)

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/includes/functions_posting.php
LINE: 1893
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/posting.php
LINE: 1457
CALL: submit_post()


Ich habe also recherchiert und in der Knoqledgebase von phpBB.com diese Anleitung gefunden: https://www.phpbb.com/support/docs/en/3 ... ue-errors/

Wenn ich allerdings die von mysql_updater.php generierten MySQL-Befehle in meiner Datenbank via phpMyAdmin ausführe, erhalte ich ebenfalls eine Fehlermeldung:

Code: Alles auswählen

Statische Analyse:

3 Fehler wurden während der Analyse gefunden.

    Missing comma before start of a new alter operation. (near "COLLATE" at position 184)
    Missing comma before start of a new alter operation. (near "DEFAULT CHARSET" at position 385)
    Unerkannte ALTER-Operation. (near "DEFAULT CHARSET" at position 385)

SQL-Befehl:

# Table: 'phpbb3_acl_options' ALTER TABLE phpbb3_acl_options MODIFY auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY auth_option varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin, MODIFY is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, MODIFY founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL, DEFAULT CHARSET=utf8 COLLATE=utf8_bin

MySQL meldet: Dokumentation
#1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key


Die MySQL-Befehle sind folgende:

Code: Alles auswählen

USE...

# Table: 'phpbb3_acl_groups'
ALTER TABLE phpbb3_acl_groups
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_acl_options'
ALTER TABLE phpbb3_acl_options
MODIFY auth_option_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY auth_option varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY is_global tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY is_local tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY founder_only tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_acl_roles'
ALTER TABLE phpbb3_acl_roles
MODIFY role_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY role_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY role_description text NOT NULL COLLATE utf8_bin,
MODIFY role_type varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY role_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_acl_roles_data'
ALTER TABLE phpbb3_acl_roles_data
MODIFY role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_acl_users'
ALTER TABLE phpbb3_acl_users
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_role_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY auth_setting tinyint(2) DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_attachments'
ALTER TABLE phpbb3_attachments
MODIFY attach_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY post_msg_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY in_message tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY is_orphan tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY physical_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY real_filename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY download_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY attach_comment text NOT NULL COLLATE utf8_bin,
MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY mimetype varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY filetime int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY thumbnail tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_banlist'
ALTER TABLE phpbb3_banlist
MODIFY ban_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY ban_userid INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY ban_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY ban_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY ban_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY ban_end int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY ban_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY ban_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY ban_give_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DROP INDEX ban_email,
ADD KEY ban_email (ban_email, ban_exclude),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_bbcodes'
ALTER TABLE phpbb3_bbcodes
MODIFY bbcode_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_tag varchar(16) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_helpline varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_match text NOT NULL COLLATE utf8_bin,
MODIFY bbcode_tpl mediumtext NOT NULL COLLATE utf8_bin,
MODIFY first_pass_match mediumtext NOT NULL COLLATE utf8_bin,
MODIFY first_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
MODIFY second_pass_match mediumtext NOT NULL COLLATE utf8_bin,
MODIFY second_pass_replace mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_bookmarks'
ALTER TABLE phpbb3_bookmarks
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_bots'
ALTER TABLE phpbb3_bots
MODIFY bot_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY bot_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY bot_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bot_agent varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bot_ip varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_config'
ALTER TABLE phpbb3_config
MODIFY config_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY config_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY is_dynamic tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_config_text'
ALTER TABLE phpbb3_config_text
MODIFY config_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY config_value mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_confirm'
ALTER TABLE phpbb3_confirm
MODIFY confirm_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY confirm_type tinyint(3) DEFAULT '0' NOT NULL,
MODIFY code varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY seed int(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY attempts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_disallow'
ALTER TABLE phpbb3_disallow
MODIFY disallow_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY disallow_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_drafts'
ALTER TABLE phpbb3_drafts
MODIFY draft_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY save_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY draft_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY draft_message mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_ext'
ALTER TABLE phpbb3_ext
MODIFY ext_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY ext_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY ext_state text NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_extension_groups'
ALTER TABLE phpbb3_extension_groups
MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY cat_id tinyint(2) DEFAULT '0' NOT NULL,
MODIFY allow_group tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY download_mode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY upload_icon varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY max_filesize int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY allowed_forums text NOT NULL COLLATE utf8_bin,
MODIFY allow_in_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_extensions'
ALTER TABLE phpbb3_extensions
MODIFY extension_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY extension varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_forums'
ALTER TABLE phpbb3_forums
MODIFY forum_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_parents mediumtext NOT NULL COLLATE utf8_bin,
MODIFY forum_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_desc text NOT NULL COLLATE utf8_bin,
MODIFY forum_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY forum_desc_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_password varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_rules text NOT NULL COLLATE utf8_bin,
MODIFY forum_rules_link varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_rules_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_rules_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY forum_rules_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_topics_per_page smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_status tinyint(4) DEFAULT '0' NOT NULL,
MODIFY forum_last_post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_poster_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY forum_flags tinyint(4) DEFAULT '32' NOT NULL,
MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_indexing tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_icons tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_next int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_days mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_viewed mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_freq mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY display_subforum_list tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY forum_options int(20) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_shadow_prune tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY prune_shadow_days mediumint(8) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY prune_shadow_freq mediumint(8) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY prune_shadow_next int(11) DEFAULT '0' NOT NULL,
MODIFY forum_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_topics_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_forums_access'
ALTER TABLE phpbb3_forums_access
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_forums_track'
ALTER TABLE phpbb3_forums_track
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_forums_watch'
ALTER TABLE phpbb3_forums_watch
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_groups'
ALTER TABLE phpbb3_groups
MODIFY group_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY group_type tinyint(4) DEFAULT '1' NOT NULL,
MODIFY group_founder_manage tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_skip_auth tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_desc text NOT NULL COLLATE utf8_bin,
MODIFY group_desc_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_desc_options int(11) UNSIGNED DEFAULT '7' NOT NULL,
MODIFY group_desc_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_display tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_avatar_type varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_sig_chars mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_receive_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_message_limit mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_legend mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_max_recipients mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX group_legend_name,
ADD KEY group_legend_name (group_legend, group_name),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_icons'
ALTER TABLE phpbb3_icons
MODIFY icons_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY icons_url varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY icons_width tinyint(4) DEFAULT '0' NOT NULL,
MODIFY icons_height tinyint(4) DEFAULT '0' NOT NULL,
MODIFY icons_alt varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY icons_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_lang'
ALTER TABLE phpbb3_lang
MODIFY lang_id tinyint(4) NOT NULL auto_increment,
MODIFY lang_iso varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_dir varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_english_name varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_local_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_author varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_log'
ALTER TABLE phpbb3_log
MODIFY log_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY log_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY reportee_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY log_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY log_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY log_operation text NOT NULL COLLATE utf8_bin,
MODIFY log_data mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_login_attempts'
ALTER TABLE phpbb3_login_attempts
MODIFY attempt_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY attempt_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY attempt_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY attempt_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY username varchar(255) DEFAULT '0' NOT NULL COLLATE utf8_bin,
MODIFY username_clean varchar(255) DEFAULT '0' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_migrations'
ALTER TABLE phpbb3_migrations
MODIFY migration_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY migration_depends_on text NOT NULL COLLATE utf8_bin,
MODIFY migration_schema_done tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY migration_data_done tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY migration_data_state text NOT NULL COLLATE utf8_bin,
MODIFY migration_start_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY migration_end_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_moderator_cache'
ALTER TABLE phpbb3_moderator_cache
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY display_on_index tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_modules'
ALTER TABLE phpbb3_modules
MODIFY module_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY module_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY module_display tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY module_basename varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY module_class varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY left_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY right_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY module_langname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY module_mode varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY module_auth varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_notification_types'
ALTER TABLE phpbb3_notification_types
MODIFY notification_type_id smallint(4) UNSIGNED NOT NULL auto_increment,
MODIFY notification_type_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY notification_type_enabled tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_notifications'
ALTER TABLE phpbb3_notifications
MODIFY notification_id int(10) UNSIGNED NOT NULL auto_increment,
MODIFY notification_type_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY item_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY item_parent_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notification_read tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notification_time int(11) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY notification_data text NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_oauth_accounts'
ALTER TABLE phpbb3_oauth_accounts
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY provider varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY oauth_provider_id text NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_oauth_states'
ALTER TABLE phpbb3_oauth_states
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY provider varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY oauth_state varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_oauth_tokens'
ALTER TABLE phpbb3_oauth_tokens
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY provider varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY oauth_token mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_poll_options'
ALTER TABLE phpbb3_poll_options
MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_option_text text NOT NULL COLLATE utf8_bin,
MODIFY poll_option_total mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_poll_votes'
ALTER TABLE phpbb3_poll_votes
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_option_id tinyint(4) DEFAULT '0' NOT NULL,
MODIFY vote_user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY vote_user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_posts'
ALTER TABLE phpbb3_posts
MODIFY post_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poster_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY post_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY post_checksum varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_postcount tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY post_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_edit_user INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_edit_locked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_visibility tinyint(3) DEFAULT '0' NOT NULL,
MODIFY post_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_delete_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY post_delete_user INT(10) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_privmsgs'
ALTER TABLE phpbb3_privmsgs
MODIFY msg_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY root_level mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY enable_sig tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY message_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY message_edit_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_edit_user INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY message_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY message_edit_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY message_edit_count smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY to_address text NOT NULL COLLATE utf8_bin,
MODIFY bcc_address text NOT NULL COLLATE utf8_bin,
MODIFY message_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_privmsgs_folder'
ALTER TABLE phpbb3_privmsgs_folder
MODIFY folder_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY folder_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pm_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_privmsgs_rules'
ALTER TABLE phpbb3_privmsgs_rules
MODIFY rule_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rule_check mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rule_connection mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rule_string varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY rule_user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rule_group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rule_action mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rule_folder_id int(11) DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_privmsgs_to'
ALTER TABLE phpbb3_privmsgs_to
MODIFY msg_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY author_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pm_deleted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pm_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY pm_unread tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY pm_replied tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pm_marked tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pm_forwarded tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY folder_id int(11) DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_profile_fields'
ALTER TABLE phpbb3_profile_fields
MODIFY field_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY field_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_type varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_ident varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_length varchar(20) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_minlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_maxlen varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_novalue varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_validation varchar(64) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_no_view tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_active tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_profile tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_novalue tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_show_on_ml tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_is_contact tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_contact_desc varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY field_contact_url varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_profile_fields_data'
ALTER TABLE phpbb3_profile_fields_data
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY pf_phpbb_interests mediumtext NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_occupation mediumtext NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_skype varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_googleplus varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_twitter varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_location varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_icq varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_youtube varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_facebook varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_website varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_yahoo varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY pf_phpbb_aol varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_profile_fields_lang'
ALTER TABLE phpbb3_profile_fields_lang
MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY option_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY field_type varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_profile_lang'
ALTER TABLE phpbb3_profile_lang
MODIFY field_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY lang_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY lang_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY lang_explain text NOT NULL COLLATE utf8_bin,
MODIFY lang_default_value varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_ranks'
ALTER TABLE phpbb3_ranks
MODIFY rank_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY rank_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY rank_min mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rank_special tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY rank_image varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_reports'
ALTER TABLE phpbb3_reports
MODIFY report_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY reason_id smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY report_closed tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY report_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY pm_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY reported_post_enable_bbcode tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY reported_post_enable_smilies tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY reported_post_enable_magic_url tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY reported_post_text mediumtext NOT NULL COLLATE utf8_bin,
MODIFY reported_post_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY reported_post_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_reports_reasons'
ALTER TABLE phpbb3_reports_reasons
MODIFY reason_id smallint(4) UNSIGNED NOT NULL auto_increment,
MODIFY reason_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY reason_description mediumtext NOT NULL COLLATE utf8_bin,
MODIFY reason_order smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_search_results'
ALTER TABLE phpbb3_search_results
MODIFY search_key varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY search_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY search_keywords mediumtext NOT NULL COLLATE utf8_bin,
MODIFY search_authors mediumtext NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_search_wordlist'
ALTER TABLE phpbb3_search_wordlist
MODIFY word_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY word_text varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY word_common tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY word_count mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX wrd_txt,
ADD UNIQUE wrd_txt (word_text),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_search_wordmatch'
ALTER TABLE phpbb3_search_wordmatch
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY word_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY title_match tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_sessions'
ALTER TABLE phpbb3_sessions
MODIFY session_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_last_visit int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_browser varchar(150) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_forwarded_for varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_page varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY session_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY session_autologin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_admin tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY session_forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_sessions_keys'
ALTER TABLE phpbb3_sessions_keys
MODIFY key_id char(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY last_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY last_login int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_sitelist'
ALTER TABLE phpbb3_sitelist
MODIFY site_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY site_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY site_hostname varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY ip_exclude tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_smilies'
ALTER TABLE phpbb3_smilies
MODIFY smiley_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY code varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY emotion varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY smiley_url varchar(50) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY smiley_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY smiley_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY smiley_order mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY display_on_posting tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_styles'
ALTER TABLE phpbb3_styles
MODIFY style_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY style_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY style_copyright varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY style_path varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY bbcode_bitfield varchar(255) DEFAULT 'kNg=' NOT NULL COLLATE utf8_bin,
MODIFY style_parent_id int(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY style_parent_tree text NOT NULL COLLATE utf8_bin,
DROP INDEX style_name,
ADD UNIQUE style_name (style_name),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_teampage'
ALTER TABLE phpbb3_teampage
MODIFY teampage_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY teampage_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY teampage_position mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY teampage_parent mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_topics'
ALTER TABLE phpbb3_topics
MODIFY topic_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY icon_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_attachment tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_reported tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY topic_poster INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_time_limit int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_views mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_status tinyint(3) DEFAULT '0' NOT NULL,
MODIFY topic_type tinyint(3) DEFAULT '0' NOT NULL,
MODIFY topic_first_post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_first_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_unicode_ci,
MODIFY topic_first_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_last_post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_last_poster_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_last_poster_name varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_last_poster_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_last_post_subject varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_last_post_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_last_view_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_moved_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_bumped tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_bumper mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_title varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY poll_start int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_length int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_max_options tinyint(4) DEFAULT '1' NOT NULL,
MODIFY poll_last_vote int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY poll_vote_change tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_visibility tinyint(3) DEFAULT '0' NOT NULL,
MODIFY topic_delete_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_delete_reason varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY topic_delete_user INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posts_approved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posts_unapproved mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posts_softdeleted mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_topics_posted'
ALTER TABLE phpbb3_topics_posted
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_posted tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_topics_track'
ALTER TABLE phpbb3_topics_track
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY mark_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_topics_watch'
ALTER TABLE phpbb3_topics_watch
MODIFY topic_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY notify_status tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_user_group'
ALTER TABLE phpbb3_user_group
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY group_leader tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_pending tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_user_notifications'
ALTER TABLE phpbb3_user_notifications
MODIFY item_type varchar(165) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY item_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY method varchar(165) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY notify tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_users'
ALTER TABLE phpbb3_users
MODIFY user_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY user_type tinyint(2) DEFAULT '0' NOT NULL,
MODIFY group_id mediumint(8) UNSIGNED DEFAULT '3' NOT NULL,
MODIFY user_permissions mediumtext NOT NULL COLLATE utf8_bin,
MODIFY user_perm_from mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_ip varchar(40) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_regdate int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY username varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY username_clean varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_password varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_passchg int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_email varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_email_hash bigint(20) DEFAULT '0' NOT NULL,
MODIFY user_birthday varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_lastvisit int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lastmark int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lastpost_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lastpage varchar(200) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_last_confirm_key varchar(10) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_last_search int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_warnings tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_last_warning int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_login_attempts tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_inactive_reason tinyint(2) DEFAULT '0' NOT NULL,
MODIFY user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_lang varchar(30) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_timezone varchar(100) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_dateformat varchar(64) DEFAULT 'd M Y H:i' NOT NULL COLLATE utf8_bin,
MODIFY user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_colour varchar(6) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_new_privmsg int(4) DEFAULT '0' NOT NULL,
MODIFY user_unread_privmsg int(4) DEFAULT '0' NOT NULL,
MODIFY user_last_privmsg int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_message_rules tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_full_folder int(11) DEFAULT '-3' NOT NULL,
MODIFY user_emailtime int(11) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_topic_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_topic_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin,
MODIFY user_topic_sortby_dir varchar(1) DEFAULT 'd' NOT NULL COLLATE utf8_bin,
MODIFY user_post_show_days smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_post_sortby_type varchar(1) DEFAULT 't' NOT NULL COLLATE utf8_bin,
MODIFY user_post_sortby_dir varchar(1) DEFAULT 'a' NOT NULL COLLATE utf8_bin,
MODIFY user_notify tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_notify_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_notify_type tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_allow_pm tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_allow_viewonline tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_allow_viewemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_allow_massemail tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_options int(11) UNSIGNED DEFAULT '230271' NOT NULL,
MODIFY user_avatar varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_avatar_type varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_avatar_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_avatar_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY user_sig mediumtext NOT NULL COLLATE utf8_bin,
MODIFY user_sig_bbcode_uid varchar(8) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_sig_bbcode_bitfield varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_jabber varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_actkey varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_newpasswd varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_form_salt varchar(32) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY user_new tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,
MODIFY user_reminded tinyint(4) DEFAULT '0' NOT NULL,
MODIFY user_reminded_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DROP INDEX username_clean,
ADD UNIQUE username_clean (username_clean),
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_warnings'
ALTER TABLE phpbb3_warnings
MODIFY warning_id mediumint(8) UNSIGNED NOT NULL auto_increment,
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY post_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY log_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY warning_time int(11) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_words'
ALTER TABLE phpbb3_words
MODIFY word_id INT(10) UNSIGNED NOT NULL auto_increment,
MODIFY word varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
MODIFY replacement varchar(255) DEFAULT '' NOT NULL COLLATE utf8_bin,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


# Table: 'phpbb3_zebra'
ALTER TABLE phpbb3_zebra
MODIFY user_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY zebra_id INT(10) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY friend tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
MODIFY foe tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,
DEFAULT CHARSET=utf8 COLLATE=utf8_bin;


Wo ist hier das Problem?

Benutzeravatar
Mahony
Ehemaliger
Beiträge: 11895
Registriert: 17.11.2005 22:33
Wohnort: Esslingen (Neckar)
Kontaktdaten:

Re: [3.2] "doesn't have default value" und Bug in mysql-updater?

Beitragvon Mahony » 14.05.2019 11:48

Hallo
Field 'post_id' doesn't have a default value [1364]

Bedeutet: Das Feld "post_id" in der Tabelle phpbb3_posts hat keinen eingetragenen Standardwert.

Du solltest mal per phpmyadmin (oder Mysqldumper) die Einstellungen des Feldes überprüfen. Bei mir sehen diese so aus -->
http://phpbb3-support.square7.ch/Feld_post_id.JPG <<-- wichtig wäre hier die Einstellung AUTO_INCREMENT


Grüße: Mahony
Taekwondo in Berlin
Wer fragt, ist ein Narr für fünf Minuten, wer nicht fragt, ist ein Narr für immer.

Semako
Mitglied
Beiträge: 16
Registriert: 01.05.2019 11:47

Re: [3.2] "doesn't have default value" und Bug in mysql-updater?

Beitragvon Semako » 14.05.2019 12:04

Genau darum geht es ja, das will ich nach der Anleitung in der Knowledgebase beheben.

Leider kann ich Autoincrement nicht aktivieren, weil ich da eine Fehlermeldung bekomme, es dürfe nur ein Feld damit geben und dieses müsse ein "Key" sein.

Automatisch dem Beitrag hinzugefügt nach 11 Minuten 44 Sekunden. Bitte Regel für „Topic-Bumping“ beachten. Danke.

Habe testweise als Standardwert 0 (nicht NULL) im Feld post_id und auch in notification_id in der notifications-Tabelle festgelegt. Dann konnte ich Beiträge verfassen - allerdings sind dann die anderen Posts im Thema, außer dem Eingangspost, verschwunden. Löschen kann ich die Testbeiträge auch nicht, weil dann die Meldung kommt, die Nachricht würde nicht existieren.

Benutzeravatar
Mahony
Ehemaliger
Beiträge: 11895
Registriert: 17.11.2005 22:33
Wohnort: Esslingen (Neckar)
Kontaktdaten:

Re: [3.2] "doesn't have default value" und Bug in mysql-updater?

Beitragvon Mahony » 14.05.2019 12:33

Hallo
Klick mal bei post_id auf Primärschlüssel >>> siehe http://phpbb3-support.square7.ch/post_id.JPG


Grüße: Mahony
Taekwondo in Berlin
Wer fragt, ist ein Narr für fünf Minuten, wer nicht fragt, ist ein Narr für immer.

Semako
Mitglied
Beiträge: 16
Registriert: 01.05.2019 11:47

Re: [3.2] "doesn't have default value" und Bug in mysql-updater?

Beitragvon Semako » 14.05.2019 17:43

Danke, das hat geholfen. Musste auch bei ein paar anderen Tabellen den Primärschlüssel setzen und Autoincrement aktivieren, jetzt läuft es.


Zurück zu „Support-Forum“