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

    Default Missing links in order

    Today, I had a large order come through and usually, a invoice will look like this:

    1 x Wrapped Frame - Round - PSP Script
    Download 1 zip file 1

    However, this order (which had 22 items) had them listed in this way:
    1 x Chipboard - PSP script
    1 x Clothes Labels - PSP Script
    1 x Cluster Template Maker - PSP Script

    I immediately noticed the difference as the "Download 1 zip file 1" was missing. Just a few minutes later, the customer emailed me saying she didn't get the download links, and even in her account in the store, the links are missing. The payment went through correctly and in full.

    Looking at the backend, I see the order but not the download links, so I cannot even reset them either. Any idea what might have happened, or how I can fix this (other than give her a coupon so she can buy again, hoping this time it works)?

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Missing links in order

    If you have an Order missing the download but the Product itself is on the Order ... you can fix this by going to phpMyAdmin and checking the tables to fix this ...

    First, check the table:
    orders_products_attributes

    Search for the orders_id in the table orders_products_attributes ... Is the Product in there with the Attribute for this download?

    If so, get the content of the field:
    products_prid

    Next, browse the table:
    orders_products_download

    for the orders_id and you should be missing the record containing that

    Do an INSERT and fill in the fields:
    orders_id
    orders_products_id
    orders_products_filename
    download_maxdays
    download_count
    products_prid

    Now the Download should be available on the Order for this customer ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

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

    Default Re: Missing links in order

    Is this in the zencart admin panel or on my zencart install? This is totally new to me.

  4. #4
    Join Date
    Feb 2009
    Posts
    861
    Plugin Contributions
    0

    Default Re: Missing links in order

    Ok i found that on the server.

    Search for the orders_id in the table orders_products_attributes ... Is the Product in there with the Attribute for this download?
    No, that order is missing. Is there a way to create one?

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Missing links in order

    In the table:
    orders_products

    Do you see the products_id in the table?

    And you say in the table:
    orders_products_attributes

    that you do not see the products_id in the field:
    orders_products_id

    and the matching
    products_prid

    for the orders_products tables products_prid correct?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

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

    Default Re: Missing links in order

    Maybe i was not clear. The order that came was number 5083. In the product_order_attributes, the last order is number 5082, so that is the order i do not see at all.

    I see all the fields of all the other orders, just that order is totally missing.

  7. #7
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Missing links in order

    Do you have that orders_id in the table:
    orders

    IF so, do you have the other Products in the table:
    orders_products

    IF so, do you have the other Products that have Attributes in the table:
    orders_products_attributes

    IF so, do you have for the Products with Downloads the downloads in the table:
    orders_products_downloads

    Have you an URL to this Product that has the missing download in the Order?

    In the Attributes Controller, on the Download for this Product, is there a green dot next to the filename?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

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

    Default Re: Missing links in order

    Do you have that orders_id in the table:
    orders
    Yes

    IF so, do you have the other Products in the table:
    orders_products
    Yes

    IF so, do you have the other Products that have Attributes in the table:
    orders_products_attributes
    No

    IF so, do you have for the Products with Downloads the downloads in the table:
    orders_products_downloads
    No

  9. #9
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Missing links in order

    Do you have the products_id for all the Products in that order and a URL to your site?

    This may or may not be able to be rebuilt ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today: v1.5.5]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

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

    Default Re: Missing links in order

    Do you have the products_id for all the Products in that order and a URL to your site?
    Yes, i have a products_id for all the Products in that order, all 22 of them.
    However, i am not sure where i should look for the URL as i dont see that as a field.
    One thing i notice that differs from the previous orders is that previous ones have products_prid like 234:f23d2c54e398b1daabb4f964f1f45b60 while ALL the products in this particular order only have the first 3 digits, like 150 or 294, and no loooooooooooong string.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. v151 New Order Email Admin Update order status missing?
    By wrickspam in forum Managing Customers and Orders
    Replies: 1
    Last Post: 7 May 2014, 09:46 PM
  2. missing a / in my links
    By ejvigil in forum Basic Configuration
    Replies: 2
    Last Post: 1 Oct 2011, 01:45 AM
  3. Missing Links
    By ZhENerationX in forum General Questions
    Replies: 2
    Last Post: 21 May 2010, 07:29 AM
  4. Header links missing
    By VH Freak in forum Templates, Stylesheets, Page Layout
    Replies: 5
    Last Post: 3 Jun 2009, 11:02 PM
  5. Missing links page
    By derekhorne in forum Basic Configuration
    Replies: 0
    Last Post: 16 Oct 2007, 07:42 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