Threaded Mode | Linear Mode

TriloByte · 12-21-2008 12:09 AM

Well, when I try to activate the plugin I get this error:

Code:

MyBB SQL Error

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:

1060 - Duplicate column name 'credits'

Query:

ALTER TABLE `mybb_users` ADD `credits` INT NOT NULL ;

So, I go into my PHPMyAdmin, and I type in:

Code:

ALTER TABLE `mybb_users` DROP `credits` INT NOT NULL

Then it comes back with this error:

Code:

Error

SQL query: 

ALTER TABLE `mybb_users` DROP `credits` INT NOT NULL 

MySQL said:  

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INT NOT NULL' at line 1

Any help? :S

**Splappy** · 12-21-2008 04:23 AM

Try this MySQL query:

Code:

ALTER TABLE `mybb_users` DROP `credits`

TriloByte · 12-21-2008 12:17 PM

Whenever I delete that, it somehow comes back after..

Threaded Mode \| Linear Mode Trouble when activating
Author	Message