Construiește un magazin online
$30-250 USD
Pagado a la entrega
Am facut update la magento 1.9.2.2 de la 1.9.2.1 si am ceva probleme. Nu pot intra in pagina de categorii, iar in home page nu se mai afiseaza sliderul.
Cand incerc sa intru in categorii primesc o eroarea aceasta:
SQLSTATE[42000]: Syntax error or access violation: 1064 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 '.`value)` = 1) GROUP BY `main_table`.`brand_id` HAVING (SUM(IF( product.entity_i' at line 5, query was: SELECT `main_table`.*, IF([url removed, login to view] IS NULL,[url removed, login to view],[url removed, login to view]) AS `name`, SUM(IF( product.entity_id > 0, 1, 0 )) AS `number_product` FROM `brand` AS `main_table`
LEFT JOIN (SELECT `main_table`.* FROM `brand_store_value` AS `main_table` WHERE (`store_id` = '5') AND (`attribute_code` = 'name')) AS `brand_value_name` ON main_table.brand_id = brand_value_name.brand_id
LEFT JOIN `brand_store_value` AS `brand_status` ON main_table.brand_id = brand_status.brand_id AND brand_status.store_id = 5 AND brand_status.attribute_code = 'status'
LEFT JOIN (SELECT `e`.`entity_id`, `e`.`type_id`, `e`.`attribute_set_id`, `cat_index`.`position` AS `cat_index_position`, `e`.`status`, `e`.`visibility` FROM `catalog_product_flat_5` AS `e`
INNER JOIN `catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=5 AND cat_index.category_id = '46' WHERE ([url removed, login to view] = 1) AND ([url removed, login to view] IN(1)) AND ([url removed, login to view] IN(3, 2, 4))) AS `product` ON FIND_IN_SET(product.entity_id,main_table.product_ids) WHERE (`IF(brand_status`.`value IS NULL, main_table`.`status, brand_status`.`value)` = 1) GROUP BY `main_table`.`brand_id` HAVING (SUM(IF( product.entity_id > 0, 1, 0 )) != 0) ORDER BY position_brand DESC, name ASC
.....
Nº del proyecto: #8927906
Sobre el proyecto
Adjudicado a:
Hello Dear. I can fix following error which occurred after install the latest upgrade on your store. Look forward for your reply. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in yo Más
4 freelancers están ofertando un promedio de $97 por este trabajo
im magento developer with 2 years exp about magento backend(sales,checkout,payment,custom module) and frontend. im responsibility with my work, and your project, i can do it. We can discuss right now about project.