Hello.
Zen Cart 1.5.5.e, DBIO 1.3.0
Ive got 2 issues :
1. When importing products, where i have got 2 duplicate products (same v_products_model id), i receive sql error
Code:
[02-Oct-2017 17:13:58 Europe/Warsaw] Request URI: /Benek/dbio_manager.php?action=file, IP address: 188.146.34.65
#1  trigger_error() called at [/includes/classes/db/mysql/query_factory.php:167]
#2  queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:139]
#3  queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:266]
#4  queryFactory->Execute() called at [/Benek/includes/classes/dbio/DbIoProductsHandler.php:571]
#5  DbIoProductsHandler->importUpdateRecordKey() called at [/Benek/includes/classes/dbio/DbIoHandler.php:905]
#6  DbIoHandler->importCsvRecord() called at [/Benek/includes/classes/dbio/DbIo.php:250]
#7  DbIo->dbioImport() called at [/Benek/dbio_manager.php:223]

[02-Oct-2017 17:13:58 Europe/Warsaw] PHP Fatal error:  1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' 5)' at line 4 :: INSERT IGNORE INTO zen_products_to_categories 
                        (products_id, categories_id) 
                     VALUES 
                        ( , 5) ==> (as called by) /Benek/includes/classes/dbio/DbIoProductsHandler.php on line 571 <== in /includes/classes/db/mysql/query_factory.php on line 167
it seems that $products_id variable is not set.
I made a simple workaround to avoid this error (but i think you have to solve this better ) in dbioProductsHandelr.php line about 564
Code:
        if ($table_name == TABLE_PRODUCTS_TO_CATEGORIES) {
            if ($this->operation != 'check') {
if ( $products_id != '')
                $db->Execute(
                    "INSERT IGNORE into $table_name 
                        (products_id, categories_id) 
                     VALUES
Second issue :
I put wrong master category path (ia cat_main^subcat1^subcat2) in my import file, after importing all the rows i changed master category path to be correct. But after "update" import the category didnt changed (no change in products_master_categories_id and no change in products_to_categories table)
Is there any way (becaouse there is no Category handler) to update this field and the products_to_categoies table ?
Regards
Marek.