Default Editor error

[Shole]

When i try to activate the mod Default Editor i get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1060 - Duplicate column name 'defaulttitle'
Query:
ALTER TABLE `mybb_forums` ADD `defaulttitle` TEXT NULL AFTER `defaultsortorder`

Can anyone tell me what to do ?

 

[Hitakashi]

What other plugins do you have? Sounds like a plugin conflict, Or it doesn't remove that table on uninstall and it breaks when you try to install it.

 

[Shole]

ForumsIcons
Akismet
Clean Favicon
Index Top Posters
NewPoints
Profile Comments
Registration Security Question
Text ads

I have those active...I also think it didnt remove the table but i am not sure how to remove it.

 

[GeekStep]

I don't think there is any plugin conflict. You might want to omit ( AFTER `defaultsortorder` ) because that is not really needed. When you do, it will just add column 'defaulttitle' at the end of the table.

 

[Shole]

So i just need to run that and it will work?

 

[GeekStep]

Most probably it would, yes.

 

[R44]

SQL Error:
1060 - Duplicate column name 'defaulttitle'

Read that,

I don't think there is any plugin conflict. You might want to omit ( AFTER `defaultsortorder` ) because that is not really needed. When you do, it will just add column 'defaulttitle' at the end of the table.

Won't happen... it's a dup column - not a "No such column".

 

[Shole]

So should i delete that column and try to activate it or what?

 

[R44]

So should i delete that column and try to activate it or what?

Post on the MyBB community - It's a default editor problem, they have to help you.

 

[Shole]

Thanks R44 😀

 

[GeekStep]

SQL Error:
1060 - Duplicate column name 'defaulttitle'

Read that,

I don't think there is any plugin conflict. You might want to omit ( AFTER `defaultsortorder` ) because that is not really needed. When you do, it will just add column 'defaulttitle' at the end of the table.

Won't happen... it's a dup column - not a "No such column".

It could be a double query. I am saying there is no conflict because as mentioned

ForumsIcons
Akismet
Clean Favicon
Index Top Posters
NewPoints
Profile Comments
Registration Security Question
Text ads

I have those active...I also think it didnt remove the table but i am not sure how to remove it.

Those plugins do not create a 'defaulttitle' column. In that case, there should not be any plugin conflict but a problem with the mysql query line.

So should i delete that column and try to activate it or what?

Post on the MyBB community - It's a default editor problem, they have to help you.

I don't think its a built-in editor, but a mod that he is trying to install.

 

[Hitakashi]

If you have phpMyAdmin you should be able to go to your database -> prefix_forums -> Structure tab at the top -> drop 'defaulttitle' and 'defaultmessage'