Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2020
    Plugin Contributions

    Default [Not a core bug] Length mismatch between order_products and products_description


    I have discovered that the products_name column in the orders_products table is 64 characters, while the products_name column in products_description is 128 characters.
    This becomes a problem if a customer orders a product where the name is between 64 and 128 characters. When he/she clicks to confirm the order, ZC crashes and just some of the order lines get added.

    Best regards

  2. #2
    Join Date
    Jul 2012
    Plugin Contributions

    Default Re: Length mismatch between order_products and products_description

    This is a typical issue when someone chooses to try to increase the length of this field and others that are tracked through the order process and other related processes.

    (eg: in Zen Cart v1.5.6 both tables are set to 64 characters by default)

    It should be possible to resolve the issue through the following SQL statement that can be applied through tools->Install SQL Patches

    ALTER orders_products MODIFY products_name VARCHAR(128);
    It is recommended to make a backup of the database before executing commands that modify the database structure.
    Last edited by DrByte; 6 Feb 2020 at 02:11 PM. Reason: added default details for v1.5.6
    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



Similar Threads

  1. v154 [Not a bug] /** CDN for jQuery core **/
    By rbarbour in forum Bug Reports
    Replies: 10
    Last Post: 4 Mar 2015, 03:24 AM
  2. [Not a ZC core bug] Swedish Weekday in product_info
    By FrilansReklam in forum Bug Reports
    Replies: 2
    Last Post: 27 Feb 2013, 07:39 PM
  3. Replies: 1
    Last Post: 8 May 2010, 07:32 PM
  4. Replies: 2
    Last Post: 19 Nov 2009, 07:48 AM
  5. Replies: 1
    Last Post: 1 Sep 2009, 06:30 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
Zen-Cart, Internet Selling Services, Klamath Falls, OR