![]() There are multiple reasons that a 500 Internal Server Error can happen on a website. when we try to export from System Export/Import page, am getting the following two errors.įatal error: Uncaught exception ‘ErrorException’ with message ‘Error: Table ‘opencart3.oc_product_tag’ doesn’t existError No: 1146 SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR ',' ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR ',' ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR ',' ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_ in E:\xampp\htdocs\opencart3\system\database\mysqli.php on line 41įatal Error: Uncaught exception ‘ErrorException’ with message ‘Error: Table ‘opencart3.oc_product_tag’ doesn’t existError No: 1146SELECT p.product_id, pd.name, GROUP_CONCAT( DISTINCT CAST(pc.category_id AS CHAR(11)) SEPARATOR “,” ) AS categories, p.sku, p.upc, p.location, p.quantity, p.model, m.name AS manufacturer, p.image AS image_name, p.shipping, p.price, p.points, p.date_added, p.date_modified, p.date_available, p.weight, wc.unit, p.length, p.width, p.height, p.status, p.tax_class_id, p.viewed, p.sort_order, pd.language_id, ua.keyword, pd.description, pd.meta_description, pd.meta_keyword, p.stock_status_id, mc.unit AS length_unit, p.subtract, p.minimum, GROUP_CONCAT( DISTINCT CAST(pr.related_id AS CHAR(11)) SEPARATOR “,” ) AS related, GROUP_CONCAT( DISTINCT pt.tag SEPARATOR “,” ) AS tags FROM `oc_product` p LEFT JOIN `oc_product_description` pd ON p.product_id=pd.product_id AND pd.language_id=1 LEFT JOIN `oc_product_to_category` pc ON p.product_id=pc.product_ in E:\xampp\htdocs\opencart3\system\database\mysqli.php on line 41Ĭan you please let me know where it went wrong. It just works, as simple as that! Follow us in FaceBook NOTE: We are not able to provide any support anymore.Everything is configured as mentioned. If the keyword is already in use, an error will appear and display on the screen and the administrator will not be able to save the product/category/manufacturer etc., before choose unique keyword. The extension simply will check whether SEO keyword is used already or not. ![]() Get this mod installed and you will be no longer able to make the duplicate keyword mistake again! As a result, the visitors of the website are no longer able to open both products or category with this duplicated SEO URLs.Īnother unpleasant result of this unwilling action is that Search Engines just get confusedĪvoid Keyword Duplication extension is simple and cheap solution, which will help you to avoid this situations. However, you have to know that when you did this you unknowingly duplicate SEO urls of product and category pages. ![]() ![]() This just happens sometimes, you can make it unwillingly, especially when you have a lot of products and Have you ever made that annoying mistake to duplicate the SEO keyword for product or for category?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |