search

OliveStudio / olivemenus

A powerful menus plugin for Craft CMS built for the need of simplicity and flexibility
MIT License
40 stars 22 forks source link

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

Open acalvino4 opened 3 years ago

acalvino4 commented 3 years ago

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".
)