Advertisement
Guest User

Mysql error Craft 2.3

a guest
Jul 11th, 2019
31
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 19.25 KB | None | 0 0
  1. 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
  2. Stack trace:
  3. #0 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1290): PDOStatement->execute()
  4. #1 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1158): yii\db\Command->internalExecute('SELECT `element...')
  5. #2 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)
  6. #3 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()
  7. #4 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/db/Query.php(162): yii\db\Query->all(NULL)
  8. #5 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1427): craft\db\Query->all(NULL)
  9. #6 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Extension/CoreExtension.php(1485): craft\elements\db\ElementQuery->all()
  10. #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)
  11. #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')
  12. #9 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->block_content(Array, Array)
  13. #10 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(166): Twig\Template->displayBlock('content', Array, Array)
  14. #11 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->block_main(Array, Array)
  15. #12 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(230): Twig\Template->displayBlock('main', Array, Array)
  16. #13 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->block_body(Array, Array)
  17. #14 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(111): Twig\Template->displayBlock('body', Array, Array)
  18. #15 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->doDisplay(Array, Array)
  19. #16 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
  20. #17 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
  21. #18 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
  22. #19 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(43): craft\web\twig\Template->display(Array, Array)
  23. #20 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->doDisplay(Array, Array)
  24. #21 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
  25. #22 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
  26. #23 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
  27. #24 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/e5/e5618c5c89c80ee33f7af85dc0c27dedafffe77d56da280f203707f00f63e553.php(45): craft\web\twig\Template->display(Array, Array)
  28. #25 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->doDisplay(Array, Array)
  29. #26 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
  30. #27 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
  31. #28 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
  32. #29 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(392): craft\web\twig\Template->display(Array)
  33. #30 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
  34. #31 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render(Array)
  35. #32 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(343): Twig\Environment->render('advice/_sector', Array)
  36. #33 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(393): craft\web\View->renderTemplate('advice/_sector', Array)
  37. #34 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(243): craft\web\View->renderPageTemplate('advice/_sector', Array)
  38. #35 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/controllers/TemplatesController.php(95): craft\web\Controller->renderTemplate('advice/_sector', Array)
  39. #36 [internal function]: craft\controllers\TemplatesController->actionRender('advice/_sector', Array)
  40. #37 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
  41. #38 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
  42. #39 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('render', Array)
  43. #40 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('render', Array)
  44. #41 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(298): yii\base\Module->runAction('templates/rende...', Array)
  45. #42 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/web/Application.php(103): craft\web\Application->runAction('templates/rende...', Array)
  46. #43 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(283): yii\web\Application->handleRequest(Object(craft\web\Request))
  47. #44 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
  48. #45 /Applications/MAMP/htdocs/privatename/public_html/index.php(21): yii\base\Application->run()
  49. #46 {main}
  50.  
  51. Next yii\db\Exception: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens
  52. 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`
  53. FROM (SELECT `elements`.`id` AS `elementsId`, `elements_sites`.`id` AS `elementsSitesId`, `content`.`id` AS `contentId`
  54. FROM `elements` `elements`
  55. INNER JOIN `categories` `categories` ON `categories`.`id` = `elements`.`id`
  56. INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `elements`.`id`
  57. INNER JOIN `content` `content` ON (`content`.`elementId` = `elements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
  58. INNER JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `elements`.`id`) AND (`structureelements`.`structureId`=14)
  59. 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'))
  60. WHERE `elements_sites`.`id` = (SELECT `elements_sites`.`id`
  61. FROM `elements` `subElements`
  62. INNER JOIN `categories` `categories` ON `categories`.`id` = `subElements`.`id`
  63. INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`elementId` = `subElements`.`id`
  64. INNER JOIN `content` `content` ON (`content`.`elementId` = `subElements`.`id`) AND (`content`.`siteId` = `elements_sites`.`siteId`)
  65. INNER JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `subElements`.`id`) AND (`structureelements`.`structureId`=14)
  66. 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'))
  67. 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`)
  68. ORDER BY case when `elements_sites`.`siteId` = 1 then 0 else 1 end, `elements_sites`.`id`
  69. LIMIT 1)
  70. ORDER BY `structureelements`.`lft`, `elements`.`dateCreated` DESC) `subquery`
  71. INNER JOIN `categories` `categories` ON `categories`.`id` = `subquery`.`elementsId`
  72. INNER JOIN `elements` `elements` ON `elements`.`id` = `subquery`.`elementsId`
  73. INNER JOIN `elements_sites` `elements_sites` ON `elements_sites`.`id` = `subquery`.`elementsSitesId`
  74. INNER JOIN `content` `content` ON `content`.`id` = `subquery`.`contentId`
  75. INNER JOIN `structureelements` `structureelements` ON (`structureelements`.`elementId` = `subquery`.`elementsId`) AND (`structureelements`.`structureId`=14)
  76. 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'))
  77. ORDER BY `structureelements`.`lft`, `elements`.`dateCreated` DESC in /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Schema.php:664
  78. Stack trace:
  79. #0 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1295): yii\db\Schema->convertException(Object(PDOException), 'SELECT `element...')
  80. #1 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(1158): yii\db\Command->internalExecute('SELECT `element...')
  81. #2 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Command.php(399): yii\db\Command->queryInternal('fetchAll', NULL)
  82. #3 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/db/Query.php(237): yii\db\Command->queryAll()
  83. #4 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/db/Query.php(162): yii\db\Query->all(NULL)
  84. #5 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/elements/db/ElementQuery.php(1427): craft\db\Query->all(NULL)
  85. #6 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Extension/CoreExtension.php(1485): craft\elements\db\ElementQuery->all()
  86. #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)
  87. #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')
  88. #9 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->block_content(Array, Array)
  89. #10 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(166): Twig\Template->displayBlock('content', Array, Array)
  90. #11 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->block_main(Array, Array)
  91. #12 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(230): Twig\Template->displayBlock('main', Array, Array)
  92. #13 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(184): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->block_body(Array, Array)
  93. #14 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/b5/b5ea2ac0732f7320e96a0dcb1118e4d78d3920e25a4a4d7144f0e6279797fd2c.php(111): Twig\Template->displayBlock('body', Array, Array)
  94. #15 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_2ddb2aaf2a18fe8d355da5728ec2549883d649f612f3fe239d3dc2a0f96de8bc->doDisplay(Array, Array)
  95. #16 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
  96. #17 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
  97. #18 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
  98. #19 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/40/405d906fd80b2dd8aef2e03084b83de72832f9cba7484f23c65a391422ad815a.php(43): craft\web\twig\Template->display(Array, Array)
  99. #20 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_04f135b11dbca17161a76db3111379206ebd24b9188dd0e4c2b104d05c9921ec->doDisplay(Array, Array)
  100. #21 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
  101. #22 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
  102. #23 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
  103. #24 /Applications/MAMP/htdocs/privatename/storage/runtime/compiled_templates/e5/e5618c5c89c80ee33f7af85dc0c27dedafffe77d56da280f203707f00f63e553.php(45): craft\web\twig\Template->display(Array, Array)
  104. #25 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(407): __TwigTemplate_a2025d8d9185338572be64e0b1121da30c11195a31b231d50344ed13853ef95c->doDisplay(Array, Array)
  105. #26 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(52): Twig\Template->displayWithErrorHandling(Array, Array)
  106. #27 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(380): craft\web\twig\Template->displayWithErrorHandling(Array, Array)
  107. #28 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/twig/Template.php(34): Twig\Template->display(Array, Array)
  108. #29 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Template.php(392): craft\web\twig\Template->display(Array)
  109. #30 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/TemplateWrapper.php(45): Twig\Template->render(Array, Array)
  110. #31 /Applications/MAMP/htdocs/privatename/vendor/twig/twig/src/Environment.php(318): Twig\TemplateWrapper->render(Array)
  111. #32 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(343): Twig\Environment->render('advice/_sector', Array)
  112. #33 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/View.php(393): craft\web\View->renderTemplate('advice/_sector', Array)
  113. #34 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(243): craft\web\View->renderPageTemplate('advice/_sector', Array)
  114. #35 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/controllers/TemplatesController.php(95): craft\web\Controller->renderTemplate('advice/_sector', Array)
  115. #36 [internal function]: craft\controllers\TemplatesController->actionRender('advice/_sector', Array)
  116. #37 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/InlineAction.php(57): call_user_func_array(Array, Array)
  117. #38 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Controller.php(157): yii\base\InlineAction->runWithParams(Array)
  118. #39 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Controller.php(187): yii\base\Controller->runAction('render', Array)
  119. #40 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Module.php(528): craft\web\Controller->runAction('render', Array)
  120. #41 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(298): yii\base\Module->runAction('templates/rende...', Array)
  121. #42 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/web/Application.php(103): craft\web\Application->runAction('templates/rende...', Array)
  122. #43 /Applications/MAMP/htdocs/privatename/vendor/craftcms/cms/src/web/Application.php(283): yii\web\Application->handleRequest(Object(craft\web\Request))
  123. #44 /Applications/MAMP/htdocs/privatename/vendor/yiisoft/yii2/base/Application.php(386): craft\web\Application->handleRequest(Object(craft\web\Request))
  124. #45 /Applications/MAMP/htdocs/privatename/public_html/index.php(21): yii\base\Application->run()
  125. #46 {main}
  126. Additional Information:
  127. Array
  128. (
  129.     [0] => HY093
  130.     [1] => 0
  131. )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement