Hi Simon
I have looked in the file : catalog/controller/product/product.php and i do not see your code, i am using 1.4.9.1.
I have opened a new topic http://forum.opencart.com/viewtopic.php?f=20&t=57626and wondered if you had any ideas
I have looked in the file : catalog/controller/product/product.php and i do not see your code, i am using 1.4.9.1.
I have opened a new topic http://forum.opencart.com/viewtopic.php?f=20&t=57626and wondered if you had any ideas
I dont know if its too late or anything, but I was using the modified version of seo_url.php and every time I tried to add something to my basked from the homepage or category page, I got a mysql error.
So i looked and saw this :
It adds a semicolon to the $value var (the product_id = 50, it should not have a ';' after 50). This is what I did to fix it
Hope I have helped someone
Code: Select all
<b>Fatal error</b>: Uncaught exception 'ErrorException' with message 'Error: 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 'AND
Code: Select all
.... oc_product_to_category AS pc
WHERE
pc.product_id=50; AND
pc.category_id=c.category_id ...
Code: Select all
$value = rtrim($value, ";");
If this issue with sub categories not working as you think they should is still bothering you. Check out the link below.
http://stackoverflow.com/questions/1091 ... s#24634134
http://stackoverflow.com/questions/1091 ... s#24634134
i replace our code with your seo_url.php file. i used version 2.1.0.2. it works for me adding product category name in featured products url. before that my featured product url is"https://www.neevov.com/kids-black-round ... alf-sleeve" after using your file my url is"https://www.neevov.com/kids/kids-black- ... alf-sleeve" that fine but i got an error
Fatal error: Call to undefined method ControllerCommonSeoUrl::forward() in /..../...../public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php on line 139
so please tell me how to remove this error. as soon as possible.
Fatal error: Call to undefined method ControllerCommonSeoUrl::forward() in /..../...../public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php on line 139
so please tell me how to remove this error. as soon as possible.
i replace our code with your seo_url.php file. i used version 2.1.0.2. it works for me adding product category name in featured products url. before that my featured product url is"https://www.neevov.com/kids-black-round ... alf-sleeve" after using your file my url is"https://www.neevov.com/kids/kids-black- ... alf-sleeve" that fine but i got an error
Fatal error: Call to undefined method ControllerCommonSeoUrl::forward() in /..../...../public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php on line 139
so please tell me how to remove this error. as soon as possible.
Fatal error: Call to undefined method ControllerCommonSeoUrl::forward() in /..../...../public_html/vqmod/vqcache/vq2-catalog_controller_common_seo_url.php on line 139
so please tell me how to remove this error. as soon as possible.
Thanks for this, it still works six years later in OpenCart 2.3.0.2. Although I chose to comment out different lines, the sitemap is now only producing 1 url per product which is what I wanted (and I'm assuming this is better for the search engines?)
Although this fixes what's produced in the Google sitemap, does anyone think it will affect search engine ranking just the fact that a product can be reached via 3-4 different url's? Or do search engines like Google know better and know that shopping sites are going to have multiple url's and take that into account when deciding whether or not to penalize duplicate content?
Hey there,
I have some weird bugs with seo url for categories.
I use ssl site.
When i add seo url for categories and open categories it works nice. But when i open products from that category i get html page without pics etc.
If i open products from home page everything working nice, only when i open from the seo category links are not working properly for products.
If i do not put category seo url everything is fine.
I wanted to have a nice sitemap with category named for google indexing.
Is there any solution to this issue?
Here is a link from a category named seo ”accesorii” and ”panou-reclama” is seo for product https://www.xtz.ro/accesorii/panou-reclama
I have some weird bugs with seo url for categories.
I use ssl site.
When i add seo url for categories and open categories it works nice. But when i open products from that category i get html page without pics etc.
If i open products from home page everything working nice, only when i open from the seo category links are not working properly for products.
If i do not put category seo url everything is fine.
I wanted to have a nice sitemap with category named for google indexing.
Is there any solution to this issue?
Here is a link from a category named seo ”accesorii” and ”panou-reclama” is seo for product https://www.xtz.ro/accesorii/panou-reclama
Who is online
Users browsing this forum: Ahrefs [Bot] and 24 guests