MyBB Community Forums

Full Version: Sql Error
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I posted this here because I figured it is a simple query to fix this.

When trying to enable a plugin i have i get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
    1060 - Duplicate column name 'pid'
Query:
    ALTER TABLE `gf_reputation` ADD `pid` INT( 10 ) DEFAULT '-1' NOT NULL AFTER `adduid` 

how could i remove this column. The plug-in is fast reputation
You should post this in the thread about that plugin.
go to phpmyadmin

bd select the forum.

and go to the SQL tab, and put this into the text field.

and give it to efficiently execute


ALTER TABLE gf_reputation ADD pid INT( 10 ) DEFAULT '-1' NOT NULL AFTER adduid
As the first responder said, take this to the plugin author's thread for that plugin, or the proper support board for that author.