DB Replacer

Changing file path of Full & Intro image

8 months 2 weeks ago #75345

gavin hookham's Avatar gavin hookham

Hi there

Which Table and Column should I select to change the image file path on the image intro/full.

Thanks
Gav

8 months 2 weeks ago #75353

Peter van Westen's Avatar Peter van Westen Admin

that data is stored in a json string in the 'images' column of the content table.

8 months 2 weeks ago #75363

gavin hookham's Avatar gavin hookham

Ok thanks...am I able to use the extension to change file path then please? Could you provide an example of how to achieve this?

Thanks

8 months 2 weeks ago #75374

Peter van Westen's Avatar Peter van Westen Admin

You should be able to simply replace whatever part of that string you want with something else.

Have you tried?

You can see the result in the preview before you actually do the replacement.

PS: Make backups before you do stuff like this.

8 months 2 weeks ago #75380

gavin hookham's Avatar gavin hookham

Hi there

I select CONTENT then IMAGES and place my 'news-images-2016/news-images-2017' file path in Search but don't get any results...even though I know there are

Do I need the PRO version?

Thanks

8 months 2 weeks ago #75382

Peter van Westen's Avatar Peter van Westen Admin

Apparently the pathe is not in there like that.
Can you give me (super) admin access so I can take a look?
You can use the 'Hidden text' button in the forum editor to hide the confidential information.

8 months 2 weeks ago #75384

gavin hookham's Avatar gavin hookham

Sure please see below:

Confidential information:
(hidden)

8 months 2 weeks ago #75385

Peter van Westen's Avatar Peter van Westen Admin

If you just enter:

news-images-2017
You will see results and see that the actual path in the database is:
news-images-2016\/news-images-2017
So the slash is escaped.
This means:
Search for:
news-images-2016\/news-images-2017

8 months 2 weeks ago #75389

gavin hookham's Avatar gavin hookham

Perfect thanks Peter...all done!