EasyPopulate 4.0 Support Thread

[gemohler]

General EP question.

While doing a large import, apache is taking a lot of resources...

What is the WWW server doing during an import that makes IT so busy?

Still I cant find ANY reason why apache gets so wrapped up in the import process.

The file is on disk
Nothing is in the access or error logs..so..clicking "import" does nothing to apache.

I dont have the skillset to PROVE it, but I would guess that this is an IO constraint to getting database work done...but I dont know how.

All I know is when I do an import/export, any high DB activity (I deleted a large dummy category to test this) apache2 jumps in to suck up a lot of CPU...while doing nothing observable.

[gemohler]

Still I cant find ANY reason why apache gets so wrapped up in the import process.

The file is on disk
Nothing is in the access or error logs..so..clicking "import" does nothing to apache.

I dont have the skillset to PROVE it, but I would guess that this is an IO constraint to getting database work done...but I dont know how.

All I know is when I do an import/export, any high DB activity (I deleted a large dummy category to test this) apache2 jumps in to suck up a lot of CPU...while doing nothing observable.

Let me ask this..

Are you sending apache a running list of things imported? Im now at a point where apache is outrunning the DB un CPU use.

How about also an option to output import per-product status to a log file, as..well, it's sorta useless if you have a large # of items.

[project jayden]

Zencart 1.5.8a
MySQL updated from 5.7 to 8.0.34

This is 100% my mistake. I am an noob and got a notification that 5.7 was no longer going to be supported after this month so I decided to upgrade MySQL. Ran into a couple of issues. First my home page no longer works. (all of the other links work though and check out seems to be fine) I am currently working with the developer of the template to help fix it (PHP Fatal error: 1525:Incorrect DATETIME value: '' ::) I tried turning off strict mode and allowing invalid dates but nothing.

But now with EasyPopulate it seems I am having issues now as well.

I uploaded 5 new products and for some reason one product keeps getting thrown into a totally different category.

I ended up using a brand new spreadsheet with just the 5 products inside and still getting the issue. I checked the logs and it doesn't make sense because it is giving me errors for products that aren't even in the new spreadsheet and as far as I can tell the products it is listing do not have the issues stated. Been kicking myself for why I decided to update in first place. Really appreciate your guys' help.

Only including some of the log as it was way too long

MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         765,
                         'Torque Solution Genesis Coupe 2.0T Tial Blow Off Valve Adapter 2010 – 2014', 'Torque Solution Tial Blow off Valve Adapter\n\nApplication: Hyundai Genesis Coupe 2.0T 2010+\n\n\nReplace your oem diverter valve using Torque Solution\'s Billet Tial Blow off Valve Adapter. This allows you to direct fit your Tial Q or QR blow off valve to your Hyundai Genesis Coupe 2.0T without any welding or modifications at all. \n\n- CNC machined 6061-T6 billet aluminum\n- Installs in under 30 minutes\n- Direct Fitment\n- Includes mounting bolts & o-rings\n- Limited Lifetime Warranty', 'TorqueSolutionTialBlowoffValveAdapterApplication:HyundaiGenesisCoupe2.0T2010+TorqueSolutionBilletTialBlowoffValveAdapterallowsyoutodirectfityourTialQorQRblowoffvalvetoyourHyundaiGenesisCoupe2.0Twithoutanyweldingormodificationsatall.-CNCmachined6061-T6billetaluminum-Installsinunder30minutes-DirectFitment-Includesmountingbolts&o-rings-LifetimeWarranty', 
                         1)

MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         766,
                         'Torque Solution Genesis Coupe 2.0T Greddy BOVAdapter 2010 – 2014', 'Torque Solution Greddy Blow off Valve Adapter\n\nApplication: Hyundai Genesis Coupe 2.0T 2010+\n\n\nReplace your oem diverter valve using Torque Solution\'s Billet Greddy Blow off Valve Adapter. This allows you to direct fit your Greddy blow off valve to your Hyundai Genesis Coupe 2.0T without any welding or modifications at all. \n\n- CNC machined 6061-T6 billet aluminum\n- Installs in under 30 minutes\n- Direct Fitment\n- Includes mounting bolts & o-rings\n- Limited Lifetime Warranty', 'TorqueSolutionGreddyBlowoffValveAdapterApplication:HyundaiGenesisCoupe2.0T2010+TorqueSolutionBilletGreddyBlowoffValveAdapterallowsyoutodirectfityourblowoffvalvetoyourHyundaiGenesisCoupeTurbowithoutanyweldingormodificationsatall.-Cncmachined6061-T6billetaluminum-Installsinunder30minutes-DirectFitment-LifetimeWarranty', 
                         1)
MySQLi error 1366: Incorrect decimal value: '' for column 'products_price' at row 1
When executing:
INSERT INTO products SET
              products_model          = '10HYGEN2DOE-030C',
              products_type                 = 1,
              products_price          = '', products_image     = 'Genesis Coupe/10HYGEN2DOE-030C.jpg',
              products_weight         = 125,
              products_discount_type          = 0,
              products_discount_type_from     = 0,
              product_is_call                 = 0,
              products_sort_order             = 0,
              products_quantity_order_min     = 1,
              products_quantity_order_units   = 1,
              products_priced_by_attribute  = 0,
              product_is_always_free_shipping = 0,
              products_tax_class_id     = 1,
              products_date_available     = NULL,
              products_date_added       = '2023-09-04 00:00:00',
              products_last_modified      = CURRENT_TIMESTAMP,
              products_quantity       = 10,
              master_categories_id      = 280,
              manufacturers_id        = 57,
              products_status         = 1,
              metatags_title_status     = 0,
              metatags_products_name_status = 0,
              metatags_model_status     = 0,
              metatags_price_status     = 0,
              metatags_title_tagline_status = 0

MySQLi error 1366: Incorrect string value: '\xEF\xBE's s...' for column 'products_description' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1191,
                         'Riaction Genesis Coupe GP-1 TRUE REAR Digressive Coilover Set 2010 - 2016', 'The GP-1 Digressive Coilover is different than the linear valved system in terms of damper valving. This means the damper has much more low speed control in comparison to a Linear valve. This is due to the low flow rate at low shaft speeds. The resistance rate increases as shaft speeds increase, but only to a pre-determined level, whereas the Linear variant continues to increase. The digressive valving then has resistance that tapers off and as the shaft speed continues to increase, the resistance remains constant. This eliminates unnecessary resistance and provides more control as the vehicle encounters irregularities in the roadï¾\'s surface. This setup will do a better job of managing unwanted body motions while also still providing a comfortable ride.\n\nThe digressive coilover system is great for street use, canyon carving, and track days.\n\n\nRiaction sports coilover kits are designed for street cars which are looking for lower ride height, better handling, and greater comfort. Each set of Riaction USA coilovers are made from high quality materials with precision design, to ensure a reliable and durable product that performs. We proudly stand by all of our products, and each Riaction USA sports coilover kit comes with a standard 2 year factory warranty against any factory defects.\n\nCOILOVER FEATURES\n\n-Full Length Ride Height Adjustment\n-32 Damping Adjustment Levels\n-Mono-Tube Damper Design\n-Seamless 52mm Electroplated Carbon Steel Shock Body\n-O.D. 20mm Piston Rod For McPherson Suspension\n-O.D. 14mm Piston Rod For Non-McPherson Suspension\n-Unique 44mm High-Flow CNC 6061 Aluminum Piston\n-Unique Thinned CNC 6061 Aluminum Floating Piston\n-Polyurethane Oil Seal\n-SAE9254 Cold-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able\n\nFACTORY SPRING RATES: 8K (Front) - 6K (Rear)', '', 
                         1)
MySQLi error 1366: Incorrect string value: '\xEF\xBE's s...' for column 'products_description' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1192,
                         'Riaction Genesis Coupe GP-1 DIGRESSIVE Coilover Set 2010 - 2016', 'The GP-1 Digressive Coilover is different than the linear valved system in terms of damper valving. This means the damper has much more low speed control in comparison to a Linear valve. This is due to the low flow rate at low shaft speeds. The resistance rate increases as shaft speeds increase, but only to a pre-determined level, whereas the Linear variant continues to increase. The digressive valving then has resistance that tapers off and as the shaft speed continues to increase, the resistance remains constant. This eliminates unnecessary resistance and provides more control as the vehicle encounters irregularities in the roadï¾\'s surface. This setup will do a better job of managing unwanted body motions while also still providing a comfortable ride.\n\nThe digressive coilover system is great for street use, canyon carving, and track days.\n\n\nRiaction sports coilover kits are designed for street cars which are looking for lower ride height, better handling, and greater comfort. Each set of Riaction USA coilovers are made from high quality materials with precision design, to ensure a reliable and durable product that performs. We proudly stand by all of our products, and each Riaction USA sports coilover kit comes with a standard 2 year factory warranty against any factory defects.\n\n\nCOILOVER FEATURES\n\n-Full Length Ride Height Adjustment\n-32 Damping Adjustment Levels\n-Mono-Tube Damper Design\n-Seamless 52mm Electroplated Carbon Steel Shock Body\n-O.D. 20mm Piston Rod For McPherson Suspension\n-O.D. 14mm Piston Rod For Non-McPherson Suspension\n-Unique 44mm High-Flow CNC 6061 Aluminum Piston\n-Unique Thinned CNC 6061 Aluminum Floating Piston\n-Polyurethane Oil Seal\n-SAE9254 Cold-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able', '', 
                         1)
MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1385,
                         'IRP GENESIS COUPE RACING SHIFTER FOR MANUAL TRANSMISSION 2010 – 2016', '', '<p>IRPRacingShifter(IndividualRacingProducts)isfinallyhereintheUSA!TheseshiftersarethetoplineracingqualityfortheGenesisCoupeManualtransmissions2010-2016.Thisdesignisadirectdrivesystemthatremovesallyourfactorylinkageandbushings.Bydoingthisdesign,yougetasharp,crispshiftingfeelthatallowsextremelyfastshiftingonthetrack.Wepersonallytestedtheseonourracecarsaregaveitfivestarsforperformance!Wellworthit&#39;svalue.Thesidesetscrewsallowsforadjustmentonleftandrightthrow.Evenbetter,theunithasabuiltinreverselockoutbuttonthatallowsreverseonlytobeusedwhenthedriverpushesthebuttonontopoftheshifter.Thismakesforlessmistakeswhenquicklygoingintofirstgear.&nbsp;</p><p>&nbsp;</p><p>CNCAluminumlightweightdesign<br/>ReverseLockOutButton<br/>Adjustableleftandrightmaxthrow<br/>Bearingdesignforzeroplay<br/>Precisegearengagement<br/>Allowsdrivertoshiftmuchfaster<br/>Crispracefeelshifting<br/>DesignedforRacingPurposes&nbsp;</p><p>&nbsp;</p><p><iframeallowfullscreen=\"\"frameborder=\"0\"height=\"360\"src=\"//www.youtube.com/embed/8fEMSLk2bQ4\"width=\"640\"></iframe></p>', 
                         1)
MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1520,
                         'Prosport Premium Evo Digital Boost Gauge', '', '<p>Ifyourvehicleissuperchargedorturbochargedthenthisgaugeissimplyamusthave.ForpeakperformanceyouneedtoknowhowmuchboostyouaremakingatmaximumRPM&#39;s.Nowyoucanaccuratelymonitoryourboostasyoumodifyyourride!</p><p>Saveyourturbo-Setthewarningfeaturetoalertyoubeforeyouoverboost.Fullyprogrammabletoanylevelyouwant.Makechangeswithinsecondsusingthebuttonsonthefrontofthegauge.</p><p>Features:</p><ol><li>PeakRecall</li><li>FullyprogrammableWarningfeature</li><li>Dimmable</li><li>Daisychain</li><li>Premiumwaterproofsender</li><li>Wireharness(gaugetosender-plugandplay)</li><li>4colorchoices</li><li>Mountingcup</li><li>Visor</li><li>Freetechsupport<br/>&nbsp;</li></ol><p>ThisElectricBoostGaugewillperformadigitalsweep/selfcheckonStart-up.</p><p>(-30vacto35PSI)</p><p>Includes:</p><ol><li>Mountinghardware</li><li>TubingKit</li><li>T-Adaptor</li><li>WaterproofElectricalsender</li><li>Wiringharness</li><li>Visor</li><li>Prosportdecal</li><li>Instructions</li></ol><p>&nbsp;</p><p><iframeallowfullscreen=\"\"frameborder=\"0\"height=\"360\"src=\"//www.youtube.com/embed/Lk5xXoOPmHg\"width=\"640\"></iframe></p>', 
                         1)

                         


