phpBB.de

Code: Alles auswählen

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

SQL

INSERT INTO phpbb_privmsgs (root_level, author_id, icon_id, author_ip, message_time, enable_bbcode, enable_smilies, enable_magic_url, enable_sig, message_subject, message_text, message_attachment, bbcode_bitfield, bbcode_uid, to_address, bcc_address, message_reported) VALUES (0, '2', 0, '79.247.123.39', 1265048747, 1, 1, 1, 1, 'Test', 'Test', 0, '', '16951tio', 'u_55', '', 0)

BACKTRACE

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

FILE: includes/functions_privmsgs.php
LINE: 1441
CALL: dbal_mysqli->sql_query()

FILE: includes/ucp/ucp_pm_compose.php
LINE: 741
CALL: submit_pm()

FILE: includes/ucp/ucp_pm.php
LINE: 133
CALL: compose_pm()

FILE: includes/functions_module.php
LINE: 507
CALL: ucp_pm->main()

FILE: ucp.php
LINE: 321
CALL: p_master->load_active()

Code: Alles auswählen

SQL-Befehl:

# Table: 'phpbb_posts' ALTER TABLE phpbb_posts MODIFY post_id mediumint(8) UNSIGNED NOT NULL auto_increment, MODIFY topic_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY forum_id mediumint(8) UNSIGNED DEFAULT '0' NOT NULL, MODIFY poster_id mediumint(8) 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_approved tinyint(1) UNSIGNED DEFAULT '1' 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 CO[...]

MySQL meldet: Dokumentation
#1091 - Can't DROP 'post_username'; check that column/key exists