Results 1 to 9 of 9
  1. #1
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Upgraded and all new order numbers are 0

    Just noticed this, all new orders after upgrade are 0, reset via admin but still return 0

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,474
    Plugin Contributions
    88

    Default Re: Upgraded and all new order numbers are 0

    Upgraded from what Zen Cart version to what-other Zen Cart version?

  3. #3
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Re: Upgraded and all new order numbers are 0

    Quote Originally Posted by lat9 View Post
    Upgraded from what Zen Cart version to what-other Zen Cart version?
    1.5.5a to 1.5.5f

  4. #4
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Re: Upgraded and all new order numbers are 0

    no modules installed yet

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,474
    Plugin Contributions
    88

    Default Re: Upgraded and all new order numbers are 0

    Quote Originally Posted by rbarbour View Post
    1.5.5a to 1.5.5f
    What process did you use for the upgrade? I ask because there were no database changes going from 1.5.5a to 1.5.5f, so a "simple" file-system update is all that is/was needed.

  6. #6
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Re: Upgraded and all new order numbers are 0

    Quote Originally Posted by lat9 View Post
    What process did you use for the upgrade? I ask because there were no database changes going from 1.5.5a to 1.5.5f, so a "simple" file-system update is all that is/was needed.
    Originally all I did was update the files cause as stated no DB changes were made.

    I have since, did a new install, imported existing db fields, customers, orders, ect. and still, new orders are getting assigned order id 0

  7. #7
    Join Date
    Feb 2010
    Location
    Syracuse, NY
    Posts
    2,159
    Plugin Contributions
    17

    Default Re: Upgraded and all new order numbers are 0

    Ok, so this is weird,

    Table: orders_products

    Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

  8. #8
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,474
    Plugin Contributions
    88

    Default Re: Upgraded and all new order numbers are 0

    I agree on the weirdness. Would you post a screenshot of the structure of your orders_products table, as displayed by phpMyAdmin?

  9. #9
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Upgraded and all new order numbers are 0

    Quote Originally Posted by rbarbour View Post
    Table: orders_products

    Current selection does not contain a unique column.
    While that's weird, the probable cause of the "0" in all orders is that your orders table structure has become damaged, particularly in that the orders_id field is no longer an auto_increment field.
    A fresh install sets auto_increment on certain fields in certain tables. The orders table is one of those.

    This isn't something caused by core code. Nor the "upgrade", insofar as core code is concerned.
    .

    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. v155 Shipping, Postage, Order Total Modules are all blank and can't install new ones
    By johnali3n in forum Built-in Shipping and Payment Modules
    Replies: 11
    Last Post: 23 Mar 2019, 04:14 PM
  2. v151 Upgraded and product pages are now blank
    By shelshell in forum Upgrading to 1.5.x
    Replies: 4
    Last Post: 19 May 2013, 12:40 AM
  3. Replies: 9
    Last Post: 4 Nov 2010, 08:43 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