Gsyfuy

Learning to quickly identify valid fingering for piano?

Replacing tantalum capacitor with ceramic capacitor for Op Amps

An Undercover Army

What is Tony Stark injecting into himself in Iron Man 3?

Where is the fallacy here?

The (Easy) Road to Code

Is there a frame of reference in which I was born before I was conceived?

What can I do if someone tampers with my SSH public key?

Does the US political system, in principle, allow for a no-party system?

When to use the term transposed instead of modulation?

Are small insurances worth it

Are there other characters in the Star Wars universe who had damaged bodies and needed to wear an outfit like Darth Vader?

How can I be pwned if I'm not registered on the compromised site?

What is a term for a function that when called repeatedly, has the same effect as calling once?

Align equations with text before one of them

Under what conditions would I NOT add my Proficiency Bonus to a Spell Attack Roll (or Saving Throw DC)?

Convert an array of objects to array of the objects' values

Deal the cards to the players

How do we objectively assess if a dialogue sounds unnatural or cringy?

What is the meaning of option 'by' in TikZ Intersections

New invention compresses matter to produce energy? or other items? (Short Story)

Dukha vs legitimate need

Using the imperfect indicative vs. subjunctive with si

If nine coins are tossed, what is the probability that the number of heads is even?

Requested store not found

Magento 2: Requested store is not foundMagento search not working after ReindexingCustom store view range attribute can't be modified in admin panelAdvice on closing orders that can not be viewed in a safe mannerMYSQL Query to delete url rewrites for an old store IDUnknown column 'price_index.min_price' when i search for some productSlow SQL Query on Magento 1.9 with MySqll (Percona) 5.7Delete Magento orders with all related dataMagento 1.9 running slow after migrating to new database serverRequested store is not foundModifying a query (get products using SQL only)

1

1

I am having an issue with stores, magento is trying to find a store by id '3', it doesn't exist, due to which most of the functionality is not working. Website was migrated from 1.9.2.4 to 2.2.7, I have checked both databases for the store ID but it only exists in the new database.

I have checked Magento 2: Requested store is not found

But it isn't related to my issue and not working.

After some digging I found that store ID '3' should infact be '5' as that is the store which customers belong to.
I am trying to run a db query that changes store_id to 5 from 3, is this good practice or there is another way? How do I perform this for whole database instead of one table as in the query below.

UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';

database magento2.2.7

share

asked 5 mins ago

ahmad talatahmad talat

529

add a comment | 

1

1

I am having an issue with stores, magento is trying to find a store by id '3', it doesn't exist, due to which most of the functionality is not working. Website was migrated from 1.9.2.4 to 2.2.7, I have checked both databases for the store ID but it only exists in the new database.

I have checked Magento 2: Requested store is not found

But it isn't related to my issue and not working.

After some digging I found that store ID '3' should infact be '5' as that is the store which customers belong to.
I am trying to run a db query that changes store_id to 5 from 3, is this good practice or there is another way? How do I perform this for whole database instead of one table as in the query below.

UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';

database magento2.2.7

share

asked 5 mins ago

ahmad talatahmad talat

529

add a comment | 

I am having an issue with stores, magento is trying to find a store by id '3', it doesn't exist, due to which most of the functionality is not working. Website was migrated from 1.9.2.4 to 2.2.7, I have checked both databases for the store ID but it only exists in the new database.

I have checked Magento 2: Requested store is not found

But it isn't related to my issue and not working.

After some digging I found that store ID '3' should infact be '5' as that is the store which customers belong to.
I am trying to run a db query that changes store_id to 5 from 3, is this good practice or there is another way? How do I perform this for whole database instead of one table as in the query below.

UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';

database magento2.2.7

share

asked 5 mins ago

ahmad talatahmad talat

529

UPDATE  `MySQL_Table` SET  `MySQL_Table_Column` = REPLACE(`MySQL_Table_Column`, 'oldString', 'newString') WHERE  `MySQL_Table_Column` LIKE 'oldString%';

share

asked 5 mins ago

ahmad talatahmad talat

529

share

asked 5 mins ago

ahmad talatahmad talat

529

asked 5 mins ago

ahmad talatahmad talat

529

asked 5 mins ago

ahmad talatahmad talat

529