Unique constraint violation found - When remove suffix .html - Magento 2.2.0
2
When I try to remove the .html suffix from category, Magento 2.2.0 gives me this error.
Has anyone else ran into the same problem? How can I resolve it?
Thank you
magento2 admin category
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
add a comment |
2
When I try to remove the .html suffix from category, Magento 2.2.0 gives me this error.
Has anyone else ran into the same problem? How can I resolve it?
Thank you
magento2 admin category
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
Did you find a solution to this?
– Will Wright
Dec 18 '17 at 14:59
Not yet. Do you have same problem on Magento 2.2.0?
– Fabio Russo
Dec 19 '17 at 15:22
1
I got around it by just replacing it with a / not a fix but meant I could remove the .html
– Will Wright
Dec 23 '17 at 10:36
1
Hi guys, i didnt fix it, but i insert a slash "/" instead of ".html" and it now load the url without ".html" suffix.
– Fabio Russo
Jan 4 '18 at 12:48
It is a 2.2.0 Magento version bug, upgrade it newest one.
– Fabio Russo
Apr 11 '18 at 11:05
add a comment |
2
2
2
When I try to remove the .html suffix from category, Magento 2.2.0 gives me this error.
Has anyone else ran into the same problem? How can I resolve it?
Thank you
magento2 admin category
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
When I try to remove the .html suffix from category, Magento 2.2.0 gives me this error.
Has anyone else ran into the same problem? How can I resolve it?
Thank you
magento2 admin category
magento2 admin category
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
edited Dec 13 '17 at 17:20
Ben Crook
8,7202273
8,7202273
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
asked Dec 11 '17 at 13:45
Fabio RussoFabio Russo
112
112
Did you find a solution to this?
– Will Wright
Dec 18 '17 at 14:59
Not yet. Do you have same problem on Magento 2.2.0?
– Fabio Russo
Dec 19 '17 at 15:22
1
I got around it by just replacing it with a / not a fix but meant I could remove the .html
– Will Wright
Dec 23 '17 at 10:36
1
Hi guys, i didnt fix it, but i insert a slash "/" instead of ".html" and it now load the url without ".html" suffix.
– Fabio Russo
Jan 4 '18 at 12:48
It is a 2.2.0 Magento version bug, upgrade it newest one.
– Fabio Russo
Apr 11 '18 at 11:05
add a comment |
Did you find a solution to this?
– Will Wright
Dec 18 '17 at 14:59
Not yet. Do you have same problem on Magento 2.2.0?
– Fabio Russo
Dec 19 '17 at 15:22
1
I got around it by just replacing it with a / not a fix but meant I could remove the .html
– Will Wright
Dec 23 '17 at 10:36
1
Hi guys, i didnt fix it, but i insert a slash "/" instead of ".html" and it now load the url without ".html" suffix.
– Fabio Russo
Jan 4 '18 at 12:48
It is a 2.2.0 Magento version bug, upgrade it newest one.
– Fabio Russo
Apr 11 '18 at 11:05
Did you find a solution to this?
– Will Wright
Dec 18 '17 at 14:59
Did you find a solution to this?
– Will Wright
Dec 18 '17 at 14:59
Not yet. Do you have same problem on Magento 2.2.0?
– Fabio Russo
Dec 19 '17 at 15:22
Not yet. Do you have same problem on Magento 2.2.0?
– Fabio Russo
Dec 19 '17 at 15:22
1
1
I got around it by just replacing it with a / not a fix but meant I could remove the .html
– Will Wright
Dec 23 '17 at 10:36
I got around it by just replacing it with a / not a fix but meant I could remove the .html
– Will Wright
Dec 23 '17 at 10:36
1
1
Hi guys, i didnt fix it, but i insert a slash "/" instead of ".html" and it now load the url without ".html" suffix.
– Fabio Russo
Jan 4 '18 at 12:48
Hi guys, i didnt fix it, but i insert a slash "/" instead of ".html" and it now load the url without ".html" suffix.
– Fabio Russo
Jan 4 '18 at 12:48
It is a 2.2.0 Magento version bug, upgrade it newest one.
– Fabio Russo
Apr 11 '18 at 11:05
It is a 2.2.0 Magento version bug, upgrade it newest one.
– Fabio Russo
Apr 11 '18 at 11:05
add a comment |
1 Answer
1
active
oldest
votes
0
Here are the steps to solve the issue:
- Backup your current Magento2 database
Delete all records from table
url_rewrite. You can run the following SQL command:
DELETE FROM url_rewrite WHERE entity_type = 'product';
Login to your Magento 2 backend
- Re-save all your Categories
- Clean the Magento2 cache
- Now, you should be able to save/update the
Product URL Suffixin theConfiguration Settings.
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
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
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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%2f205337%2funique-constraint-violation-found-when-remove-suffix-html-magento-2-2-0%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
Here are the steps to solve the issue:
- Backup your current Magento2 database
Delete all records from table
url_rewrite. You can run the following SQL command:
DELETE FROM url_rewrite WHERE entity_type = 'product';
Login to your Magento 2 backend
- Re-save all your Categories
- Clean the Magento2 cache
- Now, you should be able to save/update the
Product URL Suffixin theConfiguration Settings.
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
add a comment |
0
Here are the steps to solve the issue:
- Backup your current Magento2 database
Delete all records from table
url_rewrite. You can run the following SQL command:
DELETE FROM url_rewrite WHERE entity_type = 'product';
Login to your Magento 2 backend
- Re-save all your Categories
- Clean the Magento2 cache
- Now, you should be able to save/update the
Product URL Suffixin theConfiguration Settings.
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
add a comment |
0
0
0
Here are the steps to solve the issue:
- Backup your current Magento2 database
Delete all records from table
url_rewrite. You can run the following SQL command:
DELETE FROM url_rewrite WHERE entity_type = 'product';
Login to your Magento 2 backend
- Re-save all your Categories
- Clean the Magento2 cache
- Now, you should be able to save/update the
Product URL Suffixin theConfiguration Settings.
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
Here are the steps to solve the issue:
- Backup your current Magento2 database
Delete all records from table
url_rewrite. You can run the following SQL command:
DELETE FROM url_rewrite WHERE entity_type = 'product';
Login to your Magento 2 backend
- Re-save all your Categories
- Clean the Magento2 cache
- Now, you should be able to save/update the
Product URL Suffixin theConfiguration Settings.
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
answered 18 mins ago
Mukesh ChapagainMukesh Chapagain
3,66912241
3,66912241
add a comment |
add a comment |
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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%2f205337%2funique-constraint-violation-found-when-remove-suffix-html-magento-2-2-0%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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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');
var $window = $(window),
onScroll = function(e) {
var $elem = $('.new-login-left'),
docViewTop = $window.scrollTop(),
docViewBottom = docViewTop + $window.height(),
elemTop = $elem.offset().top,
elemBottom = elemTop + $elem.height();
if ((docViewTop elemBottom)) {
StackExchange.using('gps', function() { StackExchange.gps.track('embedded_signup_form.view', { location: 'question_page' }); });
$window.unbind('scroll', onScroll);
}
};
$window.on('scroll', onScroll);
});
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 you find a solution to this?
– Will Wright
Dec 18 '17 at 14:59
Not yet. Do you have same problem on Magento 2.2.0?
– Fabio Russo
Dec 19 '17 at 15:22
1
I got around it by just replacing it with a / not a fix but meant I could remove the .html
– Will Wright
Dec 23 '17 at 10:36
1
Hi guys, i didnt fix it, but i insert a slash "/" instead of ".html" and it now load the url without ".html" suffix.
– Fabio Russo
Jan 4 '18 at 12:48
It is a 2.2.0 Magento version bug, upgrade it newest one.
– Fabio Russo
Apr 11 '18 at 11:05