Advertisement
Guest User

Untitled

a guest
Jun 18th, 2019
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax;
  2. check the manual that corresponds to your MariaDB server version for the right syntax to use
  3. near 'condition IS NOT NULL)' at line 5, query was:
  4.  
  5. UPDATE `catalog_product_flat_1_tmp_indexer` AS `et`
  6. LEFT JOIN `eav_attribute_option_value` AS `t0` ON t0.option_id = et.condition AND t0.store_id = 0
  7. LEFT JOIN `eav_attribute_option_value` AS `ts` ON ts.option_id = et.condition AND ts.store_id = 1
  8. SET `et`.`condition_value` = IFNULL(ts.value, t0.value)
  9. WHERE (condition IS NOT NULL)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement