マルクとキャンディとミミのブロッグ

phpBB3 3.0.X (newest version is 3.0.7 PL-1)

SQL ERROR [ mysql4 ]

Field ‘topic_last_post_subject’ doesn’t have a default value [1364]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_approved, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment) VALUES (53, 1249299473, 1249299473, 23, 0, 1, ‘PETER AND HIS MUM’, ‘ecdysis’, ’00AA00′, 0, 0, 0)

BACKTRACE

FILE: includes/db/mysql.php

LINE: 174

CALL: dbal->sql_error()

FILE: includes/functions_posting.php

LINE: 1897

CALL: dbal_mysql->sql_query()

FILE: posting.php

LINE: 1023

CALL: submit_post()

如果 topic_last_post_subject 的欄位型態是 BLOB ，請先改成 VARCHAR，下列是 phpMyAdmin 的語法:

ALTER TABLE `phpbb_topics` CHANGE `topic_last_post_subject` `topic_last_post_subject`  VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

接下來再執行下列的語法把原本的錯誤修正:

ALTER TABLE `phpbb_topics` ALTER `topic_last_post_subject` SET DEFAULT " ;

在上面的 SET DEFAULT " ; 最後兩個 " 是兩個 單引號 ( ‘ )，如果上述複製有問題的話，那就自己手動補上吧。

——–又發現另一個錯誤————————————————————————————————-

一般性錯誤

SQL ERROR [ mysql4 ]

Field ‘forum_last_post_subject’ doesn’t have a default value [1364]

SQL

INSERT INTO phpbb_forums (parent_id, forum_type, forum_status, forum_parents, forum_name, forum_link, forum_desc, forum_desc_uid, forum_desc_options, forum_desc_bitfield, forum_rules, forum_rules_uid, forum_rules_options, forum_rules_bitfield, forum_rules_link, forum_image, forum_style, display_subforum_list, display_on_index, forum_topics_per_page, enable_indexing, enable_icons, enable_prune, prune_days, prune_viewed, prune_freq, forum_options, forum_flags, left_id, right_id) VALUES (14, 1, 0, ", ‘DOS 系統’, ", ", ", 7, ", ", ", 7, ", ", ", 0, 1, 0, 10, 1, 1, 0, 7, 7, 1, 0, 112, ’18′, 19)

BACKTRACE

FILE: includes/db/mysql.php

LINE: 174

CALL: dbal->sql_error()

FILE: includes/acp/acp_forums.php

LINE: 1018

CALL: dbal_mysql->sql_query()

FILE: includes/acp/acp_forums.php

LINE: 186

CALL: acp_forums->update_forum_data()

FILE: includes/functions_module.php

LINE: 507

CALL: acp_forums->main()

FILE: adm/index.php

LINE: 74

CALL: p_master->load_active()

———————————————————————————————————————————-

修正方法如下:

ALTER TABLE `phpbb_forums` CHANGE `forum_last_post_subject` `forum_last_post_subject` VARCHAR( 255 ) NOT NUL

接下來再執行:

ALTER TABLE `phpbb_forums` ALTER `forum_last_post_subject` SET DEFAULT ‘ ‘ ;

在上面的 SET DEFAULT " ; 最後兩個 " 是兩個 單引號 ( ‘ )，如果上述複製有問題的話，那就自己手動補上吧。