Умер поиск

05/04/2011 10:04:35 | 1146 - Table 'aauto_1.os_param' doesn't exist | SELECT distinct
                  p.products_id,
                  p.products_price,
                  p.products_model,
                  p.products_quantity,
                  p.products_shippingtime,
                  p.products_fsk18,
                  p.products_image,
                  p.products_weight,
                  p.products_tax_class_id,
                  pd.products_name,
                  pd.products_short_description,
                  pd.products_description FROM os_products AS p LEFT JOIN os_products_description AS pd ON (p.products_id = pd.products_id)  LEFT OUTER JOIN os_products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN os_products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN os_specials AS s ON (p.products_id = s.products_id) AND s.status = '1' LEFT OUTER JOIN os_products_to_products_extra_fields AS pe ON (p.products_id = pe.products_id) left join os_param pm on p.products_id = pm.product_id WHERE  p.products_status = '1'  AND pd.language_id = '1' AND (  ( pd.products_keywords LIKE ('%rewatre%') OR pd.products_description LIKE ('%rewatre%') OR pd.products_short_description LIKE ('%rewatre%') OR pd.products_name LIKE ('%rewatre%') OR p.products_model LIKE ('%rewatre%')  OR pe.products_extra_fields_value LIKE ('%rewatre%') OR (pov.products_options_values_name LIKE ('%rewatre%') AND pov.language_id = '1') )  ) GROUP BY p.products_id ORDER BY p.products_id  | /advanced_search_result.php?keywords=rewatre

05/04/2011 16:04:45 | 1146 - Table 'aauto_1.os_param' doesn't exist | SELECT distinct
                  p.products_id,
                  p.products_price,
                  p.products_model,
                  p.products_quantity,
                  p.products_shippingtime,
                  p.products_fsk18,
                  p.products_image,
                  p.products_weight,
                  p.products_tax_class_id,
                  pd.products_name,
                  pd.products_short_description,
                  pd.products_description FROM os_products AS p LEFT JOIN os_products_description AS pd ON (p.products_id = pd.products_id)  LEFT OUTER JOIN os_products_attributes AS pa ON (p.products_id = pa.products_id) LEFT OUTER JOIN os_products_options_values AS pov ON (pa.options_values_id = pov.products_options_values_id) LEFT OUTER JOIN os_specials AS s ON (p.products_id = s.products_id) AND s.status = '1' LEFT OUTER JOIN os_products_to_products_extra_fields AS pe ON (p.products_id = pe.products_id) left join os_param pm on p.products_id = pm.product_id WHERE  p.products_status = '1'  AND pd.language_id = '1' AND (  ( pd.products_keywords LIKE ('%esfew%') OR pd.products_description LIKE ('%esfew%') OR pd.products_short_description LIKE ('%esfew%') OR pd.products_name LIKE ('%esfew%') OR p.products_model LIKE ('%esfew%')  OR pe.products_extra_fields_value LIKE ('%esfew%') OR (pov.products_options_values_name LIKE ('%esfew%') AND pov.language_id = '1') )  ) GROUP BY p.products_id ORDER BY p.products_id  | /advanced_search_result.php?keywords=esfew

create table os_param (param_id int(11) auto_increment, product_id int(11), name_id int(11), sort_order int(11), group_id int(11), group_type varchar(255), group_value varchar(255), value_id int(11), primary key (param_id) , index product_id (product_id)) default charset=utf8;