Error installing plugin

bradzazulak2957

New Member
YetiShare User
YetiShare Supporter
Sep 2, 2013
7
0
1
I am trying to install the stripe plugin but I am getting a DB error.
I want to note that I have installed a custom payment plugin already so I am not sure if that is causing the issue.
Here is the error I get when trying to install it.

Database Error:
PDOException: SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'user_level_pricing_id' in /var/www/website/app/core/Database.class.php:187
Stack trace:
#0 /var/www/website/app/core/Database.class.php(187): PDOStatement->execute()
#1 /var/www/website/app/services/Plugin.class.php(90): App\Core\Database->query()
#2 /var/www/website/app/services/Plugin.class.php(106): App\Services\Plugin->importSql()
#3 /var/www/website/app/services/Plugin.class.php(44): App\Services\Plugin->importSqlFile()
#4 /var/www/website/app/controllers/admin/PluginController.class.php(324): App\Services\Plugin->install()
#5 [internal function]: App\Controllers\admin\PluginController->ajaxPluginManageInstall()
#6 /var/www/website/app/helpers/RouteHelper.class.php(399): call_user_func_array()
#7 /var/www/website/app/core/Framework.class.php(237): App\Helpers\RouteHelper::processRoutes()
#8 /var/www/website/app/core/Framework.class.php(26): App\Core\Framework::dispatch()
#9 /var/www/website/index.php(21): App\Core\Framework::run()
#10 {main}

Last Rendered Query:

ALTER TABLE `plugin_stripe_subscription` ADD `user_level_pricing_id` INT( 11 ) NULL AFTER `period_days`

#0 /var/www/website/app/core/Database.class.php(191): App\Core\Database->notify(Object(PDOException))
#1 /var/www/website/app/services/Plugin.class.php(90): App\Core\Database->query('...')
#2 /var/www/website/app/services/Plugin.class.php(106): App\Services\Plugin->importSql('...')
#3 /var/www/website/app/services/Plugin.class.php(44): App\Services\Plugin->importSqlFile('...')
#4 /var/www/website/app/controllers/admin/PluginController.class.php(324): App\Services\Plugin->install()
#5 [internal function]: App\Controllers\admin\PluginController->ajaxPluginManageInstall()
#6 /var/www/website/app/helpers/RouteHelper.class.php(399): call_user_func_array(Array, Array)
#7 /var/www/website/app/core/Framework.class.php(237): App\Helpers\RouteHelper::processRoutes()
#8 /var/www/website/app/core/Framework.class.php(26): App\Core\Framework::dispatch()
#9 /var/www/website/index.php(21): Ap
 

adam

Administrator
Staff member
Dec 5, 2009
2,046
108
63
Hi,

Have you already installed it before? Try manually deleting the `plugin_stripe_subscription` table from the database (via phpmyadmin or similar) and retrying the plugin install.

Thanks,
Adam.