micemincer Posted June 30, 2015 Share Posted June 30, 2015 Hi. Problem is that some products don't have default category assigned (or it is not showing). It dissapeared by itself - see attachement product-list.jpg But on the product page that category is assigned - see attachement default-cat.jpg The product is displayed on frontend in that category. Now - when I hit preview (or paste a link to that product) - there are no breadcrumbs. attachement product-page.jpg But if I navigate to that product - breadcrumbs are ok. What is important - I edited some fields in database - and the edit was done on table product_lang (there is nothing related to category in it) - so - question is - how this edit could cause this behaviour Please help Regards Link to comment Share on other sites More sharing options...
Rolige Posted June 30, 2015 Share Posted June 30, 2015 Enable the debug mode, navigate again in this sections, if something is wrong you will see a warning or fatal error. Link to comment Share on other sites More sharing options...
micemincer Posted July 3, 2015 Author Share Posted July 3, 2015 Hi. After debugging there is an error on every product page - no matter if the product is with "bad category" ort not. The error: Funny thing is that I have a copy of my shop(for testing purposes) and there is everything fine with categories, but there is the same error as above on any product page. And product page is perfectly fine. How to interpret this? Regards, Mac. Link to comment Share on other sites More sharing options...
Rolige Posted July 3, 2015 Share Posted July 3, 2015 I think you have errors in the database, proof of that is the error in the screenshot (category ids is missing), without advanced knowledge you should never touch the database. Link to comment Share on other sites More sharing options...
micemincer Posted July 3, 2015 Author Share Posted July 3, 2015 (edited) Isn't it more like a bad query - exactly the part: id_cateogry IN () - parenthesis should not be empty i think edit: I found a module (some specific payment module - third party) that had that query which throws that error. After disabling that module - rerror is no more. Now I need to test it on my main shop to see if this resolves missing default category. Edited July 3, 2015 by micemincer (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts