Construiește un magazin online
$30-250 USD
货到付款
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
.....
项目ID: #8927906
关于项目
授予:
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 更多
有4名威客正在参与此工作的竞标,均价$97/小时
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.