Error

[Janota]

When i try to view my forum now i get this , all ive done is set the thread prefix then i get this

[pola jay]

create a new column in to table and call it t.prefix

,,

[Janota]

Where and how do i do that ?

[pola jay]

in your database in table mybb_theads make it

[Janota]

Yea there is a table called "mybb_theads"
Its already there.

[MattRogowski]

You wouldn't get the error if the column existed. Did you run the upgrade script??

[Janota]

Yes i have (you mean the i.6 mybb script), if so yes.

[MattRogowski]

Did you choose your old version from the list and run it all the way though?? This column gets added by the upgrader.

[Janota]

Ive just re-installed a thread prefix plugin that i had removed and that has fixed the problem. Weird

[MattRogowski]

Don't do that, now you've got a plugin and core feature managing prefixes, that's not going to work. The column is added by the upgrade script. If you run the upgrade again it'd run this:

PHP Code:

if($db->field_exists('prefix', 'threads'))
{
    $db->drop_column("threads", "prefix");
}
...
$db->add_column("threads", "prefix", "smallint unsigned NOT NULL default '0' AFTER subject"); 


Drops it, then adds it again. If it didn't get added, the script didn't fully run.