DataBase Exception Error

[J.Sahu]

I got a different type of error today while searching for a product in my shop.

Here is the code but the screen shot can better explain it. What Kind of Exception is this ? Please shade some light on it.

 

SELECT product_shop.id_product, MAX(product_attribute_shop.id_product_attribute) id_product_attribute  FROM `awfps_product` p   INNER JOIN awfps_product_shop product_shop  ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)  LEFT JOIN  `awfps_product_attribute` pa ON (product_shop.id_product = pa.id_product)   LEFT JOIN awfps_product_attribute_shop product_attribute_shop  ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.default_on = 1)  WHERE product_shop.`active` = 1   AND (( product_shop.`id_product` = 38) OR( product_shop.`id_product` = 40) OR( product_shop.`id_product` = 41) OR( product_shop.`id_product` = 42) OR( product_shop.`id_product` = 43) OR( product_shop.`id_product` = 44) OR( product_shop.`id_product` = 45) OR( product_shop.`id_product` = 46) OR( product_shop.`id_product` = 47) OR( product_shop.`id_product` = 48) OR( product_shop.`id_product` = 49) OR( product_shop.`id_product` = 50) OR( product_shop.`id_product` = 51) OR( product_shop.`id_product` = 9) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 434) OR( product_shop.`id_product` = 552) OR( product_shop.`id_product` = 645) OR( product_shop.`id_product` = 659) OR( product_shop.`id_product` = 662) OR( product_shop.`id_product` = 663) OR( product_shop.`id_product` = 664) OR( product_shop.`id_product` = 665) OR( product_shop.`id_product` = 666) OR( product_shop.`id_product` = 668) OR( product_shop.`id_product` = 676) OR( product_shop.`id_product` = 767) OR( product_shop.`id_product` = 772) OR( product_shop.`id_product` = 827) OR( product_shop.`id_product` = 54) OR( product_shop.`id_product` = 55) OR( product_shop.`id_product` = 56) OR( product_shop.`id_product` = 57) OR( product_shop.`id_product` = 58) OR( product_shop.`id_product` = 59) OR( product_shop.`id_product` = 60) OR( product_shop.`id_product` = 61) OR( product_shop.`id_product` = 62) OR( product_shop.`id_product` = 64) OR( product_shop.`id_product` = 65) OR( product_shop.`id_product` = 66) OR( product_shop.`id_product` = 67) OR( product_shop.`id_product` = 68) OR( product_shop.`id_product` = 69) OR( product_shop.`id_product` = 70) OR( product_shop.`id_product` = 71) OR( product_shop.`id_product` = 72) OR( product_shop.`id_product` = 73) OR( product_shop.`id_product` = 74) OR( product_shop.`id_product` = 75) OR( product_shop.`id_product` = 76) OR( product_shop.`id_product` = 77) OR( product_shop.`id_product` = 78) OR( product_shop.`id_product` = 79) OR( product_shop.`id_product` = 80) OR( product_shop.`id_product` = 81) OR( product_shop.`id_product` = 82) OR( product_shop.`id_product` = 83) OR( product_shop.`id_product` = 84) OR( product_shop.`id_product` = 85) OR( product_shop.`id_product` = 86) OR( product_shop.`id_product` = 87) OR( product_shop.`id_product` = 88) OR( product_shop.`id_product` = 89) OR( product_shop.`id_product` = 90) OR( product_shop.`id_product` = 91) OR( product_shop.`id_product` = 92) OR( product_shop.`id_product` = 93) OR( product_shop.`id_product` = 94) OR( product_shop.`id_product` = 95) OR( product_shop.`id_product` = 96) OR( product_shop.`id_product` = 97) OR( product_shop.`id_product` = 98) OR( product_shop.`id_product` = 99) OR( product_shop.`id_product` = 100) OR( product_shop.`id_product` = 101) OR( product_shop.`id_product` = 102) OR( product_shop.`id_product` = 103) OR( product_shop.`id_product` = 105) OR( product_shop.`id_product` = 106) OR( product_shop.`id_product` = 107) OR( product_shop.`id_product` = 108) OR( product_shop.`id_product` = 109) OR( product_shop.`id_product` = 110) OR( product_shop.`id_product` = 111) OR( product_shop.`id_product` = 112) OR( product_shop.`id_product` = 113) OR( product_shop.`id_product` = 114) OR( product_shop.`id_product` = 115) OR( product_shop.`id_product` = 116) OR( product_shop.`id_product` = 117) OR( product_shop.`id_product` = 118) OR( product_shop.`id_product` = 119) OR( product_shop.`id_product` = 120) OR( product_shop.`id_product` = 121) OR( product_shop.`id_product` = 122) OR( product_shop.`id_product` = 123) OR( product_shop.`id_product` = 124) OR( product_shop.`id_product` = 125) OR( product_shop.`id_product` = 126) OR( product_shop.`id_product` = 127) OR( product_shop.`id_product` = 128) OR( product_shop.`id_product` = 129) OR( product_shop.`id_product` = 130) OR( product_shop.`id_product` = 131) OR( product_shop.`id_product` = 132) OR( product_shop.`id_product` = 133) OR( product_shop.`id_product` = 134) OR( product_shop.`id_product` = 135) OR( product_shop.`id_product` = 136) OR( product_shop.`id_product` = 137) OR( product_shop.`id_product` = 138) OR( product_shop.`id_product` = 139) OR( product_shop.`id_product` = 140) OR( product_shop.`id_product` = 141) OR( product_shop.`id_product` = 142) OR( product_shop.`id_product` = 49) OR( product_shop.`id_product` = 556) OR( product_shop.`id_product` = 443) OR( product_shop.`id_product` = 902) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 402) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product` = 393) OR( product_shop.`id_product` = 404) OR( product_shop.`id_product` = 407) OR( product_shop.`id_product` = 387) OR( product_shop.`id_product` = 392) OR( product_shop.`id_product

and here is the url 

http://www.allworldfurniture.com/search?controller=search&orderby=position&orderway=desc&search_query=Lucent+LED+Lit+Dining+Table+Set+by+VIG+Furniture

Edited January 31, 2014 by J.Sahu (see edit history)

[vekia]

"out of memory" - not enough memory to run this query, as far as i remember this is not first time when you've got errors like this one

[J.Sahu]

I's getting internal server error and and other error but got this error this time. I've decided to upgrade my host provider.