Magento 2.3: Error Assigning Related ProductsMagento 2 Admin- Invalid data provided for linked productsGoogle Search Console finds deleted productsMagento 1.9 not able to save upsell/related/cross sell productsMagento 2 Admin- Invalid data provided for linked productsCrosssell Products on Product Page with Magento 2Magento 2.3.0 Get Country NameExisting Products not saving after upgrading to Magento 2.3Magento 2.3 EE Bulk Asynchronous API Operations using RabbitMQSodiumChachaIetf::decrypt() must be of the type string, booleanMagento 2.3.0 - Class MailCampaignsConnectorHelperMailCampaigns_API does not existMagento 2.3.1 Error on checkout getAdditionalInformation()

How much cash can I safely carry into the USA and avoid civil forfeiture?

Why isn't the definition of absolute value applied when squaring a radical containing a variable?

How to creep the reader out with what seems like a normal person?

Will tsunami waves travel forever if there was no land?

How can the Zone of Truth spell be defeated without the caster knowing?

how to sum variables from file in bash

Rivers without rain

Meaning of Bloch representation

Phrase for the opposite of "foolproof"

Why do Computer Science majors learn Calculus?

Controversial area of mathematics

Do I have an "anti-research" personality?

Does Gita support doctrine of eternal samsara?

How did Captain America manage to do this?

Which big number is bigger?

With a Canadian student visa, can I spend a night at Vancouver before continuing to Toronto?

Why was the Spitfire's elliptical wing almost uncopied by other aircraft of World War 2?

Is it possible to determine the symmetric encryption method used by output size?

Why is it that the natural deduction method can't test for invalidity?

Who is the Umpire in this picture?

A Strange Latex Symbol

Sci fi novel series with instant travel between planets through gates. A river runs through the gates

What does the "ep" capability mean?

How exactly does Hawking radiation decrease the mass of black holes?



Magento 2.3: Error Assigning Related Products


Magento 2 Admin- Invalid data provided for linked productsGoogle Search Console finds deleted productsMagento 1.9 not able to save upsell/related/cross sell productsMagento 2 Admin- Invalid data provided for linked productsCrosssell Products on Product Page with Magento 2Magento 2.3.0 Get Country NameExisting Products not saving after upgrading to Magento 2.3Magento 2.3 EE Bulk Asynchronous API Operations using RabbitMQSodiumChachaIetf::decrypt() must be of the type string, booleanMagento 2.3.0 - Class MailCampaignsConnectorHelperMailCampaigns_API does not existMagento 2.3.1 Error on checkout getAdditionalInformation()






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;








1















Trying to add some related / cross-sell and upsells to products in the admin but receiving the following error after saving the product:




The linked products data is invalid. Verify the data and try again.




I checked my exception log and saw this:



main.CRITICAL: The linked products data is invalid. Verify the data and try again. "exception":"[object] (Magento\Framework\Exception\CouldNotSaveException(code: 0): The linked products data is invalid. Verify the data and try again. at /srv/public_html/vendor/magento/module-catalog/Model/ProductLink/Repository.php:141)" []


What could be the issue here?










share|improve this question






















  • did it happen to all or only for specific products?

    – magefms
    Apr 23 at 21:10











  • I haven't tested every product but so far every product we've tried we receive that error when trying to assign a related / upsell / crossell product

    – AJ47
    Apr 23 at 21:15











  • did you chrck this magento.stackexchange.com/questions/147183/…

    – magefms
    Apr 23 at 21:20






  • 1





    oh I see, I'll try that.. both of my tables are empty as that comment describes

    – AJ47
    Apr 23 at 21:48

















1















Trying to add some related / cross-sell and upsells to products in the admin but receiving the following error after saving the product:




The linked products data is invalid. Verify the data and try again.




I checked my exception log and saw this:



main.CRITICAL: The linked products data is invalid. Verify the data and try again. "exception":"[object] (Magento\Framework\Exception\CouldNotSaveException(code: 0): The linked products data is invalid. Verify the data and try again. at /srv/public_html/vendor/magento/module-catalog/Model/ProductLink/Repository.php:141)" []


What could be the issue here?










share|improve this question






















  • did it happen to all or only for specific products?

    – magefms
    Apr 23 at 21:10











  • I haven't tested every product but so far every product we've tried we receive that error when trying to assign a related / upsell / crossell product

    – AJ47
    Apr 23 at 21:15











  • did you chrck this magento.stackexchange.com/questions/147183/…

    – magefms
    Apr 23 at 21:20






  • 1





    oh I see, I'll try that.. both of my tables are empty as that comment describes

    – AJ47
    Apr 23 at 21:48













1












1








1








Trying to add some related / cross-sell and upsells to products in the admin but receiving the following error after saving the product:




The linked products data is invalid. Verify the data and try again.




I checked my exception log and saw this:



main.CRITICAL: The linked products data is invalid. Verify the data and try again. "exception":"[object] (Magento\Framework\Exception\CouldNotSaveException(code: 0): The linked products data is invalid. Verify the data and try again. at /srv/public_html/vendor/magento/module-catalog/Model/ProductLink/Repository.php:141)" []


What could be the issue here?










share|improve this question














Trying to add some related / cross-sell and upsells to products in the admin but receiving the following error after saving the product:




The linked products data is invalid. Verify the data and try again.




I checked my exception log and saw this:



main.CRITICAL: The linked products data is invalid. Verify the data and try again. "exception":"[object] (Magento\Framework\Exception\CouldNotSaveException(code: 0): The linked products data is invalid. Verify the data and try again. at /srv/public_html/vendor/magento/module-catalog/Model/ProductLink/Repository.php:141)" []


What could be the issue here?







magento2.3 related-products






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Apr 23 at 21:01









AJ47AJ47

320317




320317












  • did it happen to all or only for specific products?

    – magefms
    Apr 23 at 21:10











  • I haven't tested every product but so far every product we've tried we receive that error when trying to assign a related / upsell / crossell product

    – AJ47
    Apr 23 at 21:15











  • did you chrck this magento.stackexchange.com/questions/147183/…

    – magefms
    Apr 23 at 21:20






  • 1





    oh I see, I'll try that.. both of my tables are empty as that comment describes

    – AJ47
    Apr 23 at 21:48

















  • did it happen to all or only for specific products?

    – magefms
    Apr 23 at 21:10











  • I haven't tested every product but so far every product we've tried we receive that error when trying to assign a related / upsell / crossell product

    – AJ47
    Apr 23 at 21:15











  • did you chrck this magento.stackexchange.com/questions/147183/…

    – magefms
    Apr 23 at 21:20






  • 1





    oh I see, I'll try that.. both of my tables are empty as that comment describes

    – AJ47
    Apr 23 at 21:48
















did it happen to all or only for specific products?

– magefms
Apr 23 at 21:10





did it happen to all or only for specific products?

– magefms
Apr 23 at 21:10













I haven't tested every product but so far every product we've tried we receive that error when trying to assign a related / upsell / crossell product

– AJ47
Apr 23 at 21:15





I haven't tested every product but so far every product we've tried we receive that error when trying to assign a related / upsell / crossell product

– AJ47
Apr 23 at 21:15













did you chrck this magento.stackexchange.com/questions/147183/…

– magefms
Apr 23 at 21:20





did you chrck this magento.stackexchange.com/questions/147183/…

– magefms
Apr 23 at 21:20




1




1





oh I see, I'll try that.. both of my tables are empty as that comment describes

– AJ47
Apr 23 at 21:48





oh I see, I'll try that.. both of my tables are empty as that comment describes

– AJ47
Apr 23 at 21:48










1 Answer
1






active

oldest

votes


















0














I was able to fix this:



First check the following tables in your DB:



catalog_product_link_attribute and catalog_product_link_type



If those are empty, you need to run the following SQL queries:



INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES
(1, 1, 'position', 'int'),
(2, 4, 'position', 'int'),
(3, 5, 'position', 'int'),
(4, 3, 'position', 'int'),
(5, 3, 'qty', 'decimal');

INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES
(1, 'relation'),
(3, 'super'),
(4, 'up_sell'),
(5, 'cross_sell');





share|improve this answer























    Your Answer








    StackExchange.ready(function()
    var channelOptions =
    tags: "".split(" "),
    id: "479"
    ;
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function()
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled)
    StackExchange.using("snippets", function()
    createEditor();
    );

    else
    createEditor();

    );

    function createEditor()
    StackExchange.prepareEditor(
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader:
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    ,
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    );



    );













    draft saved

    draft discarded


















    StackExchange.ready(
    function ()
    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f271150%2fmagento-2-3-error-assigning-related-products%23new-answer', 'question_page');

    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0














    I was able to fix this:



    First check the following tables in your DB:



    catalog_product_link_attribute and catalog_product_link_type



    If those are empty, you need to run the following SQL queries:



    INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES
    (1, 1, 'position', 'int'),
    (2, 4, 'position', 'int'),
    (3, 5, 'position', 'int'),
    (4, 3, 'position', 'int'),
    (5, 3, 'qty', 'decimal');

    INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES
    (1, 'relation'),
    (3, 'super'),
    (4, 'up_sell'),
    (5, 'cross_sell');





    share|improve this answer



























      0














      I was able to fix this:



      First check the following tables in your DB:



      catalog_product_link_attribute and catalog_product_link_type



      If those are empty, you need to run the following SQL queries:



      INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES
      (1, 1, 'position', 'int'),
      (2, 4, 'position', 'int'),
      (3, 5, 'position', 'int'),
      (4, 3, 'position', 'int'),
      (5, 3, 'qty', 'decimal');

      INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES
      (1, 'relation'),
      (3, 'super'),
      (4, 'up_sell'),
      (5, 'cross_sell');





      share|improve this answer

























        0












        0








        0







        I was able to fix this:



        First check the following tables in your DB:



        catalog_product_link_attribute and catalog_product_link_type



        If those are empty, you need to run the following SQL queries:



        INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES
        (1, 1, 'position', 'int'),
        (2, 4, 'position', 'int'),
        (3, 5, 'position', 'int'),
        (4, 3, 'position', 'int'),
        (5, 3, 'qty', 'decimal');

        INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES
        (1, 'relation'),
        (3, 'super'),
        (4, 'up_sell'),
        (5, 'cross_sell');





        share|improve this answer













        I was able to fix this:



        First check the following tables in your DB:



        catalog_product_link_attribute and catalog_product_link_type



        If those are empty, you need to run the following SQL queries:



        INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES
        (1, 1, 'position', 'int'),
        (2, 4, 'position', 'int'),
        (3, 5, 'position', 'int'),
        (4, 3, 'position', 'int'),
        (5, 3, 'qty', 'decimal');

        INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES
        (1, 'relation'),
        (3, 'super'),
        (4, 'up_sell'),
        (5, 'cross_sell');






        share|improve this answer












        share|improve this answer



        share|improve this answer










        answered Apr 24 at 16:28









        AJ47AJ47

        320317




        320317



























            draft saved

            draft discarded
















































            Thanks for contributing an answer to Magento Stack Exchange!


            • Please be sure to answer the question. Provide details and share your research!

            But avoid


            • Asking for help, clarification, or responding to other answers.

            • Making statements based on opinion; back them up with references or personal experience.

            To learn more, see our tips on writing great answers.




            draft saved


            draft discarded














            StackExchange.ready(
            function ()
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f271150%2fmagento-2-3-error-assigning-related-products%23new-answer', 'question_page');

            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            Popular posts from this blog

            Sum ergo cogito? 1 nng

            419 nièngy_Soadمي 19bal1.5o_g

            Queiggey Chernihivv 9NnOo i Zw X QqKk LpB