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;
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
add a comment |
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
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
add a comment |
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
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
magento2.3 related-products
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
add a comment |
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
add a comment |
1 Answer
1
active
oldest
votes
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');
add a comment |
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
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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');
add a comment |
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');
add a comment |
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');
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');
answered Apr 24 at 16:28
AJ47AJ47
320317
320317
add a comment |
add a comment |
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.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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