I recently did an updated on my website. I first backed up the data on inmotionhosting then I updated the website. Now I'm getting this processing error on my request
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)` = '0') AND (`start_time` <= '2016-06-16') AND (`end_time` >= '2016-06-' at line 2, query was: SELECT `main_table`.*, Rand() AS `order` FROM `mg_bannerslider_banner` AS `main_table`
LEFT JOIN `mg_bannerslider_value` AS `status` ON main_table.banner_id = status.banner_id AND status.store_id = 1 AND status.attribute_code = 'status' WHERE (`bannerslider_id` = '3') AND (`IF(status`.`value IS NULL, main_table`.`status, status`.`value)` = '0') AND (`start_time` <= '2016-06-16') AND (`end_time` >= '2016-06-16') ORDER BY order_banner ASC
and so on.....I am totally stooped and also note that i'm not very familiar with this either. So anything will help!!
Thanks in advance!
Best,
Mee Lia