Construiește un magazin online

已完成 已发布的 Nov 18, 2015 货到付款
已完成 货到付款

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

.....

电子商务 HTML 网站设计

项目ID: #8927906

关于项目

4个方案 远程项目 活跃的Nov 18, 2015

授予:

andyweboffice

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 更多

$50 USD 在1天内
(10条评论)
3.0

有4名威客正在参与此工作的竞标,均价$97/小时

hiepnt

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.

$111 USD 在2天内
(9条评论)
3.8
Avi1980

A proposal has not yet been provided

$122 USD 在2天内
(0条评论)
0.0