all infinite_scroll on with SQL

Start
Prev
1
Next
End

erickb
Topic Author
Away

Posts: 2605
Thank you received: 65
Hikashop Business

6 years 1 month ago #288798

-- HikaShop version -- : 3.3.0
-- Joomla version -- : 3.8.5
-- PHP version -- : 7.1

I didn't want to check all my menu links to set infinite_scroll to on

with SQL

1) Remove existing infinite_scroll

UPDATE #__menu
SET params = REPLACE(params, '"infinite_scroll":"1",', '')
WHERE `link` LIKE '%com_hikashop&view=product%';

UPDATE #__menu
SET params = REPLACE(params, '"infinite_scroll":"0",', '')
WHERE `link` LIKE '%com_hikashop&view=product%';

2) check if they are all removed

SELECT * FROM `#__menu` WHERE `params` LIKE '%infinite_scroll%';

3) Set all ON

UPDATE saces_menu
SET params = REPLACE(params, '"background_color"', '"infinite_scroll":"1","background_color"')
WHERE `link` LIKE '%com_hikashop&view=product%';

Last edit: 6 years 1 month ago by erickb.

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

Start
Prev
1
Next
End

Time to create page: 0.054 seconds