How to remove all canonical URLs from hikashop

  • Posts: 713
  • Thank you received: 37
  • Hikashop Business
8 years 8 months ago #210481

-- url of the page with the problem -- : www.ariesgamesandminis.com
-- HikaShop version -- : 2.5.0
-- Joomla version -- : 3.4.3
-- Browser(s) name and version -- : Google Chrome

All,

I've recently discovered a problem, and I don't even know why it's happened...but it seems most of the items on my site have a canonical URL that points to an Australian hosted website.

Per my hosting company...here's the following...

I searched in the database for the domain bmax.com.au and noticed that it is present in the following tables:

7676 matches in jos_redirect_links
75 matches in jos_hikashop_product

There appears to be a redirect plugin that may cause the issue you are experiencing. I can suggest to try disabling that plugin and fix the URL of the products on your site.

How can I go through & delete all of these canonical URL's without having to manually clear each one.

Thanks

Please Log in or Create an account to join the conversation.

  • Posts: 2143
  • Thank you received: 747
8 years 8 months ago #210488

Please Log in or Create an account to join the conversation.

  • Posts: 713
  • Thank you received: 37
  • Hikashop Business
8 years 8 months ago #210509

You sir...are a life saver! I searched but I guess the terms I was using came back with WAY too many listings and I couldn't find what I needed.

Thank you very much!

Question for the support mods...

When I ran this process, it now shows a 0 in the canonical URL's. Is this ok or will it cause issues? I left the action field blank as Nicolas described in the above link.

Last edit: 8 years 8 months ago by Dragon41673.

Please Log in or Create an account to join the conversation.

  • Posts: 26008
  • Thank you received: 4004
  • MODERATOR
8 years 8 months ago #210512

Hi,

It should be ok because "0" will be consider as empty by PHP.
But having a real empty string would be better.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 713
  • Thank you received: 37
  • Hikashop Business
8 years 8 months ago #210568

Ok, so how would I force the mass action tool to leave the field blank rather than having a 0 in the canonical URL field?

Please Log in or Create an account to join the conversation.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
8 years 8 months ago #210569

Hi,

This means that there is a problem with your mass action.
You probably used the "int" type instead of the "string" type for the "update the values" setting of your mass action.
try with a string and make sure that the value field is left empty in your mass action before running it again.

The following user(s) said Thank You: Dragon41673

Please Log in or Create an account to join the conversation.

  • Posts: 713
  • Thank you received: 37
  • Hikashop Business
8 years 8 months ago #210634

You would be correct! I used "int" for the type. I will try the way you mentioned once I'm home from work. Thank you!

Please Log in or Create an account to join the conversation.

  • Posts: 713
  • Thank you received: 37
  • Hikashop Business
8 years 8 months ago #210729

That worked! Thanks Nicolas! All canonical URL's are now empty.

Please Log in or Create an account to join the conversation.

  • Posts: 173
  • Thank you received: 14
  • Hikashop Business
3 weeks 5 hours ago #360178

Hi,
this was working (i.e. replace with a string that is empty) but it's started including quotes in the canonical fields instead of a blank field. Can you check and let me know. Using the latest version as at today.
Ian and Stu

Please Log in or Create an account to join the conversation.

  • Posts: 173
  • Thank you received: 14
  • Hikashop Business
3 weeks 4 hours ago #360180

More info. This only seems to be happening on our joomla3 site and not our joomla4 site.

Regards,
Ian & Stu

Please Log in or Create an account to join the conversation.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
2 weeks 6 days ago #360182

Hi,

Could you provide a screenshot of the mass action ?

Please Log in or Create an account to join the conversation.

  • Posts: 173
  • Thank you received: 14
  • Hikashop Business
2 weeks 6 days ago #360184

Hi,
here's the mass action and the field in the product.
Thanks for taking a look,
Ian & Stu


Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 81540
  • Thank you received: 13071
  • MODERATOR
2 weeks 5 days ago #360200

Hi,

I'm not able to reproduce the issue. I tried on both Joomla 3 and Joomla 5 with the latest version of HikaShop, the 5.0.4, and I didn't had the issue.
So there must be something else to it.
Maybe another mass action ?
Or you're actually not on the 5.0.4 ?

Please Log in or Create an account to join the conversation.

Time to create page: 0.105 seconds
Powered by Kunena Forum