[XB] Post Deleted Placeholder [Paid] 2.0.1

[Painbaker]

When updating.

Server error log
xf_post: MySQL query error [1060]: Duplicate column name 'ozzmodz_pdp_is_shown'
6 minutes ago src/XF/Db/AbstractStatement.php:230

XF\Db\Exception: xf_post: MySQL query error [1060]: Duplicate column name 'ozzmodz_pdp_is_shown' src/XF/Db/AbstractStatement.php:230
Generated by: admin Nov 5, 2025 at 5:13 PM

Stack trace
ALTER TABLE `xf_post`
ADD `ozzmodz_pdp_is_shown` TINYINT UNSIGNED NOT NULL DEFAULT '1',
ADD KEY `ozzmodz_pdp_is_shown` (`ozzmodz_pdp_is_shown`)
------------

#0 src/XF/Db/Mysqli/Statement.php(207): XF\Db\AbstractStatement->getException('MySQL query err...', 1060, '42S21')
#1 src/XF/Db/Mysqli/Statement.php(83): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1060, '42S21')
#2 src/XF/Db/AbstractAdapter.php(96): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(158): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#4 src/XF/Db/SchemaManager.php(157): XF\Db\Schema\AbstractDdl->apply()
#5 src/XF/Install/InstallHelperTrait.php(903): XF\Db\SchemaManager->alterTable('xf_post', Object(Closure))
#6 src/addons/OzzModz/PostDeletedPlaceholder/Setup.php(50): XF\AddOn\AbstractSetup->alterTable('xf_post', Object(Closure))
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(124): OzzModz\PostDeletedPlaceholder\Setup->upgrade2000100Step1(Array)
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(73): OzzModz\PostDeletedPlaceholder\Setup->upgradeStepRunner(2000100, 1, Array, NULL)
#9 src/XF/Admin/Controller/AddOnController.php(612): OzzModz\PostDeletedPlaceholder\Setup->upgrade(Array)
#10 src/XF/Mvc/Dispatcher.php(362): XF\Admin\Controller\AddOnController->actionUpgrade(Object(XF\Mvc\ParameterBag))
#11 src/XF/Mvc/Dispatcher.php(264): XF\Mvc\Dispatcher->dispatchClass('XF:AddOn', 'Upgrade', Object(XF\Mvc\RouteMatch), Object(Bespoke\SequentialStickies\XF\Admin\Controller\AddOn), NULL)
#12 src/XF/Mvc/Dispatcher.php(121): XF\Mvc\Dispatcher->dispatchFromMatch(Object(XF\Mvc\RouteMatch), Object(Bespoke\SequentialStickies\XF\Admin\Controller\AddOn), NULL)
#13 src/XF/Mvc/Dispatcher.php(63): XF\Mvc\Dispatcher->dispatchLoop(Object(XF\Mvc\RouteMatch))
#14 src/XF/App.php(2824): XF\Mvc\Dispatcher->run()
#15 src/XF.php(806): XF\App->run()
#16 admin.php(15): XF::runApp('XF\\Admin\\App')
#17 {main}

Request state
array(4) {
  ["url"] => string(57) "/admin.php?add-ons/OzzModz-PostDeletedPlaceholder/upgrade"
  ["referrer"] => string(86) "/admin.php?add-ons/OzzModz-PostDeletedPlaceholder/upgrade"
  ["_GET"] => array(1) {
    ["add-ons/OzzModz-PostDeletedPlaceholder/upgrade"] => string(0) ""
  }
  ["_POST"] => array(7) {
    ["_xfProcessing"] => string(1) "1"
    ["continue"] => string(1) "1"
    ["confirm"] => string(1) "1"
    ["params"] => string(2) "[]"
    ["count"] => string(1) "1"
    ["finished"] => string(1) "0"
    ["_xfToken"] => string(8) "********"
  }

I believe you are trying to update on a forum which has file and database version inconsistencies. Meaning you already had version 2.0.1 installed, but probably due to a restore or rollback, you are updating it again.

You can comment out this line in Setup.php and proceed with the update.

/**
    public function upgrade2000100Step1()
    {
        $this->alterTable('xf_post', function (Alter $table) {
            $table->addColumn('ozzmodz_pdp_is_shown', 'tinyint')->setDefault(1);
            $table->addKey('ozzmodz_pdp_is_shown');
        });
    }
    */