Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR: column sections_sites.sectionid does not exist #53

Open
acalvino4 opened this issue Oct 21, 2021 · 0 comments

Comments

@acalvino4
Copy link

I create a new menu, then try to open it for editing, but get:

PDOException: SQLSTATE[42703]: Undefined column: 7 ERROR:  column sections_sites.sectionid does not exist
LINE 3: LEFT JOIN "sections_sites" ON "sections_sites".sectionId = "...
                                      ^
HINT:  Perhaps you meant to reference the column "sections_sites.sectionId". in /var/www/craft/vendor/yiisoft/yii2/db/Command.php:1302
Stack trace:
#0 /var/www/craft/vendor/yiisoft/yii2/db/Command.php(1302): PDOStatement->execute()
#1 /var/www/craft/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute()
#2 /var/www/craft/vendor/yiisoft/yii2/db/Command.php(410): yii\db\Command->queryInternal()
#3 /var/www/craft/vendor/yiisoft/yii2/db/Query.php(249): yii\db\Command->queryAll()
#4 /var/www/craft/vendor/craftcms/cms/src/db/Query.php(152): yii\db\Query->all()
#5 /var/www/craft/vendor/olivestudio/craft-olivemenus/src/services/OlivemenuItemsService.php(164): craft\db\Query->all()
#6 /var/www/craft/vendor/olivestudio/craft-olivemenus/src/services/OlivemenuItemsService.php(40): olivestudio\olivemenus\services\OlivemenuItemsService->getSections()
#7 /var/www/craft/vendor/olivestudio/craft-olivemenus/src/controllers/MenuItemsController.php(67): olivestudio\olivemenus\services\OlivemenuItemsService->getSectionsWithEntries()
#8 [internal function]: olivestudio\olivemenus\controllers\MenuItemsController->actionEdit()
#9 /var/www/craft/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#10 /var/www/craft/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
#11 /var/www/craft/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
#12 /var/www/craft/vendor/craftcms/cms/src/web/Application.php(277): yii\base\Module->runAction()
#13 /var/www/craft/vendor/yiisoft/yii2/web/Application.php(104): craft\web\Application->runAction()
#14 /var/www/craft/vendor/craftcms/cms/src/web/Application.php(262): yii\web\Application->handleRequest()
#15 /var/www/craft/vendor/yiisoft/yii2/base/Application.php(392): craft\web\Application->handleRequest()
#16 /var/www/craft/web/index.php(26): yii\base\Application->run()
#17 {main}

Next yii\db\Exception: SQLSTATE[42703]: Undefined column: 7 ERROR:  column sections_sites.sectionid does not exist
LINE 3: LEFT JOIN "sections_sites" ON "sections_sites".sectionId = "...
                                      ^
HINT:  Perhaps you meant to reference the column "sections_sites.sectionId".
The SQL being executed was: SELECT "name", "handle"
FROM "sections"
LEFT JOIN "sections_sites" ON "sections_sites".sectionId = "sections".id
WHERE ("type"='single') AND ("dateDeleted" IS NULL) AND ("siteId"=1)
ORDER BY "name" in /var/www/craft/vendor/yiisoft/yii2/db/Schema.php:678
Stack trace:
#0 /var/www/craft/vendor/yiisoft/yii2/db/Command.php(1307): yii\db\Schema->convertException()
#1 /var/www/craft/vendor/yiisoft/yii2/db/Command.php(1168): yii\db\Command->internalExecute()
#2 /var/www/craft/vendor/yiisoft/yii2/db/Command.php(410): yii\db\Command->queryInternal()
#3 /var/www/craft/vendor/yiisoft/yii2/db/Query.php(249): yii\db\Command->queryAll()
#4 /var/www/craft/vendor/craftcms/cms/src/db/Query.php(152): yii\db\Query->all()
#5 /var/www/craft/vendor/olivestudio/craft-olivemenus/src/services/OlivemenuItemsService.php(164): craft\db\Query->all()
#6 /var/www/craft/vendor/olivestudio/craft-olivemenus/src/services/OlivemenuItemsService.php(40): olivestudio\olivemenus\services\OlivemenuItemsService->getSections()
#7 /var/www/craft/vendor/olivestudio/craft-olivemenus/src/controllers/MenuItemsController.php(67): olivestudio\olivemenus\services\OlivemenuItemsService->getSectionsWithEntries()
#8 [internal function]: olivestudio\olivemenus\controllers\MenuItemsController->actionEdit()
#9 /var/www/craft/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array()
#10 /var/www/craft/vendor/yiisoft/yii2/base/Controller.php(181): yii\base\InlineAction->runWithParams()
#11 /var/www/craft/vendor/yiisoft/yii2/base/Module.php(534): yii\base\Controller->runAction()
#12 /var/www/craft/vendor/craftcms/cms/src/web/Application.php(277): yii\base\Module->runAction()
#13 /var/www/craft/vendor/yiisoft/yii2/web/Application.php(104): craft\web\Application->runAction()
#14 /var/www/craft/vendor/craftcms/cms/src/web/Application.php(262): yii\web\Application->handleRequest()
#15 /var/www/craft/vendor/yiisoft/yii2/base/Application.php(392): craft\web\Application->handleRequest()
#16 /var/www/craft/web/index.php(26): yii\base\Application->run()
#17 {main}
Additional Information:
Array
(
    [0] => 42703
    [1] => 7
    [2] => ERROR:  column sections_sites.sectionid does not exist
LINE 3: LEFT JOIN "sections_sites" ON "sections_sites".sectionId = "...
                                      ^
HINT:  Perhaps you meant to reference the column "sections_sites.sectionId".
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant