Quote Originally Posted by mprough View Post
Didn't realize I missed the text =O

This error is logging for all products... I suspect it might be an issue from EP or DBIO

Code:
[30-Apr-2024 05:38:21 UTC] Request URI: /index.php?cPath=77_128&main_page=product_info&products_id=3168, IP address: 11.11.11.11
#1  trigger_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:667]
#2  queryFactory->show_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:634]
#3  queryFactory->set_error() called at [/home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php:275]
#4  queryFactory->Execute() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1529]
#5  zen_update_products_price_sorter() called at [/home/xxxxx/public_html/includes/functions/functions_prices.php:1558]
#6  zen_update_salemaker_product_prices() called at [/home/xxxxx/public_html/includes/functions/salemaker.php:49]
#7  zen_expire_salemaker() called at [/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php:65]
#8  require_once(/home/xxxxx/public_html/includes/init_includes/init_special_funcs.php) called at [/home/xxxxx/public_html/includes/autoload_func.php:40]
#9  require(/home/xxxxx/public_html/includes/autoload_func.php) called at [/home/xxxxx/public_html/includes/application_top.php:237]
#10 require(/home/xxxxx/public_html/includes/application_top.php) called at [/home/xxxxx/public_html/index.php:25]
--> PHP Fatal error: 1366:Incorrect decimal value: '' for column 'products_price_sorter' at row 1 :: UPDATE products
            SET products_price_sorter=''
            WHERE products_id=4870 ==> (as called by) /home/xxxxx/public_html/includes/functions/functions_prices.php on line 1529 <== in /home/xxxxx/public_html/includes/classes/db/mysql/query_factory.php on line 667.
The decimal value stored in the DB is correct.

Easy Populate 4.0.39.ZC - 03-17-2023
Database I/O (DbIo) Manager v2.0.0-beta3 (2023-01-02)

~Melanie
Might want to confirm the version of your includes/functions/functions_prices.php file against a new or original 1.5.8 version. Line numbers are not aligning at least with: https://github.com/zencart/zencart/b...ons_prices.php

Further I'm not yet seeing in that version of the file where an empty string would make its way back. I didn't do a comparison though between the v158 branch and the v1.5.8 breaks with also knowing that there was a sub version issued.

While I've found some other Zen Cart functions that don't handle a missing record sufficiently, this area may be one of them, but I don't really see how either tool could cause the described issue of the database field contains information on the correct format.