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

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