Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- PDOException: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens in /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php:1290
- Stack trace:
- #0 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1290): PDOStatement->execute()
- #1 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1158): yii\db\Command->internalExecute('SELECT `element...')
- #2 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)
- #3 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()
- #4 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/db/Query.php(162): yii\db\Query->all(NULL)
- #5 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1427): craft\db\Query->all(NULL)
- #6 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Extension/CoreExtension.php(1485): craft\elements\db\ElementQuery->all()
- #7 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/helpers/Template.php(79): twig_get_attribute(Object(craft\web\twig\Environment), Object(Twig\Source), Object(craft\elements\db\CategoryQuery), 'all', Array, 'method', false, false)
- #8 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/e5/e5618c5c89c80ee33f7af85dc0c27dedafffe77d56da280f203707f00f63e553.php(98): craft\helpers\Template::attribute(Object(craft\web\twig\Environment), Object(Twig\Source), Object(craft\elements\db\CategoryQuery), 'all', Array, 'method')
- #9 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->block_content(Array, Array)
- #10 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(166): Twig\Template->displayBlock('content', Array, Array)
- #11 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->block_main(Array, Array)
- #12 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(230): Twig\Template->displayBlock('main', Array, Array)
- #13 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->block_body(Array, Array)
- #14 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(111): Twig\Template->displayBlock('body', Array, Array)
- #15 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->doDisplay(Array, Array)
- #16 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
- #17 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
- #18 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
- #19 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(43): craft\web\twig\Template->display(Array, Array)
- #20 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->doDisplay(Array, Array)
- #21 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
- #22 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
- #23 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
- #24 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/e5/e5618c5c89c80ee33f7af85dc0c27dedafffe77d56da280f203707f00f63e553.php(45): craft\web\twig\Template->display(Array, Array)
- #25 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->doDisplay(Array, Array)
- #26 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
- #27 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
- #28 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
- #29 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(392): craft\web\twig\Template->display(Array)
- #30 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
- #31 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render(Array)
- #32 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(343): Twig\Environment->render('advice/_sector', Array)
- #33 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(393): craft\web\View->renderTemplate('advice/_sector', Array)
- #34 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(243): craft\web\View->renderPageTemplate('advice/_sector', Array)
- #35 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/controllers/TemplatesController.php(95): craft\web\Controller->renderTemplate('advice/_sector', Array)
- #36 [internal function]: craft\controllers\TemplatesController->actionRender('advice/_sector', Array)
- #37 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
- #38 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
- #39 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('render', Array)
- #40 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('render', Array)
- #41 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(298): yii\base\Module->runAction('templates/rende...', Array)
- #42 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/web/Application.php(103): craft\web\Application->runAction('templates/rende...', Array)
- #43 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(283): yii\web\Application->handleRequest(Object(craft\web\Request))
- #44 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
- #45 /Applications/MAMP/htdocs/privatename/public_html/index.php(21): yii\base\Application->run()
- #46 {main}
- Next yii\db\Exception: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
- The SQL being executed was: SELECT `elements`.`id`, `elements`.`fieldLayoutId`, `elements`.`uid`, `elements`.`enabled`, `elements`.`archived`, `elements`.`dateCreated`, `elements`.`dateUpdated`, `elements_sites`.`slug`, `elements_sites`.`siteId`, `elements_sites`.`uri`, `elements_sites`.`enabled` AS `enabledForSite`, `categories`.`groupId`, `content`.`id` AS `contentId`, `content`.`title`, `content`.`field_offerTitle`, `content`.`field_paymentBy`, `content`.`field_contactInformation`, `content`.`field_dateTime`, `content`.`field_preview`, `content`.`field_email`, `content`.`field_facebook`, `content`.`field_footerCopyrightText`, `content`.`field_footerLogoText`, `content`.`field_footerNewsletterButtonText`, `content`.`field_form`, `content`.`field_function`, `content`.`field_instagram`, `content`.`field_intro`, `content`.`field_intro2`, `content`.`field_intro3`, `content`.`field_button`, `content`.`field_button2`, `content`.`field_shortIntro`, `content`.`field_shortText`, `content`.`field_linkedin`, `content`.`field_note`, `content`.`field_subTitle`, `content`.`field_partnersTitle`, `content`.`field_productExtra`, `content`.`field_productDateTimeEnd`, `content`.`field_productIntro`, `content`.`field_productTeacher`, `content`.`field_productLocation`, `content`.`field_productSbu`, `content`.`field_productDateTimeStart`, `content`.`field_productTime`, `content`.`field_publicationsTitle`, `content`.`field_quoteCarouselTitle`, `content`.`field_richTextfield`, `content`.`field_seo`, `content`.`field_body`, `content`.`field_phoneNumber`, `content`.`field_title2`, `content`.`field_twitter`, `structureelements`.`root`, `structureelements`.`lft`, `structureelements`.`rgt`, `structureelements`.`level`
- FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`
- FROM `elements` `elements`
- INNER JOIN `categories` `categories` ON `categories`.`id` = `elements`.`id`
- INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
- INNER JOIN `content` `content` ON (`content`.`elementId` = `elements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
- INNER JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `elements`.`id`) AND (`structureelements`.`structureId`=14)
- INNER JOIN `relations` `relations` ON (`relations`.`targetId` = `elements`.`id`) AND ((`relations`.`sourceId`='2251') AND (`relations`.`fieldId`='99')) AND ((`relations`.`sourceSiteId` IS NULL) OR (`relations`.`sourceSiteId`='1'))
- WHERE `elements_sites`.`id` = (SELECT `elements_sites`.`id`
- FROM `elements` `subElements`
- INNER JOIN `categories` `categories` ON `categories`.`id` = `subElements`.`id`
- INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `subElements`.`id`
- INNER JOIN `content` `content` ON (`content`.`elementId` = `subElements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
- INNER JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `subElements`.`id`) AND (`structureelements`.`structureId`=14)
- INNER JOIN `relations` `relations` ON (`relations`.`targetId` = `subElements`.`id`) AND ((`relations`.`sourceId`='2251') AND (`relations`.`fieldId`='99')) AND ((`relations`.`sourceSiteId` IS NULL) OR (`relations`.`sourceSiteId`='1'))
- WHERE (`categories`.`groupId`=7) AND ((select count(`relations_icon`.`id`) from `relations` `relations_icon` where `relations_icon`.`sourceId` = `subElements`.`id` and `relations_icon`.`fieldId` = '98') != 0) AND (`subElements`.`archived`=FALSE) AND (`subElements`.`enabled`=TRUE) AND (`subElements`.`dateDeleted` IS NULL) AND (`elements_sites`.`enabled`=TRUE) AND (`subElements`.`draftId` IS NULL) AND (`subElements`.`revisionId` IS NULL) AND (`subElements`.`id` = `elements`.`id`)
- ORDER BY case when `elements_sites`.`siteId` = 1 then 0 else 1 end, `elements_sites`.`id`
- LIMIT 1)
- ORDER BY `structureelements`.`lft`, `elements`.`dateCreated` DESC) `subquery`
- INNER JOIN `categories` `categories` ON `categories`.`id` = `subquery`.`elementsId`
- INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
- INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
- INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
- INNER JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `subquery`.`elementsId`) AND (`structureelements`.`structureId`=14)
- INNER JOIN `relations` `relations` ON (`relations`.`targetId` = `elements`.`id`) AND ((`relations`.`sourceId`='2251') AND (`relations`.`fieldId`='99')) AND ((`relations`.`sourceSiteId` IS NULL) OR (`relations`.`sourceSiteId`='1'))
- ORDER BY `structureelements`.`lft`, `elements`.`dateCreated` DESC in /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Schema.php:664
- Stack trace:
- #0 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'SELECT `element...')
- #1 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1158): yii\db\Command->internalExecute('SELECT `element...')
- #2 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)
- #3 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()
- #4 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/db/Query.php(162): yii\db\Query->all(NULL)
- #5 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1427): craft\db\Query->all(NULL)
- #6 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Extension/CoreExtension.php(1485): craft\elements\db\ElementQuery->all()
- #7 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/helpers/Template.php(79): twig_get_attribute(Object(craft\web\twig\Environment), Object(Twig\Source), Object(craft\elements\db\CategoryQuery), 'all', Array, 'method', false, false)
- #8 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/e5/e5618c5c89c80ee33f7af85dc0c27dedafffe77d56da280f203707f00f63e553.php(98): craft\helpers\Template::attribute(Object(craft\web\twig\Environment), Object(Twig\Source), Object(craft\elements\db\CategoryQuery), 'all', Array, 'method')
- #9 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->block_content(Array, Array)
- #10 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(166): Twig\Template->displayBlock('content', Array, Array)
- #11 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->block_main(Array, Array)
- #12 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(230): Twig\Template->displayBlock('main', Array, Array)
- #13 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->block_body(Array, Array)
- #14 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(111): Twig\Template->displayBlock('body', Array, Array)
- #15 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->doDisplay(Array, Array)
- #16 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
- #17 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
- #18 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
- #19 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(43): craft\web\twig\Template->display(Array, Array)
- #20 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->doDisplay(Array, Array)
- #21 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
- #22 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
- #23 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
- #24 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/e5/e5618c5c89c80ee33f7af85dc0c27dedafffe77d56da280f203707f00f63e553.php(45): craft\web\twig\Template->display(Array, Array)
- #25 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->doDisplay(Array, Array)
- #26 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
- #27 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
- #28 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
- #29 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(392): craft\web\twig\Template->display(Array)
- #30 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
- #31 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render(Array)
- #32 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(343): Twig\Environment->render('advice/_sector', Array)
- #33 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(393): craft\web\View->renderTemplate('advice/_sector', Array)
- #34 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(243): craft\web\View->renderPageTemplate('advice/_sector', Array)
- #35 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/controllers/TemplatesController.php(95): craft\web\Controller->renderTemplate('advice/_sector', Array)
- #36 [internal function]: craft\controllers\TemplatesController->actionRender('advice/_sector', Array)
- #37 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
- #38 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
- #39 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('render', Array)
- #40 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('render', Array)
- #41 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(298): yii\base\Module->runAction('templates/rende...', Array)
- #42 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/web/Application.php(103): craft\web\Application->runAction('templates/rende...', Array)
- #43 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(283): yii\web\Application->handleRequest(Object(craft\web\Request))
- #44 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
- #45 /Applications/MAMP/htdocs/privatename/public_html/index.php(21): yii\base\Application->run()
- #46 {main}
- Additional Information:
- Array
- (
- [0] => HY093
- [1] => 0
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement