Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2005
    Location
    Orlando, Fl
    Posts
    299
    Plugin Contributions
    0

    Default EP4 - MySQLi error 1366: Incorrect decimal value: '' for column 'products_price'

    ZC 1.5.6c - PHP 7.2 - EP4 only plugin

    When uploading new products with EP4, I get this error:

    Code:
    MySQLi error 1366: Incorrect decimal value: '' for column 'products_price' at row 1
    When executing:
    INSERT INTO zen_products SET
    Has anyone run across this?

    ~D

  2. #2
    Join Date
    Jul 2012
    Posts
    15,007
    Plugin Contributions
    17

    Default Re: EP4 - MySQLi error 1366: Incorrect decimal value: '' for column 'products_price'

    Quote Originally Posted by djdavedawson View Post
    ZC 1.5.6c - PHP 7.2 - EP4 only plugin

    When uploading new products with EP4, I get this error:

    Code:
    MySQLi error 1366: Incorrect decimal value: '' for column 'products_price' at row 1
    When executing:
    INSERT INTO zen_products SET
    Has anyone run across this?

    ~D
    What version? Also, wouldn't this be best asked in the associated forum for EP4? https://www.zen-cart.com/showthread....d&goto=newpost

    A reason for the error is that the content of the read cell is interpreted as empty text rather than a zero. Either/both may be a problem.
    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. v156 MySQLi error 1366: Incorrect string value
    By chadlly2003 in forum General Questions
    Replies: 19
    Last Post: 3 Jan 2020, 05:57 AM
  2. Replies: 7
    Last Post: 22 Dec 2019, 07:07 PM
  3. Replies: 10
    Last Post: 29 Nov 2010, 06:31 AM
  4. Replies: 4
    Last Post: 14 Jan 2009, 11:45 AM
  5. VAT error message (1366 Incorrect decimal value)
    By Typhoon in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 5
    Last Post: 18 Jul 2006, 11:32 AM

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