I faced the error while search any string Magento 2Magento 2 SQLSTATE[42S22]: while create product?Magento installation on live server is throwing errorIntegrity constraint error referring to quote_item table while adding product to cartMagento 2.2.3 Getting an Error While Saving Product?Magento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)Getting error while adding category Magento2Existing Products not saving after upgrading to Magento 2.3Magento 2 Add Billing and Shipping Company Column on Sales Order Grid“The product doesn't exit” Error Magento 2 admin panelMagento 2 How to add SKU in Order Grid with filter
Can a US President, after impeachment and removal, be re-elected or re-appointed?
Why does Canada require bilingualism in a lot of federal government posts?
Was the Psych theme song written for the show?
Composing fill in the blanks
What is the reason for cards stating "Until end of turn, you don't lose this mana as steps and phases end"?
Convert graph format for Mathematica graph functions
Why are we moving in circles with a tandem kayak?
Would people understand me speaking German all over Europe?
Surviving a planet collision?
Is it okay for me to decline a project on ethical grounds?
Was Donald Trump at ground zero helping out on 9-11?
Alternatives to minimizing loss in regression
Is The Venice Syndrome documentary cover photo real?
How did astronauts using rovers tell direction without compasses on the Moon?
Just how much information should you share with a former client?
Should I accept an invitation to give a talk from someone who might review my proposal?
A variant of the Multiple Traveling Salesman Problem
Narset, Parter of Veils interaction with Aria of Flame
How to have poached eggs in "sphere form"?
Who said "one can be a powerful king with a very small sceptre"?
If the Moon were impacted by a suitably sized meteor, how long would it take to impact the Earth?
Do the books ever say oliphaunts aren’t elephants?
How does a poisoned arrow combine with the spell Conjure Barrage?
Can Lightning Lure be used to knock out a creature like a magical Taser?
I faced the error while search any string Magento 2
Magento 2 SQLSTATE[42S22]: while create product?Magento installation on live server is throwing errorIntegrity constraint error referring to quote_item table while adding product to cartMagento 2.2.3 Getting an Error While Saving Product?Magento 2, Unable to save products (Catalog rule indexing failed. See details in exception log.)Getting error while adding category Magento2Existing Products not saving after upgrading to Magento 2.3Magento 2 Add Billing and Shipping Company Column on Sales Order Grid“The product doesn't exit” Error Magento 2 admin panelMagento 2 How to add SKU in Order Grid with filter
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
When I search for any string in Magento2 then there is result page showing blank. I got the exception.log file.
"[2018-06-01 08:57:23] main.CRITICAL: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECT
search_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) "exception":"[object] (Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECTsearch_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)" []
"
magento2 catalogsearch
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
|
show 1 more comment
When I search for any string in Magento2 then there is result page showing blank. I got the exception.log file.
"[2018-06-01 08:57:23] main.CRITICAL: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECT
search_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) "exception":"[object] (Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECTsearch_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)" []
"
magento2 catalogsearch
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
Apply index matching the column list ----- ALTER TABLECOLUMNSADD FULLTEXT(column1,column2);
– Aditya Shah
Jun 1 '18 at 9:37
COLUMNS == YOUR COLUMNS WHICH GENERATING ISSUE
– Aditya Shah
Jun 1 '18 at 9:37
1
does any one found solution of it?
– Chirag Rajput
Oct 24 '18 at 11:53
@ChiragRajput Can you please give me your URL? Can you please check in the luma theme once?
– Sunny Rahevar
Oct 25 '18 at 6:00
@SunnyRahevar , Magento2 is installed in my local system (MAMP). I think the issue was due to database migration from magento1 to magento2. The answer of user payalpatel help me to solve this issue.
– Chirag Rajput
Oct 25 '18 at 6:37
|
show 1 more comment
When I search for any string in Magento2 then there is result page showing blank. I got the exception.log file.
"[2018-06-01 08:57:23] main.CRITICAL: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECT
search_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) "exception":"[object] (Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECTsearch_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)" []
"
magento2 catalogsearch
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
When I search for any string in Magento2 then there is result page showing blank. I got the exception.log file.
"[2018-06-01 08:57:23] main.CRITICAL: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECT
search_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) "exception":"[object] (Zend_Db_Statement_Exception(code: 0): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list, query was: SELECTsearch_synonyms.* FROMsearch_synonymsWHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE)) at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:235, PDOException(code: HY000): SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list at /opt/lampp/htdocs/magento223/vendor/magento/zendframework1/library/Zend/Db/Statement/Pdo.php:228)" []
"
magento2 catalogsearch
magento2 catalogsearch
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
edited Jun 1 '18 at 9:02
Kushal Dani
9693 silver badges25 bronze badges
9693 silver badges25 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
asked Jun 1 '18 at 8:59
Sunny RahevarSunny Rahevar
1,2964 silver badges17 bronze badges
1,2964 silver badges17 bronze badges
Apply index matching the column list ----- ALTER TABLECOLUMNSADD FULLTEXT(column1,column2);
– Aditya Shah
Jun 1 '18 at 9:37
COLUMNS == YOUR COLUMNS WHICH GENERATING ISSUE
– Aditya Shah
Jun 1 '18 at 9:37
1
does any one found solution of it?
– Chirag Rajput
Oct 24 '18 at 11:53
@ChiragRajput Can you please give me your URL? Can you please check in the luma theme once?
– Sunny Rahevar
Oct 25 '18 at 6:00
@SunnyRahevar , Magento2 is installed in my local system (MAMP). I think the issue was due to database migration from magento1 to magento2. The answer of user payalpatel help me to solve this issue.
– Chirag Rajput
Oct 25 '18 at 6:37
|
show 1 more comment
Apply index matching the column list ----- ALTER TABLECOLUMNSADD FULLTEXT(column1,column2);
– Aditya Shah
Jun 1 '18 at 9:37
COLUMNS == YOUR COLUMNS WHICH GENERATING ISSUE
– Aditya Shah
Jun 1 '18 at 9:37
1
does any one found solution of it?
– Chirag Rajput
Oct 24 '18 at 11:53
@ChiragRajput Can you please give me your URL? Can you please check in the luma theme once?
– Sunny Rahevar
Oct 25 '18 at 6:00
@SunnyRahevar , Magento2 is installed in my local system (MAMP). I think the issue was due to database migration from magento1 to magento2. The answer of user payalpatel help me to solve this issue.
– Chirag Rajput
Oct 25 '18 at 6:37
Apply index matching the column list ----- ALTER TABLE
COLUMNS ADD FULLTEXT(column1,column2);– Aditya Shah
Jun 1 '18 at 9:37
Apply index matching the column list ----- ALTER TABLE
COLUMNS ADD FULLTEXT(column1,column2);– Aditya Shah
Jun 1 '18 at 9:37
COLUMNS == YOUR COLUMNS WHICH GENERATING ISSUE
– Aditya Shah
Jun 1 '18 at 9:37
COLUMNS == YOUR COLUMNS WHICH GENERATING ISSUE
– Aditya Shah
Jun 1 '18 at 9:37
1
1
does any one found solution of it?
– Chirag Rajput
Oct 24 '18 at 11:53
does any one found solution of it?
– Chirag Rajput
Oct 24 '18 at 11:53
@ChiragRajput Can you please give me your URL? Can you please check in the luma theme once?
– Sunny Rahevar
Oct 25 '18 at 6:00
@ChiragRajput Can you please give me your URL? Can you please check in the luma theme once?
– Sunny Rahevar
Oct 25 '18 at 6:00
@SunnyRahevar , Magento2 is installed in my local system (MAMP). I think the issue was due to database migration from magento1 to magento2. The answer of user payalpatel help me to solve this issue.
– Chirag Rajput
Oct 25 '18 at 6:37
@SunnyRahevar , Magento2 is installed in my local system (MAMP). I think the issue was due to database migration from magento1 to magento2. The answer of user payalpatel help me to solve this issue.
– Chirag Rajput
Oct 25 '18 at 6:37
|
show 1 more comment
2 Answers
2
active
oldest
votes
Please check this query :
SELECT search_synonyms.* FROM search_synonyms WHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE))
And give the query in database table search_synonyms
ALTER TABLE search_synonyms ADD FULLTEXT(synonyms);
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
add a comment |
FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords.
A FULLTEXT index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX.
Cant find FULLTEXT index matching the column list
By your query, it seems that you are attempting to search the desired data using FULLTEXT INDEX functionality on NON-INDEXED columns of your table namely (title, detail, answer) that is why you are getting #1191 - Can't find FULLTEXT index matching the column error.
- Add the FULLTEXT INDEX on the concerned column. You can do this simply by the following query:
ALTER TABLE books ADD FULLTEXT name_of_index(title,detail,answer); - Or change your query by adding "IN BOOLEAN MODE" because MySQL allows to search on FULLTEXT non-indexed columns in this mode. So you will have to do the following:
SELECT id, title, category_id FROM books
WHERE
MATCH (title, detail, answer)
AGAINST ('What is mysql', IN BOOLEAN MODE)
LIMIT 0 , 30;
Note : Above code is giving a knowledge about your error you need to check how to do in magento.
I hope it helps!
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
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%2f228311%2fi-faced-the-error-while-search-any-string-magento-2%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
Please check this query :
SELECT search_synonyms.* FROM search_synonyms WHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE))
And give the query in database table search_synonyms
ALTER TABLE search_synonyms ADD FULLTEXT(synonyms);
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
add a comment |
Please check this query :
SELECT search_synonyms.* FROM search_synonyms WHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE))
And give the query in database table search_synonyms
ALTER TABLE search_synonyms ADD FULLTEXT(synonyms);
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
add a comment |
Please check this query :
SELECT search_synonyms.* FROM search_synonyms WHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE))
And give the query in database table search_synonyms
ALTER TABLE search_synonyms ADD FULLTEXT(synonyms);
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
Please check this query :
SELECT search_synonyms.* FROM search_synonyms WHERE (MATCH (synonyms) AGAINST ('9898' IN BOOLEAN MODE))
And give the query in database table search_synonyms
ALTER TABLE search_synonyms ADD FULLTEXT(synonyms);
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
answered Oct 24 '18 at 12:17
Payal PatelPayal Patel
1,04911 silver badges35 bronze badges
1,04911 silver badges35 bronze badges
add a comment |
add a comment |
FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords.
A FULLTEXT index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX.
Cant find FULLTEXT index matching the column list
By your query, it seems that you are attempting to search the desired data using FULLTEXT INDEX functionality on NON-INDEXED columns of your table namely (title, detail, answer) that is why you are getting #1191 - Can't find FULLTEXT index matching the column error.
- Add the FULLTEXT INDEX on the concerned column. You can do this simply by the following query:
ALTER TABLE books ADD FULLTEXT name_of_index(title,detail,answer); - Or change your query by adding "IN BOOLEAN MODE" because MySQL allows to search on FULLTEXT non-indexed columns in this mode. So you will have to do the following:
SELECT id, title, category_id FROM books
WHERE
MATCH (title, detail, answer)
AGAINST ('What is mysql', IN BOOLEAN MODE)
LIMIT 0 , 30;
Note : Above code is giving a knowledge about your error you need to check how to do in magento.
I hope it helps!
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
add a comment |
FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords.
A FULLTEXT index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX.
Cant find FULLTEXT index matching the column list
By your query, it seems that you are attempting to search the desired data using FULLTEXT INDEX functionality on NON-INDEXED columns of your table namely (title, detail, answer) that is why you are getting #1191 - Can't find FULLTEXT index matching the column error.
- Add the FULLTEXT INDEX on the concerned column. You can do this simply by the following query:
ALTER TABLE books ADD FULLTEXT name_of_index(title,detail,answer); - Or change your query by adding "IN BOOLEAN MODE" because MySQL allows to search on FULLTEXT non-indexed columns in this mode. So you will have to do the following:
SELECT id, title, category_id FROM books
WHERE
MATCH (title, detail, answer)
AGAINST ('What is mysql', IN BOOLEAN MODE)
LIMIT 0 , 30;
Note : Above code is giving a knowledge about your error you need to check how to do in magento.
I hope it helps!
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
add a comment |
FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords.
A FULLTEXT index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX.
Cant find FULLTEXT index matching the column list
By your query, it seems that you are attempting to search the desired data using FULLTEXT INDEX functionality on NON-INDEXED columns of your table namely (title, detail, answer) that is why you are getting #1191 - Can't find FULLTEXT index matching the column error.
- Add the FULLTEXT INDEX on the concerned column. You can do this simply by the following query:
ALTER TABLE books ADD FULLTEXT name_of_index(title,detail,answer); - Or change your query by adding "IN BOOLEAN MODE" because MySQL allows to search on FULLTEXT non-indexed columns in this mode. So you will have to do the following:
SELECT id, title, category_id FROM books
WHERE
MATCH (title, detail, answer)
AGAINST ('What is mysql', IN BOOLEAN MODE)
LIMIT 0 , 30;
Note : Above code is giving a knowledge about your error you need to check how to do in magento.
I hope it helps!
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
FULLTEXT indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to help speed up queries and DML operations on data contained within those columns, omitting any words that are defined as stopwords.
A FULLTEXT index is defined as part of a CREATE TABLE statement or added to an existing table using ALTER TABLE or CREATE INDEX.
Cant find FULLTEXT index matching the column list
By your query, it seems that you are attempting to search the desired data using FULLTEXT INDEX functionality on NON-INDEXED columns of your table namely (title, detail, answer) that is why you are getting #1191 - Can't find FULLTEXT index matching the column error.
- Add the FULLTEXT INDEX on the concerned column. You can do this simply by the following query:
ALTER TABLE books ADD FULLTEXT name_of_index(title,detail,answer); - Or change your query by adding "IN BOOLEAN MODE" because MySQL allows to search on FULLTEXT non-indexed columns in this mode. So you will have to do the following:
SELECT id, title, category_id FROM books
WHERE
MATCH (title, detail, answer)
AGAINST ('What is mysql', IN BOOLEAN MODE)
LIMIT 0 , 30;
Note : Above code is giving a knowledge about your error you need to check how to do in magento.
I hope it helps!
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
answered Oct 25 '18 at 5:31
Chirag PatelChirag Patel
3,7527 silver badges28 bronze badges
3,7527 silver badges28 bronze badges
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%2f228311%2fi-faced-the-error-while-search-any-string-magento-2%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
Apply index matching the column list ----- ALTER TABLE
COLUMNSADD FULLTEXT(column1,column2);– Aditya Shah
Jun 1 '18 at 9:37
COLUMNS == YOUR COLUMNS WHICH GENERATING ISSUE
– Aditya Shah
Jun 1 '18 at 9:37
1
does any one found solution of it?
– Chirag Rajput
Oct 24 '18 at 11:53
@ChiragRajput Can you please give me your URL? Can you please check in the luma theme once?
– Sunny Rahevar
Oct 25 '18 at 6:00
@SunnyRahevar , Magento2 is installed in my local system (MAMP). I think the issue was due to database migration from magento1 to magento2. The answer of user payalpatel help me to solve this issue.
– Chirag Rajput
Oct 25 '18 at 6:37