Home

phpBB SQL Error MySQL4 - forum_last_post_subject doesn't have a default value

July 26, 2009 by keith
Posted in

phpBB Logo

A rather common error arises when users upgrade from an earlier version of phpBB. Below is an example:

General Error
SQL ERROR [ mysql4 ]

Field 'forum_last_post_subject' doesn't have a default value [1364]

After browsing through the forums trying to find an answer, it almost seems so impossible. Nevertheless, I did a couple of research myself and managed to find figure out a solution for it, which is SO simple!

(find out how to solve this phpBB error issue, click here...)

Solution for SQL Error

It would be easier done through phpMyAdmin panel, if you have access to this application.

  1. Under cPanel, click on phpMyAdmin icon.
    phpMyAdmin
  2. Select your phpBB database, and then click on the "xxx_topics", where "xxx" represents your phpBB database suffix.
    php Topics
  3. Browse to the line that says "topic_last_post_subject" and click on the "pencil" icon at the extreme right.
    php Subject
  4. Change the value of the Null field to null (as shown below). Then, click Save.
    php Null Topic Subject

After you have completed the above procedure, the next time you create a new topic, the error will no longer show up. Good luck!

ahhhh
Submitted by RandomGuest (not verified) on Tue, 2009-09-22 08:03.

ahhhhh thanks for this post.. it seems to have fixed my problem, which the scripts on phpbb.com didn't fix. I upgraded from 3.0RC7 to 3.0.5 when I got that error.

fix
Submitted by ro (not verified) on Mon, 2009-10-05 18:55.

thanks a lot! fixed!

Please I ned some help with this
Submitted by Sergio (not verified) on Thu, 2009-11-05 21:15.

General Error

SQL ERROR [ mysql4 ]

Table 'joomla.phpbb_config' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

THX
Submitted by Noches (not verified) on Tue, 2009-12-22 21:39.

I have a 3.0.6 phpbbboard.
This trick worked for me. Thx a lot for the help.
Great job and all the best for you.

Good Auction Script?
Submitted by Lorpremokex (not verified) on Thu, 2010-02-18 02:57.

I'm looking to start a alternative website to Ebay and was noticing a few websites like eBid, UBid, and Swoopo that seem to be pretty good with the amount of traffic they get. Can someone recommend a customizable script where I can set up my own website and attract visitors

I'm pretty good at php and some design so that's not a issue, just don't want to spend to much.

Thanks.