I've analyzed this more deeply and could conclude you're using mySQL at least of the version 5.7, in which '0000-00-00 00:00:00'
is not a valid DATETIME value anymore. Since then, this also needs to be updated in the current stable and developed version of miniBB.
The steps to complete for the newer mySQL version (this will also work for miniBB 3.2.2):
1) In case you are installing the fresh forum, modify _install_mysql.sql
and remove NOT NULL default '0000-00-00 00:00:00'
for the following fields: post_time, topic_time, topic_last_post_time, user_regdate
. NULL values for these fields are not truly "wanted", but they all will be formed in/recorded from the script itself, so the older structure could be removed.
2) In case you already have an existing forum, and like to migrate it to/make it compatible with the newer mySQL 5.7+, you need to update your database with the following commands (substitute your own custom field names in the case you have them):
ALTER TABLE minibbtable_posts MODIFY post_time datetime;
ALTER TABLE minibbtable_topics MODIFY topic_time datetime;
ALTER TABLE minibbtable_topics MODIFY topic_last_post_time datetime;
ALTER TABLE minibbtable_users MODIFY user_regdate datetime;
The same could be done for whatever add-ons you may have installed and which previously contained the '0000-00-00 00:00:00' value for the datetype field as default.
3) Edit bb_func_ptopic.php
and after the line which is `$topic_time=date('Y-m-d H:i:s');` add the new line: `$topic_last_post_time=$topic_time;` so it looks like:
This all is currently fixed in miniBB 3.3 v2.