MySQLi error 1062: Duplicate entry '512' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                512, '', 222, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '512-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 512,
                    language_id     = 1,
                    categories_name = 'Accessories',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '512' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                512, '', 222, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '512-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 512,
                    language_id     = 1,
                    categories_name = 'Accessories',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '512' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                512, '', 222, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '512-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 512,
                    language_id     = 1,
                    categories_name = 'Accessories',
                    categories_description = ''

[project jayden]

Not exactly sure what the creator of the template did but when he fixed the issue with the homepage for some reason it also fixed the easypopulate issue as far as I can tell

Zencart 1.5.8a
MySQL updated from 5.7 to 8.0.34

This is 100% my mistake. I am an noob and got a notification that 5.7 was no longer going to be supported after this month so I decided to upgrade MySQL. Ran into a couple of issues. First my home page no longer works. (all of the other links work though and check out seems to be fine) I am currently working with the developer of the template to help fix it (PHP Fatal error: 1525:Incorrect DATETIME value: '' ::) I tried turning off strict mode and allowing invalid dates but nothing.

But now with EasyPopulate it seems I am having issues now as well.

I uploaded 5 new products and for some reason one product keeps getting thrown into a totally different category.

I ended up using a brand new spreadsheet with just the 5 products inside and still getting the issue. I checked the logs and it doesn't make sense because it is giving me errors for products that aren't even in the new spreadsheet and as far as I can tell the products it is listing do not have the issues stated. Been kicking myself for why I decided to update in first place. Really appreciate your guys' help.

Only including some of the log as it was way too long

MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         765,
                         'Torque Solution Genesis Coupe 2.0T Tial Blow Off Valve Adapter 2010 – 2014', 'Torque Solution Tial Blow off Valve Adapter\n\nApplication: Hyundai Genesis Coupe 2.0T 2010+\n\n\nReplace your oem diverter valve using Torque Solution\'s Billet Tial Blow off Valve Adapter. This allows you to direct fit your Tial Q or QR blow off valve to your Hyundai Genesis Coupe 2.0T without any welding or modifications at all. \n\n- CNC machined 6061-T6 billet aluminum\n- Installs in under 30 minutes\n- Direct Fitment\n- Includes mounting bolts & o-rings\n- Limited Lifetime Warranty', 'TorqueSolutionTialBlowoffValveAdapterApplication:HyundaiGenesisCoupe2.0T2010+TorqueSolutionBilletTialBlowoffValveAdapterallowsyoutodirectfityourTialQorQRblowoffvalvetoyourHyundaiGenesisCoupe2.0Twithoutanyweldingormodificationsatall.-CNCmachined6061-T6billetaluminum-Installsinunder30minutes-DirectFitment-Includesmountingbolts&o-rings-LifetimeWarranty', 
                         1)

MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         766,
                         'Torque Solution Genesis Coupe 2.0T Greddy BOVAdapter 2010 – 2014', 'Torque Solution Greddy Blow off Valve Adapter\n\nApplication: Hyundai Genesis Coupe 2.0T 2010+\n\n\nReplace your oem diverter valve using Torque Solution\'s Billet Greddy Blow off Valve Adapter. This allows you to direct fit your Greddy blow off valve to your Hyundai Genesis Coupe 2.0T without any welding or modifications at all. \n\n- CNC machined 6061-T6 billet aluminum\n- Installs in under 30 minutes\n- Direct Fitment\n- Includes mounting bolts & o-rings\n- Limited Lifetime Warranty', 'TorqueSolutionGreddyBlowoffValveAdapterApplication:HyundaiGenesisCoupe2.0T2010+TorqueSolutionBilletGreddyBlowoffValveAdapterallowsyoutodirectfityourblowoffvalvetoyourHyundaiGenesisCoupeTurbowithoutanyweldingormodificationsatall.-Cncmachined6061-T6billetaluminum-Installsinunder30minutes-DirectFitment-LifetimeWarranty', 
                         1)
MySQLi error 1366: Incorrect decimal value: '' for column 'products_price' at row 1
When executing:
INSERT INTO products SET
              products_model          = '10HYGEN2DOE-030C',
              products_type                 = 1,
              products_price          = '', products_image     = 'Genesis Coupe/10HYGEN2DOE-030C.jpg',
              products_weight         = 125,
              products_discount_type          = 0,
              products_discount_type_from     = 0,
              product_is_call                 = 0,
              products_sort_order             = 0,
              products_quantity_order_min     = 1,
              products_quantity_order_units   = 1,
              products_priced_by_attribute  = 0,
              product_is_always_free_shipping = 0,
              products_tax_class_id     = 1,
              products_date_available     = NULL,
              products_date_added       = '2023-09-04 00:00:00',
              products_last_modified      = CURRENT_TIMESTAMP,
              products_quantity       = 10,
              master_categories_id      = 280,
              manufacturers_id        = 57,
              products_status         = 1,
              metatags_title_status     = 0,
              metatags_products_name_status = 0,
              metatags_model_status     = 0,
              metatags_price_status     = 0,
              metatags_title_tagline_status = 0

MySQLi error 1366: Incorrect string value: '\xEF\xBE's s...' for column 'products_description' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1191,
                         'Riaction Genesis Coupe GP-1 TRUE REAR Digressive Coilover Set 2010 - 2016', 'The GP-1 Digressive Coilover is different than the linear valved system in terms of damper valving. This means the damper has much more low speed control in comparison to a Linear valve. This is due to the low flow rate at low shaft speeds. The resistance rate increases as shaft speeds increase, but only to a pre-determined level, whereas the Linear variant continues to increase. The digressive valving then has resistance that tapers off and as the shaft speed continues to increase, the resistance remains constant. This eliminates unnecessary resistance and provides more control as the vehicle encounters irregularities in the roadï¾\'s surface. This setup will do a better job of managing unwanted body motions while also still providing a comfortable ride.\n\nThe digressive coilover system is great for street use, canyon carving, and track days.\n\n\nRiaction sports coilover kits are designed for street cars which are looking for lower ride height, better handling, and greater comfort. Each set of Riaction USA coilovers are made from high quality materials with precision design, to ensure a reliable and durable product that performs. We proudly stand by all of our products, and each Riaction USA sports coilover kit comes with a standard 2 year factory warranty against any factory defects.\n\nCOILOVER FEATURES\n\n-Full Length Ride Height Adjustment\n-32 Damping Adjustment Levels\n-Mono-Tube Damper Design\n-Seamless 52mm Electroplated Carbon Steel Shock Body\n-O.D. 20mm Piston Rod For McPherson Suspension\n-O.D. 14mm Piston Rod For Non-McPherson Suspension\n-Unique 44mm High-Flow CNC 6061 Aluminum Piston\n-Unique Thinned CNC 6061 Aluminum Floating Piston\n-Polyurethane Oil Seal\n-SAE9254 Cold-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able\n\nFACTORY SPRING RATES: 8K (Front) - 6K (Rear)', '', 
                         1)
MySQLi error 1366: Incorrect string value: '\xEF\xBE's s...' for column 'products_description' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1192,
                         'Riaction Genesis Coupe GP-1 DIGRESSIVE Coilover Set 2010 - 2016', 'The GP-1 Digressive Coilover is different than the linear valved system in terms of damper valving. This means the damper has much more low speed control in comparison to a Linear valve. This is due to the low flow rate at low shaft speeds. The resistance rate increases as shaft speeds increase, but only to a pre-determined level, whereas the Linear variant continues to increase. The digressive valving then has resistance that tapers off and as the shaft speed continues to increase, the resistance remains constant. This eliminates unnecessary resistance and provides more control as the vehicle encounters irregularities in the roadï¾\'s surface. This setup will do a better job of managing unwanted body motions while also still providing a comfortable ride.\n\nThe digressive coilover system is great for street use, canyon carving, and track days.\n\n\nRiaction sports coilover kits are designed for street cars which are looking for lower ride height, better handling, and greater comfort. Each set of Riaction USA coilovers are made from high quality materials with precision design, to ensure a reliable and durable product that performs. We proudly stand by all of our products, and each Riaction USA sports coilover kit comes with a standard 2 year factory warranty against any factory defects.\n\n\nCOILOVER FEATURES\n\n-Full Length Ride Height Adjustment\n-32 Damping Adjustment Levels\n-Mono-Tube Damper Design\n-Seamless 52mm Electroplated Carbon Steel Shock Body\n-O.D. 20mm Piston Rod For McPherson Suspension\n-O.D. 14mm Piston Rod For Non-McPherson Suspension\n-Unique 44mm High-Flow CNC 6061 Aluminum Piston\n-Unique Thinned CNC 6061 Aluminum Floating Piston\n-Polyurethane Oil Seal\n-SAE9254 Cold-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able-Wound Spring\n-Multi-Thickness Valving Shims\n-Unique Low-Gas Pressure Design\n-7.5w Compounded Suspension Fluid\n-Fully Rebuild-able', '', 
                         1)
MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1385,
                         'IRP GENESIS COUPE RACING SHIFTER FOR MANUAL TRANSMISSION 2010 – 2016', '', '<p>IRPRacingShifter(IndividualRacingProducts)isfinallyhereintheUSA!TheseshiftersarethetoplineracingqualityfortheGenesisCoupeManualtransmissions2010-2016.Thisdesignisadirectdrivesystemthatremovesallyourfactorylinkageandbushings.Bydoingthisdesign,yougetasharp,crispshiftingfeelthatallowsextremelyfastshiftingonthetrack.Wepersonallytestedtheseonourracecarsaregaveitfivestarsforperformance!Wellworthit'svalue.Thesidesetscrewsallowsforadjustmentonleftandrightthrow.Evenbetter,theunithasabuiltinreverselockoutbuttonthatallowsreverseonlytobeusedwhenthedriverpushesthebuttonontopoftheshifter.Thismakesforlessmistakeswhenquicklygoingintofirstgear.##</p><p>##</p><p>CNCAluminumlightweightdesign<br/>ReverseLockOutButton<br/>Adjustableleftandrightmaxthrow<br/>Bearingdesignforzeroplay<br/>Precisegearengagement<br/>Allowsdrivertoshiftmuchfaster<br/>Crispracefeelshifting<br/>DesignedforRacingPurposes##</p><p>##</p><p><iframeallowfullscreen=\"\"frameborder=\"0\"height=\"360\"src=\"//www.youtube.com/embed/8fEMSLk2bQ4\"width=\"640\"></iframe></p>', 
                         1)
MySQLi error 1406: Data too long for column 'products_url' at row 1
When executing:
INSERT INTO products_description (
                            products_id,
                  products_name, products_description, products_url, 
                         language_id )
                                  VALUES (
                         1520,
                         'Prosport Premium Evo Digital Boost Gauge', '', '<p>Ifyourvehicleissuperchargedorturbochargedthenthisgaugeissimplyamusthave.ForpeakperformanceyouneedtoknowhowmuchboostyouaremakingatmaximumRPM's.Nowyoucanaccuratelymonitoryourboostasyoumodifyyourride!</p><p>Saveyourturbo-Setthewarningfeaturetoalertyoubeforeyouoverboost.Fullyprogrammabletoanylevelyouwant.Makechangeswithinsecondsusingthebuttonsonthefrontofthegauge.</p><p>Features:</p><ol><li>PeakRecall</li><li>FullyprogrammableWarningfeature</li><li>Dimmable</li><li>Daisychain</li><li>Premiumwaterproofsender</li><li>Wireharness(gaugetosender-plugandplay)</li><li>4colorchoices</li><li>Mountingcup</li><li>Visor</li><li>Freetechsupport<br/>##</li></ol><p>ThisElectricBoostGaugewillperformadigitalsweep/selfcheckonStart-up.</p><p>(-30vacto35PSI)</p><p>Includes:</p><ol><li>Mountinghardware</li><li>TubingKit</li><li>T-Adaptor</li><li>WaterproofElectricalsender</li><li>Wiringharness</li><li>Visor</li><li>Prosportdecal</li><li>Instructions</li></ol><p>##</p><p><iframeallowfullscreen=\"\"frameborder=\"0\"height=\"360\"src=\"//www.youtube.com/embed/Lk5xXoOPmHg\"width=\"640\"></iframe></p>', 
                         1)

                         


MySQLi error 1062: Duplicate entry '512' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                512, '', 222, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '512-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 512,
                    language_id     = 1,
                    categories_name = 'Accessories',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '512' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                512, '', 222, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '512-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 512,
                    language_id     = 1,
                    categories_name = 'Accessories',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '512' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                512, '', 222, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '512-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 512,
                    language_id     = 1,
                    categories_name = 'Accessories',
                    categories_description = ''

[project jayden]

URL: kdmracer.com
Zencart Version 1.5.8a
Latest EasyPopulate version
PHP Version: 8.0.30
Issue started when MySQL updated from 5.7 to 8.0.34



Finally was able to generate an error log through easypopulate. This was after I tried creating new main category & sub categories. Products ended up being placed in the main category instead of where they were supposed to go.

MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Engine',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Air Intake',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Suspension',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Lowering Springs',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Engine',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Air Intake',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Suspension',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Lowering Springs',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Engine',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Air Intake',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''

[mc12345678]

URL: kdmracer.com
Zencart Version 1.5.8a
Latest EasyPopulate version
PHP Version: 8.0.30
Issue started when MySQL updated from 5.7 to 8.0.34



Finally was able to generate an error log through easypopulate. This was after I tried creating new main category & sub categories. Products ended up being placed in the main category instead of where they were supposed to go.

MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Engine',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Air Intake',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Suspension',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Lowering Springs',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Engine',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Air Intake',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Suspension',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Lowering Springs',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Engine',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Air Intake',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Brakes',
                    categories_description = ''
MySQLi error 1062: Duplicate entry '514' for key 'categories.PRIMARY'
When executing:
INSERT INTO categories(categories_id, categories_image, parent_id, sort_order, date_added, last_modified
                ) VALUES (
                514, '', 514, 0, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP
                )
MySQLi error 1062: Duplicate entry '514-1' for key 'categories_description.PRIMARY'
When executing:
INSERT INTO categories_description SET
                    categories_id   = 514,
                    language_id     = 1,
                    categories_name = 'Rotors',
                    categories_description = ''

Try undoing (reversing) the following commit: New category_id based on auto_number · mc12345678/EasyPopulate-4.0@c870394 (github.com)

[project jayden]

Thank you for the reply! Unfortunately ran into the same issue. Products ended up in the main category instead of the subcategories and now also included errors in regards to MySQLi error 1062: Duplicate entry '515' instead of just 514.

[24-Oct-2023 23:03:08 UTC] Request URI: /************/index.php?cmd=easypopulate_4, IP address: 107.193.59.101, Language id 1
#1  ep_4_get_tax_title_class_id() called at [/home/************/public_html/kdmracer/************/easypopulate_4_import.php:651]
#2  include_once(/home/************/public_html/kdmracer/************/easypopulate_4_import.php) called at [/home/************/public_html/kdmracer/************/easypopulate_4.php:565]
#3  require(/home/************/public_html/kdmracer/************/easypopulate_4.php) called at [/home/************/public_html/kdmracer/************/index.php:11]
--> PHP Warning: Trying to access array offset on value of type null in /home/************/public_html/kdmracer/************/includes/functions/extra_functions/easypopulate_4_functions.php on line 407.