Update application/model/eavcommon/EavSpecificationManagerCommon.php

With this one it should work ok. it fixes this error:

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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition] 
FILE TRACE:

0: "/home/elgery/public_html/babyname.co.il/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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
1: "/home/elgery/public_html/babyname.co.il/application/model/eavcommon/EavSpecificationManagerCommon.php":776 - 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) 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, 1948, 53, 2107, 29, 725, 24, 66, 2052, 2050, 2035, 1353, 1926) ORDER BY objectID, SpecFieldGroupPosition, position, specFieldValuePosition")
2: "/home/elgery/public_html/babyname.co.il/application/model/eavcommon/EavSpecificationManagerCommon.php":786 - EavSpecificationManagerCommon::fetchRawSpecificationData("EavSpecificationManager", Array, true)
3: "/home/elgery/public_html/babyname.co.il/application/model/eavcommon/EavSpecificationManagerCommon.php":633 - EavSpecificationManagerCommon::fetchSpecificationData("EavSpecificationManager", Array, true)
4: "/home/elgery/public_html/babyname.co.il/application/model/eav/EavSpecificationManager.php":106 - EavSpecificationManagerCommon::loadSpecificationForRecordSetArray("EavSpecificationManager", Array, true)
5: "/home/elgery/public_html/babyname.co.il/application/model/ActiveRecordModel.php":389 - EavSpecificationManager::loadSpecificationForRecordSetArray(Array, true)
6: "/home/elgery/public_html/babyname.co.il/application/LiveCart.php":570 - ActiveRecordModel::loadEav()
7: "/home/elgery/public_html/babyname.co.il/framework/Application.php":322 - LiveCart->postProcessResponse((object)ActionResponse, (object)ErrController)
8: "/home/elgery/public_html/babyname.co.il/application/LiveCart.php":520 - Application->execute((object)ErrController, "database")
9: "/home/elgery/public_html/babyname.co.il/framework/Application.php":200 - LiveCart->execute((object)ErrController, "database")
10: "/home/elgery/public_html/babyname.co.il/application/LiveCart.php":192 - Application->run(false)
11: "/home/elgery/public_html/babyname.co.il/public/index.php":76 - LiveCart->run()
12: "/home/elgery/public_html/babyname.co.il/public/index.php":153 - runApp((object)LiveCart)
13: "/home/elgery/public_html/babyname.co.il/public/index.php":164 - runApp()