Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14
  1. #11
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Changing over to https everywhere

    Can test the sql statement by using a select instead of an update, verify the results, then when satisfied can change it to an update query.

    SELECT replace(products_description, 'http://website.com', '//website.com') from products_description;

    I think is the appropriate sql for the select. Untested.
    Last edited by mc12345678; 11 Sep 2014 at 07:20 PM.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #12
    Join Date
    Feb 2008
    Location
    Tx gulf coast
    Posts
    126
    Plugin Contributions
    0

    Default Re: Changing over to https everywhere

    the href would only apply if the tag was pointing to an address outside of my own website...correct?

    In my product description table, I do not point outside of my own website...so this should not be a concern... If I am thinking clearly (highly suspect)...

    thx

  3. #13
    Join Date
    Jul 2012
    Posts
    16,719
    Plugin Contributions
    17

    Default Re: Changing over to https everywhere

    Quote Originally Posted by CabinetGuy View Post
    the href would only apply if the tag was pointing to an address outside of my own website...correct?

    In my product description table, I do not point outside of my own website...so this should not be a concern... If I am thinking clearly (highly suspect)...

    thx
    Without seeing how the reference http: is used in each case, cannot answer with confidence. However, if the query included src="http:// (properly escaped as appropriate) then how it is/was used is not as much of an issue. The hrefs would/could be found using href="http: and those would still need the applicable https/http prefix. If they are pointing to your local site and you are truly going to go to all https (contrary to some of the earlier discussion) then the https would need to be substituted for the http: of the hrefs. Btw, href ="http:, href= " etc... Should also be looked for just in case formal format was not applied throughout.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  4. #14
    Join Date
    Feb 2008
    Location
    Tx gulf coast
    Posts
    126
    Plugin Contributions
    0

    Default Re: Changing over to https everywhere

    Thanks for your input...

    One more question, if I wanted to run this statement via phpmyadmin, by category, what would I need to add to this query?

    UPDATE products_description SET products_description=replace(products_description, 'http://website.com', '//website.com')

    Thanks for your help.

    Keith

 

 
Page 2 of 2 FirstFirst 12

Similar Threads

  1. Changing to HTTPS
    By enddes in forum General Questions
    Replies: 3
    Last Post: 19 Feb 2010, 03:19 AM
  2. Changing Side Menu from 'click' to 'roll over'?
    By KismetDesign in forum Templates, Stylesheets, Page Layout
    Replies: 3
    Last Post: 2 Aug 2009, 03:26 AM
  3. changing footer on Https
    By Amit001 in forum Templates, Stylesheets, Page Layout
    Replies: 1
    Last Post: 30 Sep 2008, 11:25 AM
  4. Changing Shipping Options when order over £30 ?
    By Beeunique in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 14 Jun 2008, 08:58 AM
  5. templates don't carry over to https
    By Badgermaster in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 17 Apr 2007, 07:09 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR