MyBB Community Forums

Hello I was just installing mybb shops From here: and When I Click 'Install And Active' I Get This Error Page.


MyBB SQL Error
MyBB has experienced an internal SQL error and cannot continue.

SQL Error:
1060 - Duplicate column name 'canviewshops'
Query:
ALTER TABLE mybb_usergroups ADD canviewshops TINYINT( 1 ) NOT NULL DEFAULT '1'
Please contact the MyBB Group for support

You possibly clicked Activate/Install link twice. Refresh the plugin's manager page and deactivate/uninstall the plugin and reinstall it again.

(2012-06-22, 05:06 PM)Yaldaram Wrote: [ -> ]You possibly clicked Activate/Install link twice. Refresh the plugin's manager page and deactivate/uninstall the plugin and reinstall it again.

Nope Clicked Once and only Activate/Install Link shows

Are you using this plugin: http://mods.mybb.com/view/mybbshops-free-lite-version ?

If yes then open plugin file and find;

$db->query("ALTER TABLE `".TABLE_PREFIX."usergroups` ADD `canviewshops` TINYINT( 1 ) NOT NULL DEFAULT '1'");

and Comment it out like this;

// $db->query("ALTER TABLE `".TABLE_PREFIX."usergroups` ADD `canviewshops` TINYINT( 1 ) NOT NULL DEFAULT '1'");