Key column 'last_modified_user_id' doesn't exist in table

Alpha1

Active Member
Reactions
181
  • XF\Db\InvalidQueryException: MySQL query error [1072]: Key column 'last_modified_user_id' doesn't exist in table
  • src/XF/Db/AbstractStatement.php:212
  • Generated by: Unknown account
  • Oct 7, 2018 at 10:23 PM
Stack trace
ALTER TABLE `xf_conversation_master`
ADD `sv_mod_locked` TINYINT UNSIGNED NOT NULL DEFAULT '0',
ADD KEY `last_modified_user_id` (`last_modified_user_id`)
------------

#0 src/XF/Db/Mysqli/Statement.php(196): XF\Db\AbstractStatement->getException('MySQL query err...', 1072, '42000')
#1 src/XF/Db/Mysqli/Statement.php(77): XF\Db\Mysqli\Statement->getException('MySQL query err...', 1072, '42000')
#2 src/XF/Db/AbstractAdapter.php(79): XF\Db\Mysqli\Statement->execute()
#3 src/XF/Db/Schema/AbstractDdl.php(151): XF\Db\AbstractAdapter->query('ALTER TABLE `xf...')
#4 src/XF/Db/SchemaManager.php(143): XF\Db\Schema\AbstractDdl->apply()
#5 src/addons/SV/ConversationEssentials/Setup.php(52): XF\Db\SchemaManager->alterTable('xf_conversation...', Object(Closure))
#6 src/addons/SV/ConversationEssentials/Setup.php(290): SV\ConversationEssentials\Setup->installStep3()
#7 src/XF/AddOn/StepRunnerUpgradeTrait.php(122): SV\ConversationEssentials\Setup->upgrade2000100Step3(Array)
#8 src/XF/AddOn/StepRunnerUpgradeTrait.php(71): SV\ConversationEssentials\Setup->upgradeStepRunner(2000100, 3, Array, 2000200)
#9 src/XF/Cli/Command/AddOnActionTrait.php(107): SV\ConversationEssentials\Setup->upgrade(Array)
#10 src/XF/Cli/Command/AddOnSubAction.php(81): XF\Cli\Command\AddOnSubAction->performAddOnAction(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput), Object(XF\AddOn\AddOn), Object(XF\Phrase), 'upgrade')
#11 src/vendor/symfony/console/Command/Command.php(241): XF\Cli\Command\AddOnSubAction->execute(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#12 src/vendor/symfony/console/Application.php(843): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#13 src/vendor/symfony/console/Application.php(193): Symfony\Component\Console\Application->doRunCommand(Object(XF\Cli\Command\AddOnSubAction), Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#14 src/vendor/symfony/console/Application.php(117): Symfony\Component\Console\Application->doRun(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#15 src/XF/Cli/Runner.php(63): Symfony\Component\Console\Application->run(Object(Symfony\Component\Console\Input\ArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#16 cmd.php(15): XF\Cli\Runner->run()
#17 {main}

Request state
array(1) {
["cli"] => string(161) "/cmd.php xf:addon-sub-action SV/ConversationEssentials upgrade --k=e9df3c1e6d8eb500edfd9f1f68cc85f798c4ca94"
}

Trying to upgrade it to XF2 trough CLI.
 

Users who are viewing this thread

Back
Top