Author Topic: Old Path/Url in Database  (Read 256 times)

MAD King

  • Jr. Member
  • **
  • Posts: 447
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Old Path/Url in Database
« on: September 17, 2022, 00:17:58 am »
I have the URL for images set to

images/virtuemart/

right after installation years ago and I just noticed that there are many, many URLs with

images/stories/virtuemart/

still in the database.

Is there a way to remove these?
Joomla! 3.10.10
VirtueMart 4.0.6 10690

Darko F.

  • Beginner
  • *
  • Posts: 28
  • Skype Name: DarkoF
  • VirtueMart Version: VirtueMart 4.0.4 10688
Re: Old Path/Url in Database
« Reply #1 on: September 17, 2022, 10:59:09 am »
Hi
/stories/virtuemart/ is usualy conected with RO CSVI component
You can safely remove this folder via FTP, if you know what you doing and VirtueMart don't use it any more.

If your VirtueMart still using these folder and you vremove it you will have trouble.

Hope this help.
There in no problem if you fall. Problem is if you don't get up

MAD King

  • Jr. Member
  • **
  • Posts: 447
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Re: Old Path/Url in Database
« Reply #2 on: September 17, 2022, 14:14:11 pm »
Hi
/stories/virtuemart/ is usualy conected with RO CSVI component
You can safely remove this folder via FTP, if you know what you doing and VirtueMart don't use it any more.

If your VirtueMart still using these folder and you vremove it you will have trouble.

I am not sure if you read my post.
Hope this help.

Joomla! 3.10.10
VirtueMart 4.0.6 10690

Darko F.

  • Beginner
  • *
  • Posts: 28
  • Skype Name: DarkoF
  • VirtueMart Version: VirtueMart 4.0.4 10688
Re: Old Path/Url in Database
« Reply #3 on: September 17, 2022, 22:40:59 pm »
Hi
Sorry I try just to point you one possible way where this your link in database came from.

Didn't know i need to give a complete instruction how to delete links from your database

Ok here it is the way to remove these:

In some database editor like PHPMyadmin

Go there and checkbox next to your databases, best for you to check select all checkbox.

Then find button where you can select what to do and select - empty or truncate checked  databases.

And here you go, you will delete your  links and all of the rest of your troubles will also gone.

Hope this helps.

There in no problem if you fall. Problem is if you don't get up

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3887
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Old Path/Url in Database
« Reply #4 on: September 23, 2022, 06:33:54 am »
I have the URL for images set to

images/virtuemart/

right after installation years ago and I just noticed that there are many, many URLs with

images/stories/virtuemart/

still in the database.

Is there a way to remove these?

Are the url's really orphaned? If not then you have to change them instead. Regular lab has this component
https://regularlabs.com/dbreplacer
that makes replacement a breeze.

Jörgen @ Kreativ Fotografi
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

MAD King

  • Jr. Member
  • **
  • Posts: 447
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Re: Old Path/Url in Database
« Reply #5 on: September 23, 2022, 14:11:03 pm »
I have the URL for images set to

images/virtuemart/

right after installation years ago and I just noticed that there are many, many URLs with

images/stories/virtuemart/

still in the database.

Is there a way to remove these?

Are the url's really orphaned? If not then you have to change them instead. Regular lab has this component
https://regularlabs.com/dbreplacer
that makes replacement a breeze.

Jörgen @ Kreativ Fotografi

Hi Jörgen,

yes, they are orphaned.
Joomla! 3.10.10
VirtueMart 4.0.6 10690

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3887
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Old Path/Url in Database
« Reply #6 on: September 23, 2022, 14:30:28 pm »
Then take a backup of the database.
Delete the unwanted entries and see what happens.

Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

MAD King

  • Jr. Member
  • **
  • Posts: 447
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Re: Old Path/Url in Database
« Reply #7 on: September 23, 2022, 14:59:36 pm »
Then take a backup of the database.
Delete the unwanted entries and see what happens.

Jörgen

I know. I just thought there would be a function to have the DB cleaned automatically.
Joomla! 3.10.10
VirtueMart 4.0.6 10690

Jörgen

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3887
    • Kreativ Fotografi
  • VirtueMart Version: 3.4.x
Re: Old Path/Url in Database
« Reply #8 on: September 23, 2022, 15:10:39 pm »
Only Max knows the relations between the tables. If he hasn't thought of such a tool, the database can not know what is obsolete info.
Jörgen
Joomla 3.9.18
Virtuemart 3.4.x
Olympiantheme Hera (customized)
This reflects current status when viewing old post.

MAD King

  • Jr. Member
  • **
  • Posts: 447
  • Supporter Membership - Gold
  • VirtueMart Version: Always the Latest
Re: Old Path/Url in Database
« Reply #9 on: September 23, 2022, 15:14:23 pm »
Only Max knows the relations between the tables. If he hasn't thought of such a tool, the database can not know what is obsolete info.
Jörgen

Good one!! lol
Joomla! 3.10.10
VirtueMart 4.0.6 10690