I was getting the problem below:
SQL ERROR [ mysql4 ]
Field 'topic_last_post_subject' doesn't have a default value [1364]
SQL
INSERT INTO phpbb3_topics (topic_poster, topic_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 (2, 1233814166, 13, 0, 1, 'test', 'Rob', 'AA0000', 0, 0, 0)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()
FILE: includes/functions_posting.php
LINE: 1850
CALL: dbal_mysql->sql_query()
FILE: posting.php
LINE: 1001
CALL: submit_post()
---
I fixed it by going to myphpadmin (usually provided by your isp provider), choose the table "php_topics" from the left hand side. choose the "structure" tab at the top of the new page. Then scroll down to find 'topic_last_post_subject' . Select the pen item "change" from the right hand side of top_last_post_subject.
In the new window, select type and "VARCHAR" from the drop down menu, then enter "255" in the Length/Value section and finally under Default, type the letter "a".
Press save and that should be it. Hope it works for you!!
Oliver
