Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Location
    Louisiana
    Posts
    144
    Plugin Contributions
    0

    Default Table 'orders' value 'orders_status' getting set to zero '0'

    Background: The store worked fine until recently it was moved to a larger hard drive at a new IP. The hosting company initially had trouble with the SSL certificate but said they had this corrected and the URL now indicates https://. The store works as intended now but;

    Within Store Owner Admin;
    Select any 'New Orders' or 'Customers' then 'Orders' to update the order status.

    Update Order Status from '1' pending to '4' Shipped. (actually any update of any status)

    Administrator receives the information window stating:
    ~~~~~
    Although this page is encrypted, the information you have entered is to be sent over an unencrypted connection and could easily be read by a third party.

    Are you sure you want to continue sending this information?
    [Continue] [Cancel]

    ~~~~~

    If the Owner Admin presses [Continue] the SQL value 'orders_status' within table 'orders' is set to '0' (zero)

    To correct this error: Goto phpMyAdmin and change the 'orders_status' within table 'orders' to an acceptable number (1 to 4) everything is good.

    If any Order Status is changed within the Store Admin it results in the SQL table 'Orders' field 'orders_status' being set to zero '0'.

    That is, Order Status can not be updated.

    What causes this and how can it be corrected?

  2. #2
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: Table 'orders' value 'orders_status' getting set to zero '0'

    Quote Originally Posted by Forum5 View Post
    The hosting company initially had trouble with the SSL certificate but said they had this corrected and the URL now indicates https://.

    Administrator receives the information window stating:
    ~~~~~
    Although this page is encrypted, the information you have entered is to be sent over an unencrypted connection and could easily be read by a third party.

    Are you sure you want to continue sending this information?
    [Continue] [Cancel]

    ~~~~~
    Really ought to fix the remaining SSL problem first. Your admin configure.php file contents are wrong.


    And the other problem sounds like damaged PHP files or corrupted database transfer. Start by checking every PHP file to be sure each is fully intact and matches original code. http://www.zen-cart.com/wiki/index.p...Obscure_Issues
    .

    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.

 

 

Similar Threads

  1. Order status being set as zero, so orders not showing in list.
    By refreshmentshop in forum General Questions
    Replies: 2
    Last Post: 18 Oct 2010, 03:57 PM
  2. Currency displays zero value
    By kazie in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 0
    Last Post: 18 Nov 2009, 01:16 AM
  3. Orders not showing up - orders_status emptied
    By jaydee98273 in forum Managing Customers and Orders
    Replies: 2
    Last Post: 22 Jul 2008, 11:00 PM
  4. Replies: 2
    Last Post: 8 May 2008, 02:45 PM

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