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

 
jero replied on at Permalink Best Answer Reply
jero
The answer is in the error message you posted:

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.
spwilliam replied on at Permalink Reply
Thanks, jero. I got in touch with the hosting server and they helped install 5.7.
jero replied on at Permalink Reply
jero
You're welcome. Glad it's working.