EasyPopulate 4.0 Support Thread

gemohler:

On the lookout for things I need to know as I relearn the ZC environment.

Im doing EP4 imports, and I have a log file getting hammered with this (attached)

Gotcha, before suggesting what I just came up with, need to look to see if I have an existing solution on my development server. Mind me asking your specs? PHP version for example?

gemohler:

I may have got the text backwards, but the excel file is in the order of the import results.

Was the issue always discovered on the first line of any import or was the issue random throughout the import of the file?

mc12345678:

Gotcha, before suggesting what I just came up with, need to look to see if I have an existing solution on my development server. Mind me asking your specs? PHP version for example?

Right on..

mc12345678:

Was the issue always discovered on the first line of any import or was the issue random throughout the import of the file?

THIS file had this issue. Everything after it failed.

I took the data from THIS spreadsheet (except the header row), and put it in another one that did work (under it's header row)...and everything was fine.

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.

gemohler:

On the lookout for things I need to know as I relearn the ZC environment.

Im doing EP4 imports, and I have a log file getting hammered with this (attached)

Looks like my solution was to change the various instances of:

$categories_name_exists = false;
To an empty array:

$categories_name_exists = array(); // used for backwards compatibility
$categories_name_exists = []; // accomplishes the same as above via shortened code

Worked in PHP 8.2.9 for me. I had just come up with another idea, but it required writing more code.

mc12345678:

Looks like my solution was to change the various instances of:

$categories_name_exists = false;
To an empty array:

$categories_name_exists = array(); // used for backwards compatibility
$categories_name_exists = []; // accomplishes the same as above via shortened code

> 
> Worked in PHP 8.2.9 for me. I had just come up with another idea, but it required writing more code.

Just change those two instances in easypopulate_4_import.php?

Simple enough.  Was this having any impact other than a massive error log file?

gemohler:

Just change those two instances in easypopulate_4_import.php?

Simple enough. Was this having any impact other than a massive error log file?

That was in part my question to you. :smile: Looking over changes I have made to push to github, that appears to be all that I needed to do to support complete import of the records that were formatted correctly. Haven't heard if the above resolved the earlier issue of the two records where the first was bypassed but the second imported. Further, didn't see a response to the question about any sort of consistency of report saying not imported because the category name was missing.

Look forward to hearing results so that I can maybe prioritize some of the patches/changes that have been made.

CORRECTION: Apparently there are responses above that I did not see/fully read. Maybe more to follow from me? :blink:

gemohler:

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

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

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 = ''

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 :smile:

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'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 = ''

**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 = ''

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 = ''

Try undoing (reversing) the following commit: [New category\_id based on auto\_number · mc12345678/EasyPopulate-4.0@c870394 (github.com)](https://github.com/mc12345678/EasyPopulate-4.0/commit/c870394e6794ff23efca2008c61f839aa1e59c93)

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.

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.

Deleted. Hadn't seen previous reply.

project jayden:

URL: kdmracer.comZencart Version 1.5.8aLatest EasyPopulate versionPHP Version: 8.0.30 Issue started when MySQL updated from 5.7 to 8.0.34Finally 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)](https://github.com/mc12345678/EasyPopulate-4.0/commit/c870394e6794ff23efca2008c61f839aa1e59c93)I'm going to try to reproduce this situation using a similar mySQL server version. I believe I came across it and that is why my development code went back to restore the code in this area.  Specifically I have this:```
              // get next available categoies_id (though could replace the last deleted category id..//              $sql = "SHOW TABLE STATUS LIKE '" . TABLE_CATEGORIES . "'";              $sql = "SELECT MAX(categories_id) + 1 max FROM " . TABLE_CATEGORIES;              $result = ep_4_query($sql);              unset($sql);              $row = $ep_4_fetch_array($result);              unset($result);//              $max_category_id = $row['Auto_increment'];              $max_category_id = $row['max'];              // if database is empty, start at 1              if (!isset($max_category_id) || !is_numeric($max_category_id) || $max_category_id == 0) {                $max_category_id = 1;              }
```> **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.
```There are two things reported here. One, by the text at the beginning of this message, it looks like yes inserting a new category doesn't establish a parent/child relationship which causes the duplicate entry (child being inserted as if it is the parent also. The value 515 represents the category_id value that already exists but is attempted to be used again. The second issue is in relation to not having a tax_class_id for the given tax class title, this is a different issue than previously reported. I have a fix for this second one, but no idea the state of the code on your system because it seems things change so quickly and possibly drastically.For this second issue, I have the following in my development site at what is reported above as line 407 in admin/includes/functions/extra_functions/easypopulate_4_functions.php:instead of:```
  $tax_class_id = $tax_class_array['tax_class_id'];
```modify it to:```
  $tax_class_id = !empty($tax_class_array['tax_class_id']) ? $tax_class_array['tax_class_id'] : 0;
```> **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.Yes, it is this adding new category aspect that is to be corrected and is causing problems.Basically, a different method was attempted which is intended to use the categories table auto number field to support inserting the next set of data. The problem is though that until some other action occurs, that number is held while operations continue. I had changed the process so that the next number to be used would have come from the highest value the database had seen which would also increase on each insert. The problem is that the auto_number doesn't increase while still within the same "run". The alternative "original" method looks for the highest value currently used and adds one. This is a problem because if a category exists in the database and it is the current highest value and that gets deleted (purposefully), pulling the highest value plus one results in a number that was previously used instead of the next unused number.Would be nice to know what these "some" errors are so that can either show what is to be done to correct or develop something new.I'm near issuing a new version that has A LOT of changes, improvements and compatibility with ZC 1.5.8x to not need any changes to that code. I have to do some testing though before I feel comfortable even offering it to others to do some testing. One of the things I am last working on is code that ensures default table values are retrieved and of the applicable database type and gets handled through the rest of the php code in the expected converted data type.