Fixing c_on IPB Error
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.
Filed Under: General
Wayne Saliba (49)
2ThePoint (36)
Thespina (10)
Mr Feel good (8)
Sell pens... (8)
Streaming... (8)
Jade (7)
Jimbo (6)
Raven Garcia (6)
Let us know if this helped anyone.
Thank you! Thank you! Thank you! Thank you! Thank you!
I’m glad it helped.
I would also like to say a huge thank you, this was driving me nuts!
If you Google for this problem this post is actually top in Google!
I’m not sure if you know this but your fix is top of Google when ‘fixing c_on ipb error’ is entered into the search engine.
Thank you for helping me solve this problem.
I told you!
Glad it was of help to you.
Thanks for dropping by.