An exception occurred while executing.... syntax error
Permalink
Hi,
I tried installing concrete5.7.5.6 but got the error below. Can someone please help? Thanks.
An exception occurred while executing 'select CollectionVersionBlocks.isOriginal, CollectionVersionBlocks.cbIncludeAll, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings, CollectionVersionBlocks.cbOverrideBlockTypeContainerSettings, CollectionVersionBlocks.cbEnableBlockContainer, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = ? and CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = ?' with params ["Sidebar", "168", "1", "29"]: SQLSTATE[42000]: Syntax error or access violation: 1226 User 'xxxx' has exceeded the 'max_questions' resource (current value: 75000).
I tried installing concrete5.7.5.6 but got the error below. Can someone please help? Thanks.
An exception occurred while executing 'select CollectionVersionBlocks.isOriginal, CollectionVersionBlocks.cbIncludeAll, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings, CollectionVersionBlocks.cbOverrideBlockTypeContainerSettings, CollectionVersionBlocks.cbEnableBlockContainer, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = ? and CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = ?' with params ["Sidebar", "168", "1", "29"]: SQLSTATE[42000]: Syntax error or access violation: 1226 User 'xxxx' has exceeded the 'max_questions' resource (current value: 75000).
Syntax error or access violation: 1226 User 'xxxx' has exceeded the 'max_questions' resource (current value: 75000).
I'd suggest you get in touch with your hosting company and ask them to increase the value of max_questions for your mysql user 'xxxx'
max_questions is a per hour figure, so that would imply that you've managed to run more than 75000 queries in one hour. I've no idea what value you should use but it clearly needs to be higher or unlimited.