I have had a PHPBB forum (ACSHA.com/phpbb/) up and running for a small group for some time. A couple weeks ago SPAMMERS started registering and spamming the site. I spent some time cleaning up the mess, deleting topics, users etc. I also changed the registration so I had to approve new users. I thought while I was at it, I'd update from the 3.01 version to the latest 3.05, all seems fine. I replied to some topics, etc.
However at some point I developed a problem, users could not post new topics. They received this error:
General Error
SQL ERROR [ mysql4 ]
Field 'topic_last_post_subject' doesn't have a default value [1364]
SQL
INSERT INTO phpbb3_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, 1244722269, 1244722269, 5, 0, 1, 'Test', 'Brew', '', 0, 0, 0)
BACKTRACE
FILE: includes/db/mysql.php
LINE: 174
CALL: dbal_mysql->sql_error()
FILE: includes/functions_posting.php
LINE: 1897
CALL: dbal_mysql->sql_query()
FILE: posting.php
LINE: 1023
CALL: submit_post()
_______________________________________
I had no idea why, so I logged into the ACP and performed a restore from a backup of about 4 days ago. That made things worse. I now had no forum. Not even a log in screen???
All I get is this message:
_________________________________
General Error
SQL ERROR [ mysql4 ]
Unknown column 't.template_inherits_id' in 'field list' [1054]
An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
_________________________________
Any help appreciated.
