WARNING: An Error occurred, please refresh the page and try again.

[vandiermen]

[14-Jul-2017 23:31:26 America/Chicago] PHP Fatal error:  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 'distinct p.products_image, pd.products_name, p.products_quantity,  p.products_id' at line 1 :: select distinct p.products_id,  distinct p.products_image, pd.products_name, p.products_quantity,  p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status
       from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id
       where p.products_status = 1
         and p.products_id = p2c.products_id
         and pd.products_id = p2c.products_id
         and pd.language_id = '1'
         and p2c.categories_id IN(6318,6315,6289,6279,6330,6266,6534,6286,6313,6288,6267,6290,6427,6344,6417,6272,6294,6292,6424,6301,6327,6326,6527,6518,6517,6310,6283,6328,6320,6282,6540,6541,6451,6525,6455,6494,6526,6481,6454,6499,6446,6531,6270,6351,6400,6299,6276,6311,6537,6302,6340,6303,6317,6273,6263,6416,6269,6284,6490,6321,6331,6308,6420,6309,6316,6425,6463,6504,6513,6488,6523,6457,6465,6486,6459,6511,6468,6472,6520,6502,6487,6471,6497,6296,6329,6298,6275,6293,6295,6319,6528,6529,6485,6530,6495,6312,6419,6305,6285,6322,6324,6297,6353,6278,6287,6306,6280,6323,6291) order by p.products_sort_order, pd.products_name in /home/customdh/public_html/includes/classes/db/mysql/query_factory.php on line 120

? Started after I switched "show categories on homepage" to on, and was fixed after turning it off.
and started after I installed 'template switch' plugin on top of Tableau template. Switched to classic and then could not switch back and then manually edited the template name in phpmyadmin.

http://customdollhouse.com/index.php...dex&cPath=5688

ez-populate
image handler
heaps of plugins

[carlwhat]

if you can find the line that creates the SQL, you need to remove the second 'DISTINCT' in front of the field 'p.products_image'. then your sql query will run.

you only need the DISTINCT in front of p.products_id

good luck!