Construiește un magazin online

Completado Publicado Nov 18, 2015 Pagado a la entrega
Completado 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

.....

Comercio electrónico HTML Diseño de sitios web

Nº del proyecto: #8927906

Sobre el proyecto

4 propuestas Proyecto remoto Activo Nov 18, 2015

Adjudicado a:

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 Más

$50 USD en 1 día
(10 comentarios)
3.0

4 freelancers están ofertando un promedio de $97 por este trabajo

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 en 2 días
(9 comentarios)
3.8
Avi1980

A proposal has not yet been provided

$122 USD en 2 días
(0 comentarios)
0.0