Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2007
    Posts
    132
    Plugin Contributions
    0

    Default Order missing in admin but exists in SQL

    I added a note to an order by editing the order and changing "status - update" with a note. An error page displayed about not being able to complete something. (Sorry, I just hit reload so no details of message.)

    The order no longer displays in admin, but all details appear to be present in MySQL.

    I assume something needs to be reindexed?

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Order missing in admin but exists in SQL

    Chances are you assigned it a non-existent order-status value.

    Compare that order's order_status value against the available statuses in your orders_status table. You'll find that if it's not matching a value in the orders_status table then it won't properly show in your admin.

    Simple fix: Use the admin order screen to search for that order number. Then update its status using the normal status-update options, choosing a valid status from the pulldown menu. That will set it to a valid value.

    Or, edit the order_status value directly in the orders table in the database.
    .

    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
    Oct 2007
    Posts
    132
    Plugin Contributions
    0

    Default Re: Order missing in admin but exists in SQL

    Thanks for the quick reply.
    Unable to find in order admin, but in the database found order status of "0". Changed that to 1 and all is good.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Order missing in admin but exists in SQL

    Quote Originally Posted by Jeff G View Post
    v1.3.9f
    You really should be planning an upgrade to a modern version. Hosting companies are starting to push upgrades to modern PHP versions, and you'll need to be using a modern version of Zen Cart if you want to avoid downtime.

    Quote Originally Posted by Jeff G View Post
    An error page displayed about not being able to complete something. (Sorry, I just hit reload so no details of message.)
    The error might be recorded in logs. In your old version those could be in the /cache/ folder, as per http://www.zen-cart.com/content.php?124
    And you'll want to fix whatever error caused this "0" problem in the first place.
    .

    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
    Oct 2007
    Posts
    132
    Plugin Contributions
    0

    Default Re: Order missing in admin but exists in SQL

    Already working on version upgrade. Just finding the time!

    Thanks again.
    Jeff

 

 

Similar Threads

  1. Replies: 2
    Last Post: 27 Sep 2013, 02:59 AM
  2. Replies: 1
    Last Post: 20 Dec 2011, 09:26 AM
  3. define_main_page.php exists but not showing
    By byoriginaldesign in forum Templates, Stylesheets, Page Layout
    Replies: 2
    Last Post: 28 May 2009, 10:05 PM
  4. Did not recieve Order Confirmation email and no order exists in admin
    By gws76 in forum Managing Customers and Orders
    Replies: 4
    Last Post: 19 May 2008, 12:44 AM
  5. Order missing but Payment processed
    By restless in forum Managing Customers and Orders
    Replies: 15
    Last Post: 21 Jun 2006, 12:40 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