Unable to post new topics

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Anti-Spam Guide
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
Hathaway
Registered User
Posts: 49
Joined: Mon Nov 21, 2005 1:51 pm

Unable to post new topics

Post by Hathaway »

Your board's URL: http://forum.ufplanets.com
Version of phpBB3: 3.0.3
Was this a fresh install or a(n) update/upgrade/conversion (please be specific)?: Just updated
If update, what package(s) did you use? 3.0.0
Did you use an automated wizard provided by your host to install phpBB? Yes
MODs you have installed: None
When the problem started: Today
Your level of expertise (be honest): 3/10


The error I and my other members are getting is listed below. My whole site was moved to a new server recently, and I'm assuming that this is the likeliest cause of this problem, however after the server move I immediately updated the phpBB version from 3.0.0 to 3.0.3 with seemingly no problems.
Anyone know what I might do to resolve this issue? Thank you.



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, 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, 1227398662, 56, 0, 1, 'test', '{UFP}Hathaway', '33CCFF', 0, 0, 0)

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1850
CALL: dbal_mysql->sql_query()

FILE: posting.php
LINE: 1001
CALL: submit_post()
User avatar
KevC
Support Team Member
Support Team Member
Posts: 70222
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Unable to post new topics

Post by KevC »

When you updated, did you remember to run the install/database_update.php file?

If not, run it now.
If you did, follow this

Knowledge Base - Doesn't have a default value errors
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"
Kim_Possible
Registered User
Posts: 1343
Joined: Sun Sep 21, 2008 3:57 pm

Re: Unable to post new topics

Post by Kim_Possible »

Is it possible that your new host was using a different version of MySQL?

Give this a read: http://www.phpbb.com/kb/article/doesnt- ... ue-errors/

[Edit] Dang! Too slow again. :D
Locked

Return to “[3.0.x] Support Forum”