SQLException ERROR: Could not execute query [Native Error: Got error 28 from storage engine] [User Info:
SELECT EavDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavDateValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavStringValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavStringValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavNumericValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavNumericValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavItem.objectID, EavItem.fieldID, EavValue.value, EavValue.ID, EavValue.position, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.*
FROM EavItem
LEFT JOIN EavValue ON EavItem.valueID = EavValue.ID
LEFT JOIN
EavField ON EavItem.fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition]
FILE TRACE:
0: "/var/www/vhosts/parquet.lt/httpdocs/library/activerecord/ActiveRecord.php":1278 - MySQLConnection->executeQuery("
SELECT EavDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavDateValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavStringValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavStringValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavNumericValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavNumericValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavItem.objectID, EavItem.fieldID, EavValue.value, EavValue.ID, EavValue.position, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.*
FROM EavItem
LEFT JOIN EavValue ON EavItem.valueID = EavValue.ID
LEFT JOIN
EavField ON EavItem.fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
1: "/var/www/vhosts/parquet.lt/httpdocs/application/model/eavcommon/EavSpecificationManagerCommon.php":921 - ActiveRecord::getDataBySQL("
SELECT EavDateValue.*, NULL AS valueID, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavDateValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavStringValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavStringValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavNumericValue.*, NULL, NULL AS specFieldValuePosition, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.* as valueID FROM EavNumericValue
LEFT JOIN
EavField ON fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36)
UNION
SELECT EavItem.objectID, EavItem.fieldID, EavValue.value, EavValue.ID, EavValue.position, EavFieldGroup.position AS SpecFieldGroupPosition, EavFieldGroup.name AS SpecFieldGroupName, EavField.*
FROM EavItem
LEFT JOIN EavValue ON EavItem.valueID = EavValue.ID
LEFT JOIN
EavField ON EavItem.fieldID = EavField.ID
LEFT JOIN
EavFieldGroup ON EavField.eavFieldGroupID = EavFieldGroup.ID
WHERE
objectID IN (2, 36) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
2: "/var/www/vhosts/parquet.lt/httpdocs/application/model/eavcommon/EavSpecificationManagerCommon.php":931 - EavSpecificationManagerCommon::fetchRawSpecificationData("EavSpecificationManager", Array, true)
3: "/var/www/vhosts/parquet.lt/httpdocs/application/model/eavcommon/EavSpecificationManagerCommon.php":685 - EavSpecificationManagerCommon::fetchSpecificationData("EavSpecificationManager", Array, true)
4: "/var/www/vhosts/parquet.lt/httpdocs/application/model/eav/EavSpecificationManager.php":181 - EavSpecificationManagerCommon::loadSpecificationForRecordSetArray("EavSpecificationManager", Array, true, false)
5: "/var/www/vhosts/parquet.lt/httpdocs/application/model/ActiveRecordModel.php":404 - EavSpecificationManager::loadSpecificationForRecordSetArray(Array, true)
6: "/var/www/vhosts/parquet.lt/httpdocs/application/LiveCart.php":579 - ActiveRecordModel::loadEav()
7: "/var/www/vhosts/parquet.lt/httpdocs/framework/Application.php":393 - LiveCart->postProcessResponse((object)ActionResponse, (object)ErrController)
8: "/var/www/vhosts/parquet.lt/httpdocs/application/LiveCart.php":540 - Application->execute((object)ErrController, "database")
9: "/var/www/vhosts/parquet.lt/httpdocs/framework/Application.php":273 - LiveCart->execute((object)ErrController, "database")
10: "/var/www/vhosts/parquet.lt/httpdocs/application/LiveCart.php":256 - Application->run(false)
11: "/var/www/vhosts/parquet.lt/httpdocs/public/index.php":141 - LiveCart->run()
12: "/var/www/vhosts/parquet.lt/httpdocs/public/index.php":218 - runApp((object)LiveCart)
13: "/var/www/vhosts/parquet.lt/httpdocs/public/index.php":229 - runApp()