Page 1 of 2 12 LastLast
Results 1 to 10 of 11
  1. #1
    Join Date
    Feb 2009
    Posts
    780
    Plugin Contributions
    0

    Default re-enabling all downloads

    Is there a "simple" way to re-enable all the downloads for a specific customer?

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,637
    Plugin Contributions
    78

    Default Re: re-enabling all downloads

    Quote Originally Posted by CaroleAs View Post
    Is there a "simple" way to re-enable all the downloads for a specific customer?
    Here's a SQL query that you can copy/paste into your admin's Tools :: Install SQL Patches that will do that. This will set the number of days-to-download as no maximum and the number of downloads to 100 for the specified customer.

    You just need to navigate to Customers :: Customers so that you know the to-be-enabled customer's id. Back up your database first!
    Code:
    UPDATE orders_products_download opd
        INNER JOIN orders o ON o.orders_id = opd.orders_id
        SET opd.download_maxdays = 0, opd.download_count = 100
        WHERE o.customers_id = xx;

  3. #3
    Join Date
    Feb 2009
    Posts
    780
    Plugin Contributions
    0

    Default Re: re-enabling all downloads

    Probably a "silly" question, but is there a way to know which database is actually the one for my store? Over time, I have had MANY databases set up, including when I was upgrading my store a few years ago and I was testing. I probably need to clean things up but now, is there somewhere in the admin panel that can state what is its name?

  4. #4
    Join Date
    Apr 2006
    Location
    Ohio
    Posts
    6,147
    Plugin Contributions
    0

    Default Re: re-enabling all downloads

    Log into your cpanel
    find file manager, click includes/ configure.php
    here you’ll see the database your site is using

  5. #5
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,991
    Plugin Contributions
    109

    Default Re: re-enabling all downloads

    Quote Originally Posted by CaroleAs View Post
    Probably a "silly" question, but is there a way to know which database is actually the one for my store?
    Not a silly question at all. In 1.5.7, a small feature was added to the Version tab to show your database.

    https://docs.zen-cart.com/user/admin...s/server_info/

    The database is (d) in the first diagram.

    You can always pull the file includes/configure.php or admin/includes/configure.php and look at the value DB_DATABASE as well, as Haredo noted.
    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.

  6. #6
    Join Date
    Feb 2009
    Posts
    780
    Plugin Contributions
    0

    Default Re: re-enabling all downloads

    I did a backup, and now, applying that code, it is not working. Here is what I get:
    https://www.loom.com/share/8a88b16f5...de5d7e2528e9ed

    Am I doing it wrong?

  7. #7
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,991
    Plugin Contributions
    109

    Default Re: re-enabling all downloads

    You might need to do this in phpMyAdmin instead of Zen Admin, remembering to add the table prefixes.
    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.

  8. #8
    Join Date
    Feb 2009
    Posts
    780
    Plugin Contributions
    0

    Default Re: re-enabling all downloads

    Quote Originally Posted by swguy View Post
    You might need to do this in phpMyAdmin instead of Zen Admin, remembering to add the table prefixes.
    Yikes! I would need a little more information to do that (sorry).
    This is a foreign language to me.

  9. #9
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    8,079
    Plugin Contributions
    9

    Default Re: re-enabling all downloads

    Quote Originally Posted by swguy View Post
    Not a silly question at all. In 1.5.7, a small feature was added to the Version tab to show your database.

    https://docs.zen-cart.com/user/admin...s/server_info/

    The database is (d) in the first diagram.

    You can always pull the file includes/configure.php or admin/includes/configure.php and look at the value DB_DATABASE as well, as Haredo noted.
    Apparently, it was also back-ported to 1.5.6c
    Did you read the posting tips?!?
    myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
    Free Domain, SSL, and Magic Thumb with Semi-Annual or longer plan.

  10. #10
    Join Date
    Feb 2009
    Posts
    780
    Plugin Contributions
    0

    Default Re: re-enabling all downloads

    Quote Originally Posted by dbltoe View Post
    Apparently, it was also back-ported to 1.5.6c
    I have not yet upgraded. I still have 1.5.5.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v156 v156c cannot reenable all product when enabling category
    By mc12345678 in forum Bug Reports
    Replies: 0
    Last Post: 23 Jul 2019, 03:49 PM
  2. v151 Downloads Stopped Working - Now Redlights on all downloads
    By AllSavvy in forum General Questions
    Replies: 3
    Last Post: 10 May 2013, 04:44 PM
  3. v138a Enabling Free Shipping for all except weight >= 35lbs
    By icecold in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 11 Mar 2012, 05:24 PM
  4. Disabling New Products & Enabling All Products in Category List
    By JRayfield in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 31 Jan 2010, 04:49 PM
  5. not all downloads showing
    By Laney in forum Managing Customers and Orders
    Replies: 3
    Last Post: 12 Dec 2006, 10:47 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