SQLException ERROR: Could not execute query [Native Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as valueID FROM EavDateValue LEFT JOIN EavField ON fieldID = EavField.ID' at line 1] [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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition]
FILE TRACE:

0: "/home/jacfash/public_html/library/activerecord/ActiveRecord.php":1202 - 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
1: "/home/jacfash/public_html/application/model/eavcommon/EavSpecificationManagerCommon.php":784 - 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) 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 (3, 2, 5, 67, 4, 6) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
2: "/home/jacfash/public_html/application/model/eavcommon/EavSpecificationManagerCommon.php":794 - EavSpecificationManagerCommon::fetchRawSpecificationData("EavSpecificationManager", Array, true)
3: "/home/jacfash/public_html/application/model/eavcommon/EavSpecificationManagerCommon.php":642 - EavSpecificationManagerCommon::fetchSpecificationData("EavSpecificationManager", Array, true)
4: "/home/jacfash/public_html/application/model/eav/EavSpecificationManager.php":106 - EavSpecificationManagerCommon::loadSpecificationForRecordSetArray("EavSpecificationManager", Array, true)
5: "/home/jacfash/public_html/application/model/ActiveRecordModel.php":336 - EavSpecificationManager::loadSpecificationForRecordSetArray(Array, true)
6: "/home/jacfash/public_html/application/LiveCart.php":579 - ActiveRecordModel::loadEav()
7: "/home/jacfash/public_html/framework/Application.php":324 - LiveCart->postProcessResponse((object)ActionResponse, (object)ErrController)
8: "/home/jacfash/public_html/application/LiveCart.php":529 - Application->execute((object)ErrController, "database")
9: "/home/jacfash/public_html/framework/Application.php":202 - LiveCart->execute((object)ErrController, "database")
10: "/home/jacfash/public_html/application/LiveCart.php":202 - Application->run(false)
11: "/home/jacfash/public_html/public/index.php":73 - LiveCart->run()
12: "/home/jacfash/public_html/public/index.php":150 - runApp((object)LiveCart)
13: "/home/jacfash/public_html/public/index.php":161 - runApp((object)LiveCart)