I recently updated my board from 3.01 to 3.05
After doing this, everything seemed ok.
I tried to add the Antibot question to stop the spam posts and again, everything seemed ok except for a problem with how one of the fields displayed.
I then noticed that everytime a NEW topic was created, i got the following message.
SQL ERROR [ mysql4 ]
Field 'topic_last_post_subject' doesn't have a default value 
INSERT INTO phpbb_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 (2, 1249409966, 1249409966, 1, 0, 1, 'Test', 'mickgrady', '#0F5EF', 0, 0, 0)
Adding a post to an existing topic was not affected.
Having seen this problem, i removed the changes for the Antibot question (uploaded original files) in an attempt to get back to square one.
The only thing i've changed to the SQL is the insert of the 4 lines of code needed for the antibot question (which i did through myphphadmin as instructed in the guide, with no errors)
The code was entered into php_config table in my database.
I've tried restoring from a backup made before any alterations but i keep getting a server 500 timeout error.
The data does seem to be restored in spite of the error (posts revert to what they were prior to the backup) but i still get the above General error ONLY when creating new topics, not adding a post to existing ones.
Seriously stuck! hope someone can help
Last edited by MJG8910
on Tue Aug 04, 2009 8:22 pm, edited 1 time in total.