News:

Looking for documentation? Take a look on our wiki

Main Menu

Old Path/Url in Database [solved]

Started by MAD King, September 17, 2022, 00:17:58 AM

Previous topic - Next topic

MAD King

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! 4.3.4
VirtueMart 4.2.4 10922

Darko F.

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

Quote from: Darko F. 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.

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

Joomla! 4.3.4
VirtueMart 4.2.4 10922

Darko F.

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

Quote from: MAD King 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?

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

Quote from: Jörgen on September 23, 2022, 06:33:54 AM
Quote from: MAD King 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?

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! 4.3.4
VirtueMart 4.2.4 10922

Jörgen

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

Quote from: Jörgen 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

I know. I just thought there would be a function to have the DB cleaned automatically.
Joomla! 4.3.4
VirtueMart 4.2.4 10922

Jörgen

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

Quote from: Jörgen 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

Good one!! lol
Joomla! 4.3.4
VirtueMart 4.2.4 10922

Milbo

I could write one. :-) There is actually a function already for the stories folder "getStoriesFB". But that wont work here.

A simple function would be to remove the "stories" from the url. A better function checks any image in the stories folders,.. if it is not available in the normal folder than it is moved and the url updated. If there are two images, take a hash, if it is the same, delete the stories image. If you have 2 different images, show a warning.

100 Bugs and you are onboard. https://extensions.virtuemart.net/support/virtuemart-supporter-membership-silver-detail
Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/

MAD King

#11
I removed it by selecting "Missing" and "Orphaned Media" in the Media Managed. Worked perfectly.
Joomla! 4.3.4
VirtueMart 4.2.4 10922

Milbo

Should I fix your bug, please support the VirtueMart project and become a member
______________________________________
Extensions approved by the core team: http://extensions.virtuemart.net/