need to remove some stuff from description

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
3 years 9 months ago #329374

-- url of the page with the problem -- : www.ifixmachines.com
-- HikaShop version -- : 4.4.0
-- Joomla version -- : 3.9.24
-- PHP version -- : 7.4.14
-- Browser(s) name and version -- : chrome
-- Error-message(debug-mod must be tuned on) -- : none

I have a site from 2009 that I imported into hikashop I'd like to use mass action to remove a line of code from the description if is found.

this is the code that is in about 1/2 of my product descrptions. <hr id="system-readmore" />

Can you help me code the proper query string and action to remove it.

HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
3 years 9 months ago #329379

Hi,

You want to have an action "update the values" on the product_description column with the type "operation" and the value:

REPLACE('<hr id="system-readmore" />', '',product.product_description)

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

  • Posts: 33
  • Thank you received: 2
  • Hikashop Business
3 years 9 months ago #329592

It removes the complete description if the <hr id="system-readmore" /> is found in the description.

here is a link to the mass action page of the operation.

nimb.ws/HyYhkN

HikaShop Business 2.6.0

PHP Version 5.6.16
Web Server Apache

Joomla! 3.4.8 Stable [ Ember ] 24-December-2015 19:30 GMT

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

  • Posts: 82867
  • Thank you received: 13374
  • MODERATOR
3 years 9 months ago #329599

Hi,

My bad, I put the parameters in the wrong order:
www.w3resource.com/mysql/string-function...replace-function.php
it should be:
REPLACE(product.product_description,'<hr id="system-readmore" />', '')

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

Time to create page: 0.059 seconds
Powered by Kunena Forum