MyBB Community Forums

Site: http://yugioh-colosseum.site88.net/forum
Version: 1.6.8
Tester User Account: Tester password: tester

Got a problem when deleting prefixes in the Administration Panel. Here's the text that I get.

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error: 1054 - Unknown column 'prefix' in 'where clause' 
Query: UPDATE mybb_threads SET `prefix`='0' WHERE prefix='1'

Next is a problem when creating threads. Here's the text I get from it.

MyBB has experienced an internal SQL error and cannot continue.
 
SQL Error: 1054 - Unknown column 'prefix' in 'field list' 
Query: 
INSERT INTO mybb_threads (`fid`,`subject`,`prefix`,`icon`,`uid`,`username`,`dateline`,`lastpost`,`lastposter`,`views`,`replies`,`visible`,`notes`,`postpreview`,`lastpostpreview`) 
VALUES ('12','dddd','0','0','1','MonarchTheLegend','1344991487','1344991487','MonarchTheLegend','0','0','1','','ddddd','ddddd') 

Thanks in advance to anyone for the support :).

it seems that the prefix column from the mybb_threads table is missing..

yeah not sure how though. yesterday i added some plugins but it was working fine.

guess i got to go in and create the prefix columns for both in phpmyadmin

please provide a list of the plugins you have

Create New Threads From The Index
Last/First Post Avatar
MySupport
SideBoxes Plus
Thread ToolTip Preview

And of course the Akismet and Hello World that come with the MyBB Installation.

hmm the first plugin might be causing this error
but i don't think that removing it will solve it
because the column is already removed...

(2012-08-15, 01:33 AM)illusionalp Wrote: [ -> ]hmm the first plugin might be causing this error
but i don't think that removing it will solve it
because the column is already removed...

Creating the columns again should fix it right? although, not sure how to go about it.

(2012-08-15, 01:37 AM)MonarchTheLegend Wrote: [ -> ]

(2012-08-15, 01:33 AM)illusionalp Wrote: [ -> ]hmm the first plugin might be causing this error
but i don't think that removing it will solve it
because the column is already removed...

Creating the columns again should fix it right? although, not sure how to go about it.

it should solve it

*bump*

still having problems. anyone can give me directions on creating the columns again?