EasyPopulate 4.0 Support Thread

[mc12345678]

I have this defined in the config:

User Defined Products Fields v_products_qty_box_status. (I have also tried this without v_)

I have this in my CSV:
v_products_qty_box_status
0

The one product I test this one, continues to show a qty available, which I want to set to hidden.

It seems as if I've done the right things as I've seen in a few good threads.

If you also go to the admin version of the product information page for that product, there should be an entry for a term equal to or similar to product qty maximum. Is it/has it been updated to reflect the value of 0?

If it has been updated to a value of zero and the box shows on the catalog side for the product then the issue is template related and not database/EP4 related.

Again, though the entry in the user defined Products Fields should not begin with v_ unless the field in your table also starts with v_.

The intention is to list the field designation as entered in the table.

Then, when working in the CSV file(s) that is where the v_ becomes important.

(Remember, with the desired user defined products fields entered exporting data should create a file that includes the entered field(s). Additionally, the right side of the admin screen should confirm the presence of the entered User Defined Products Field(s).)

[gemohler]

"If it has been updated to a value of zero and the box shows on the catalog side for the product then the issue is template related and not database/EP4 related."

This is in fact the case, TY.

[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.

[project jayden]

Just a quick update.

So easypopulate would work fine If a category already existed it.
Issue seemed to be when creating new categories.
One work around was to create the categories manually and then uploading the spreadsheet...twice.
For some reason the first time would generate errors and only do a partial upload of new products. The second time it would be fine and upload everything correctly.

Anyways we are going to try and downgrade MySQL server later tonight back to 5.7 since we can't figure out what was going on. crossing fingers everything works after.