Beaten up & now broken...

Support for upgrading any version of your phpBB3 installation
Forum rules
READ: Board Rules

Support for upgrading any version of phpBB3 to the most recent version.

Beaten up & now broken...

Postby Brew_eM » 11 Jun 2009, 07:19

Hello all,
I have had a PHPBB forum ( 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]


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)


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??? :banghead:

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.
Posts: 1
Joined: 11 Jun 2009, 06:14
Gender: Male
phpBB Knowledge: 1

Return to phpBB3 upgrade support

Who is online

Users browsing this forum: No registered users and 5 guests