So I'm wanting to make the switch over to full site HTTPS but all my categories (thousands) have an absolute link to an image that is on each category page 5 times (icon for bulleted text). So right now I am going in and manually changing them all from absolute to relative links to the image. This will end up taking my weeks to do. There has got to be a better way right? I know if these were all simply HTML pages saved on my computer I could easily "find and replace" in the files. But not sure how to do this in CS?
I'm not sure where/how you added the images but they are probably stored in the database. After you find out where they are being stored, you can run a query to find and replace.
I'm not sure where/how you added the images but they are probably stored in the database. After you find out where they are being stored, you can run a query to find and replace.
Not really looking to change the image or location (the image is stored in the parent folder outside of my CS installation folder and just linked to it). I need to change the location LINK SOURCE TO THE IMAGE to a relative link on all of my category pages. Right now on all of my pages I have something like this for the image source: src="http://www.mysite.com/myimage.png I need to change that to src="/myimage.png
Where exactly is the Image source input on the category page? Description?
If they are in the description then run this query...
UPDATE cscart_category_descriptions SET description = REPLACE(description, 'http://www.mysite.com', '');
Backup the table before running the query.
As alternative, you can check hooks in the blocks render manager and change content with the My changes module
Hi all
Is it any solution which could be described in simple words? Have no ide what are “hooks” and how to use it, but I can manage everything wia MySQL.
Just moved to HTTPS but images at the text pages still http, it seems not an relative paths.
All automated images like on product pages are https.
Hi all
Is it any solution which could be described in simple words? Have no ide what are "hooks" and how to use it, but I can manage everything wia MySQL.
Just moved to HTTPS but images at the text pages still http, it seems not an relative paths.
All automated images like on product pages are https.
We could write a simple script that will iterate over the DB which contains http links and replace them with https links, contact us if you are interested: sales@poppedweb.com
It would be enough is somebody tell me where the page contents are located in MySQL… I have not so many pages.
If you don't have that many pages then why not edit the pages manually instead of messing with the database directly?
Page descriptions are located in table cscart_page_descriptions.
If you don't have that many pages then why not edit the pages manually instead of messing with the database directly?
Page descriptions are located in table cscart_page_descriptions.
That's what I ended up doing....I just went through and deleted that row of bullets (since it was in a table) on all the pages that had it. Was time consuming but not to the point where it was too much of a job to do once I just figured that deleting that table row would be the simplest solution in my case.
You can also try to run
UPDATE cscart_page_descriptions SET description = REPLACE(description, 'http://', 'https://');