Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2010
    Posts
    692
    Plugin Contributions
    0

    Default SQL question... help please!

    In the SQL, what controls the turning on/off of product meta title and product name?

    Here is a screen shot:
    http://904roofing.com/metascreen.jpg

    Can somebody show me how I could write a little script I could send thru the sql patch that would flip the switch to ON for all prod meta titles?

    Then another script to for flipping on all the product names?

    Thanks,
    Mike

  2. #2
    Join Date
    Jan 2004
    Posts
    63,678
    Blog Entries
    5
    Plugin Contributions
    184

    Default Re: SQL question... help please!

    You really should fix your import problem instead: http://www.zen-cart.com/forum/showth...96#post1108596

    This will turn the title/prod-name switches on for EVERY product in your database:
    Code:
    UPDATE products SET metatags_title_status = 1, metatags_products_name_status = 1;
    Use with caution. Backup your database first.
    Last edited by Ajeh; 3 Mar 2012 at 03:28 PM.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Apr 2010
    Posts
    692
    Plugin Contributions
    0

    Default Re: SQL question... help please!

    DrByte,

    Words cannot express how grateful I am! This worked perfectly! If you weren't a dude I'd kiss you!

    I totally agree with you that it would be far better to fix the import problem, but for some reason Apsona forgot to include the metatags_products_name_status field in their ShopAdmin.

    Thanks again,
    Mike

  4. #4
    Join Date
    Jan 2004
    Posts
    63,678
    Blog Entries
    5
    Plugin Contributions
    184

    Default Re: SQL question... help please!

    You can kiss Ajeh instead. She fixed my typo :)
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Apr 2010
    Posts
    692
    Plugin Contributions
    0

    Default Re: SQL question... help please!

    aaah yes, a much more pleasant idea!

 

 

Similar Threads

  1. v151 SQL Patch question - help please!
    By Feznizzle in forum General Questions
    Replies: 13
    Last Post: 3 Feb 2016, 10:38 PM
  2. v150 SQL Error Please help!
    By manu_sag in forum General Questions
    Replies: 1
    Last Post: 1 Apr 2012, 09:48 AM
  3. SQL Error Help Please
    By jmp04 in forum General Questions
    Replies: 5
    Last Post: 30 Jan 2011, 07:20 PM
  4. SQL help please
    By Jeff G in forum General Questions
    Replies: 2
    Last Post: 5 Jun 2009, 09:51 PM
  5. Sql help please
    By jewelrylady in forum General Questions
    Replies: 4
    Last Post: 30 Jan 2007, 07:13 PM

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