Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default My 10-digit Sort Order Numbers Not Updating for 1 Catagory

    I have multiple catagories and multiple sub-catagories in each. I have established a 10 digit sort order number for each of my products as there will be 10s if not 100s of thousands.

    The 13th catagory's sub catagories will not update with the number I input. When I enter any 10 digit number and update it,what is stored is 2147483647. That is not a Sort Order number I have or will have. If I use a 9 digit number, it saves, but all my other catagories so far accept a 10 digit sort order number.

    What is wrong with this one?? This may also occur in other catagories, but I havent entered any more products in other catagories yet.

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

    Default Re: My 10-digit Sort Order Numbers Not Updating for 1 Catagory

    2147483647 is the highest number allowed.

    This is because the database is storing that data in an INT field, and MySQL imposes that specific limitation.

    Simplest solution: use numbers smaller than 2,147,483,647
    .

    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
    Jun 2012
    Location
    Oklahoma
    Posts
    39
    Plugin Contributions
    0

    Default Re: My 10-digit Sort Order Numbers Not Updating for 1 Catagory

    It would be very difficult to reduce the number below 2147483647. The products are coins and the sort order numbers are very specific to catalog by denomination, year, variety, mint mark, and grade. What is a less simply way? Is there a way to make my numbers work? The highest numbers will begin with 36

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

    Default Re: My 10-digit Sort Order Numbers Not Updating for 1 Catagory

    I suppose you could use phpMyAdmin to edit the products table and change the sort_order field in JUST THAT TABLE to be bigint instead of int.
    .

    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. Sort Order not functioning for "Featured Products" on main page of ver 1.5.0
    By sjdeines in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 8 Jan 2014, 06:51 PM
  2. Paypal E-Check not updating order automatically for me
    By NWCE in forum Built-in Shipping and Payment Modules
    Replies: 7
    Last Post: 8 Oct 2010, 03:41 PM
  3. State is Showing as 3 Digit Numbers after upgrading template
    By lanpartyjoe in forum General Questions
    Replies: 9
    Last Post: 27 Jul 2010, 08:00 PM
  4. Column sort order numbers - what do they mean ?
    By Graham35 in forum General Questions
    Replies: 3
    Last Post: 19 Apr 2009, 02:30 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