Page 1 of 2 12 LastLast
Results 1 to 10 of 14
  1. #1
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    red flag Orders not displaying in admin

    I have just upgraded a site to V1.6a, my server is running 7.0 for this site

    I have a problem where customers make an order, they pay through paypal, the order reports back and the customers name and address are reported back to the admin but what is in their order is not and their order is received blank.

    See attached.

    Also the order emails aren't received.

    Name:  Screenshot 2019-04-26 at 13.19.57.jpg
Views: 100
Size:  32.9 KB

    Nothing in the error logs either
    Last edited by Nick1973; 26 Apr 2019 at 01:33 PM.

  2. #2
    Join Date
    Jul 2012
    Posts
    14,296
    Plugin Contributions
    17

    Default Re: Orders not displaying in admin

    Which PayPal method? There are three listings in a default install.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  3. #3
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    Default Re: Orders not displaying in admin

    Quote Originally Posted by mc12345678 View Post
    Which PayPal method? There are three listings in a default install.

    PayPal Website Payments Standard


  4. #4
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    Default Re: Orders not displaying in admin

    Sorry I should have put PHP 7.0 in my first post

  5. #5
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    Default Re: Orders not displaying in admin

    I just wondered if anybody could help me with this one please?

  6. #6
    Join Date
    Jan 2004
    Posts
    65,266
    Blog Entries
    7
    Plugin Contributions
    226

    Default Re: Orders not displaying in admin

    Nick, you said you're getting no error logs ... but I'm wondering if this same situation is what's happening for you:
    https://www.zen-cart.com/showthread....lue-for-column
    .

    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.

  7. #7
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    red flag Re: Orders not displaying in admin

    Quote Originally Posted by DrByte View Post
    Nick, you said you're getting no error logs ... but I'm wondering if this same situation is what's happening for you:
    https://www.zen-cart.com/showthread....lue-for-column
    I've just looked again in the error logs and I am getting this error now.


    /index.php?main_page=checkout_process&referer=paypal&amt=39.00&cc=GBP&cm=zenid%3D b3af2dd74e9be42503c969f953a9d012&item_name=All%20the%20items%20in%20your%20shopp ing%20basket%20(see%20details%20in%20the%20store%20and%20on%20your%20store%20rec eipt).&item_number=Rockspex%20Purchase&st=Completed&tx=63P85988UJ429092G, IP address: 00.000.00.000
    #1 trigger_error() called at [/home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php:171]
    #2 queryFactory->show_error() called at [/home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php:143]
    #3 queryFactory->set_error() called at [/home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php:270]
    #4 queryFactory->Execute() called at [/home/sportsq2/public_html/includes/functions/functions_general.php:952]
    #5 zen_db_perform() called at [/home/sportsq2/public_html/includes/classes/order.php:821]
    #6 order->create_add_products() called at [/home/sportsq2/public_html/includes/modules/checkout_process.php:93]
    #7 require(/home/sportsq2/public_html/includes/modules/checkout_process.php) called at [/home/sportsq2/public_html/includes/modules/pages/checkout_process/header_php.php:14]
    #8 require(/home/sportsq2/public_html/includes/modules/pages/checkout_process/header_php.php) called at [/home/sportsq2/public_html/index.php:36]
    [27-Apr-2019 14:26:27 UTC] PHP Fatal error: 1054:Unknown column 'products_weight' in 'field list' :: INSERT INTO orders_products (orders_id, products_id, products_model, products_name, products_price, final_price, onetime_charges, products_tax, products_quantity, products_priced_by_attribute, product_is_free, products_discount_type, products_discount_type_from, products_prid, products_weight, products_virtual, product_is_always_free_shipping, products_quantity_order_min, products_quantity_order_units, products_quantity_order_max, products_quantity_mixed, products_mixed_discount_quantity) VALUES ('2917', '744', 'Inland equinox', 'Equinox - Safety Glasses - Industrial Glasses', '39.0000', '39', '0', '0', '1', '0', '0', '0', '0', '744:ef51c6e1fb89cedb6c9add20435a9d52', '0.5', '0', '0', '1', '1', '0', '1', '1') ==> (as called by) /home/sportsq2/public_html/includes/functions/functions_general.php on line 952 <== in /home/sportsq2/public_html/includes/classes/db/mysql/query_factory.php on line 171

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    8,855
    Plugin Contributions
    69

    Default Re: Orders not displaying in admin

    Are you sure that you ran the zc_install to upgrade that database? Part of the zc156 database update is to add the orders_products::products_weight field ... the one that's missing.
    Last edited by lat9; 29 Apr 2019 at 05:03 PM. Reason: Disable smilies

  9. #9
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    Default Re: Orders not displaying in admin

    I thought I did. Let me try again.

  10. #10
    Join Date
    Sep 2008
    Location
    Cleethorpes
    Posts
    884
    Plugin Contributions
    5

    Default Re: Orders not displaying in admin

    Quote Originally Posted by Nick1973 View Post
    I thought I did. Let me try again.
    Actually I think I know what has happened here if that is the case. I had to transfer all the order tables from the old database into the new one. So they will now be old and probably won't have that field. So I am guessing a workaround would be to install a virgin Zen Cart 1.5.6a to get that field transferred across.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. Orders not displaying products ordered
    By cryogenicz in forum General Questions
    Replies: 1
    Last Post: 20 Dec 2010, 03:56 AM
  2. PayPal transaction details grey box not displaying on admin orders pages
    By Woodymon in forum PayPal Express Checkout support
    Replies: 5
    Last Post: 16 Oct 2007, 10:54 PM
  3. Cusomer Orders not displaying
    By Liza_with_a_Z in forum Managing Customers and Orders
    Replies: 7
    Last Post: 22 Jun 2007, 09:54 AM
  4. New Orders not displaying since upgrade
    By eschwenke in forum Upgrading from 1.3.x to 1.3.9
    Replies: 1
    Last Post: 21 Oct 2006, 04:42 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