Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    531
    Plugin Contributions
    0

    help question SQL Patch / 403 Forbidden

    The theme I'm installing comes with a readme doc that tells you to install the SQL patch via Admin/Tools ....
    Here is what it shows to install :

    INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
    configuration_description, configuration_group_id, sort_order,
    last_modified, date_added, use_function, set_function)
    VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows',
    'Select the layout style:<br />Each product can be listed in its own row (rows option)
    or products can be listed in multiple columns per row (columns option)', '8', '40', NULL,
    now(), NULL, 'zen_cfg_select_option(array(\'rows\', \'columns\'),');

    INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
    configuration_description, configuration_group_id, sort_order,
    last_modified, date_added, use_function, set_function)
    VALUES ('Product Listing - Columns Per Row', 'PRODUCT_LISTING_COLUMNS_PER_ROW', '3',
    'Select the number of columns of products to show in each row in the product listing.
    The default setting is 3.', '8', '41', NULL, now(), NULL, NULL)



    When I try to install I receive a 403 Forbidden error.... the ending (after my folder names) which reads:

    index.php?cmd=sqlpatch&action=execute (port 443)


    What do I do to correct this so that the patches load?

    Thanks in advance!
    Lalla

  2. #2
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,860
    Plugin Contributions
    108

    Default Re: SQL Patch / 403 Forbidden

    Your hoster may not permit tools like this. Do you have phpMyAdmin? If so, you can run it in there. One caveat: if your database uses a prefix, you will have to adjust the install SQL script accordingly.
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  3. #3
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    531
    Plugin Contributions
    0

    Default Re: SQL Patch / 403 Forbidden

    Quote Originally Posted by swguy View Post
    Your hoster may not permit tools like this. Do you have phpMyAdmin? If so, you can run it in there. One caveat: if your database uses a prefix, you will have to adjust the install SQL script accordingly.
    I host with NameCheap so can't imagine them not permitting it.
    Yes, I have phpMyAdmin. I'll try that.
    Thank you!!

  4. #4
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    531
    Plugin Contributions
    0

    Default Re: SQL Patch / 403 Forbidden

    This is what I get ...


    Error

    SQL query:


    INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows', 'Select the layout style:<br />Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)', '8', '40', NULL, now(), NULL, 'zen_cfg_select_option(array(\'rows\', \'columns\'),')

    MySQL said:
    #1062 - Duplicate entry 'PRODUCT_LISTING_LAYOUT_STYLE' for key 'unq_config_key_zen'

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,514
    Plugin Contributions
    78

    Default Re: SQL Patch / 403 Forbidden

    Those two configuration settings are already present in Zen Cart 1.5.7 and later, no need run that SQL patch.

  6. #6
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    531
    Plugin Contributions
    0

    Default Re: SQL Patch / 403 Forbidden

    Quote Originally Posted by lat9 View Post
    Those two configuration settings are already present in Zen Cart 1.5.7 and later, no need run that SQL patch.
    its supposed to have something to do with the theme and having it setup like the demo works 🤷##♀️

    is that not what it is?
    been awhile since I built a ZenCart site

  7. #7
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,514
    Plugin Contributions
    78

    Default Re: SQL Patch / 403 Forbidden

    Quote Originally Posted by LilleyPadGifts View Post
    its supposed to have something to do with the theme and having it setup like the demo works 路##♀️

    is that not what it is?
    been awhile since I built a ZenCart site
    It's apparently an older theme (not developed for Zen Cart 1.5.7 and later). Those settings (Configuration :: Layout Settings) can be used for your template's customization.

  8. #8
    Join Date
    Jan 2007
    Location
    Southern California
    Posts
    531
    Plugin Contributions
    0

    Default Re: SQL Patch / 403 Forbidden

    Quote Originally Posted by lat9 View Post
    It's apparently an older theme (not developed for Zen Cart 1.5.7 and later). Those settings (Configuration :: Layout Settings) can be used for your template's customization.

    Ahhhh... ok Thank you!!

 

 

Similar Threads

  1. v154 Polipay 403 Forbidden
    By mikecnz in forum Addon Payment Modules
    Replies: 4
    Last Post: 22 Jun 2021, 12:54 AM
  2. Install SQL Patches = 403 Forbidden
    By robin_n1987 in forum General Questions
    Replies: 2
    Last Post: 5 Jun 2012, 05:26 AM
  3. 403 forbidden
    By sublime19 in forum General Questions
    Replies: 1
    Last Post: 17 Aug 2008, 09:43 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