Today I was trying to add a new board to my football forum and I was getting a database error with no details of the error. Thankfully I know that the board logs errors in little files so I dragged it up and found the following error:

Date: Thu, 29 May 2008 19:38:40 +0100
Error Number: 1054
Error: Unknown column ‘c_on’ in ‘field list’
IP Address: (removed)
(other bits moved as they were too long for the post and stretched the template)

I searched Google and did not find one single answer to my problem so I searched for similar errors and thankfully found plenty of them. I found a popular fix for the similar problem and altered it to my own needs and ran it.

This is the fix that I used:

ALTER TABLE `ibf_forums` ADD `c_on` text NOT NULL;

I logged into my admin panel of the forum and went to Admin | SQL Management and then clicked on SQL Toolbox and entered the query above into the Run a Query box and ran it.

Please make sure that you back up your database BEFORE you do this.

Image by Steve Buissinne from Pixabay