error message

[system]

When I try to post a new message on my forum I get an error message:
SQL ERROR [ mysql4 ]

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

SQL

INSERT INTO bb3_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 (16849, 1375212160, 1375212160, 2, 0, 1, ‘No new topics’, ‘pmaxwell’, ‘’, 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()

Stupe

[richei]

This one is pretty self exclamatory. You’re missing something in the query. Not sure if its missing because of a mod that was installed or if you were tinkering with it.

To fix it, you can either reinstall the bb forums, or take a look at the table and see where topic_last_post_subject is in the structure, then insert it into the query in the right spot, then add the value in the other end of the query (in the right place of course).