Page 356 of 357 FirstFirst ... 256306346354355356357 LastLast
Results 3,551 to 3,560 of 3564
  1. #3551
    Join Date
    Jul 2012
    Posts
    16,680
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by gemohler View Post
    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).)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  2. #3552
    Join Date
    Jul 2005
    Location
    CA
    Posts
    240
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

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

  3. #3553
    Join Date
    Jul 2005
    Location
    CA
    Posts
    240
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by gemohler View Post
    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.
    Attached Images Attached Images  

  4. #3554
    Join Date
    Jul 2005
    Location
    CA
    Posts
    240
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by gemohler View Post
    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.
    Attached Images Attached Images  

  5. #3555
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    12
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

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

  6. #3556
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    12
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    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


    Quote Originally Posted by project jayden View Post
    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'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 = ''

  7. #3557
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    12
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    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.

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

  8. #3558
    Join Date
    Jul 2012
    Posts
    16,680
    Plugin Contributions
    17

    Default Re: EasyPopulate 4.0 Support Thread

    Quote Originally Posted by project jayden View Post
    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.

    Code:
    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)
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  9. #3559
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    12
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    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.

    Code:
    [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.
    Last edited by project jayden; 25 Oct 2023 at 12:25 AM.

  10. #3560
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    12
    Plugin Contributions
    0

    Default Re: EasyPopulate 4.0 Support Thread

    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.

 

 

Similar Threads

  1. Hebrew Support - latest release [Support Thread]
    By eranariel in forum Addon Language Packs
    Replies: 19
    Last Post: 23 Jan 2023, 08:04 AM
  2. BackUp ZC [Support Thread]
    By skipwater in forum All Other Contributions/Addons
    Replies: 285
    Last Post: 23 Dec 2020, 10:40 AM
  3. Wordpress On ZC [Support Thread]
    By hira in forum All Other Contributions/Addons
    Replies: 1858
    Last Post: 17 Jan 2014, 01:24 AM
  4. ZJ Black 2 support thread
    By Liamv in forum Addon Templates
    Replies: 1
    Last Post: 15 Feb 2010, 02:53 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR