Gsyfuy

Are the number of citations and number of published articles the most important criteria for a tenure promotion?

Finding angle with pure Geometry.

Why doesn't H₄O²⁺ exist?

What do the dots in this tr command do: tr .............A-Z A-ZA-Z <<< "JVPQBOV" (with 13 dots)

Is it legal for company to use my work email to pretend I still work there?

Modeling an IP Address

Either or Neither in sentence with another negative

Dragon forelimb placement

Adding span tags within wp_list_pages list items

Why can't I see bouncing of a switch on an oscilloscope?

Today is the Center

Why don't electron-positron collisions release infinite energy?

What defenses are there against being summoned by the Gate spell?

The use of multiple foreign keys on same column in SQL Server

Font hinting is lost in Chrome-like browsers (for some languages )

TGV timetables / schedules?

Fully-Firstable Anagram Sets

Schoenfled Residua test shows proportionality hazard assumptions holds but Kaplan-Meier plots intersect

Email Account under attack (really) - anything I can do?

Why, historically, did Gödel think CH was false?

Collect Fourier series terms

Why was the small council so happy for Tyrion to become the Master of Coin?

Have astronauts in space suits ever taken selfies? If so, how?

Why is consensus so controversial in Britain?

Magento 2: I'm unable to save new products

Magento duplicate the product getting innodb lock timeout errormagento 2 : Data tool migration transform date/timeMagento 2 Data Migration Tool Not connecting to remote serverMagento 1 to 2 data migration root'@'localhost Access denied situationLocal dev version bromeWhen using Data Migration tool I get exception undefined indexMagento 2 Migration From custom tables (non-magento) to magento 2After migration customers can't log using m1 passwordMagento 2: Setup version for module is not specifiedHow to manually import/migrate orders & customers from Magento1 to Magento 2 database tables?

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

1

My website is running on Magento 2.
I have migrated data from Magento 1.x to version 2.1 using UB data migration tool.
Now I am planning to upgrade Magento 2.1.3. After Magento upgrade

I am unable to save new products. It shows error:

SQLSTATE[HY000]: General error: 1449 The user specified as a definer
('rb_magento2'@'localhost') does not exist, query was: INSERT INTO
catalog_product_entity (entity_id, attribute_set_id, type_id,
sku, has_options, required_options) VALUES (?, ?, ?, ?, ?, ?)

The user rb_magento2 is or live Magento database but I have created a copy of Magento on a new server with the different username.

magento-2.1 product database migration magento2-migration-tool

share|improve this question

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

bumped to the homepage by Community♦ 21 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  stackoverflow.com/q/10169960/2047249
  
  – Marius♦
  Feb 24 '17 at 11:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Check the user has all privileges
  
  – Ramki
  Feb 24 '17 at 12:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have provided all the privileges but it is having different user
  
  – Paras Arora
  Feb 24 '17 at 12:08
  

  
  
  
  

add a comment | 

1

My website is running on Magento 2.
I have migrated data from Magento 1.x to version 2.1 using UB data migration tool.
Now I am planning to upgrade Magento 2.1.3. After Magento upgrade

I am unable to save new products. It shows error:

SQLSTATE[HY000]: General error: 1449 The user specified as a definer
('rb_magento2'@'localhost') does not exist, query was: INSERT INTO
catalog_product_entity (entity_id, attribute_set_id, type_id,
sku, has_options, required_options) VALUES (?, ?, ?, ?, ?, ?)

The user rb_magento2 is or live Magento database but I have created a copy of Magento on a new server with the different username.

magento-2.1 product database migration magento2-migration-tool

share|improve this question

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

bumped to the homepage by Community♦ 21 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  stackoverflow.com/q/10169960/2047249
  
  – Marius♦
  Feb 24 '17 at 11:50
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Check the user has all privileges
  
  – Ramki
  Feb 24 '17 at 12:07
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  I have provided all the privileges but it is having different user
  
  – Paras Arora
  Feb 24 '17 at 12:08
  

  
  
  
  

add a comment | 

My website is running on Magento 2.
I have migrated data from Magento 1.x to version 2.1 using UB data migration tool.
Now I am planning to upgrade Magento 2.1.3. After Magento upgrade

I am unable to save new products. It shows error:

SQLSTATE[HY000]: General error: 1449 The user specified as a definer
('rb_magento2'@'localhost') does not exist, query was: INSERT INTO
catalog_product_entity (entity_id, attribute_set_id, type_id,
sku, has_options, required_options) VALUES (?, ?, ?, ?, ?, ?)

The user rb_magento2 is or live Magento database but I have created a copy of Magento on a new server with the different username.

magento-2.1 product database migration magento2-migration-tool

share|improve this question

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

share|improve this question

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

share|improve this question

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

edited Dec 19 '17 at 16:00

Rafael Corrêa Gomes

4,64023365

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

asked Feb 24 '17 at 11:43

Paras AroraParas Arora

423419

2 Answers
2

active

oldest

votes

0

1 - You can fix that renaming the file app/etc/env.php to app/etc/env.php.bkp.

2 - Use the command cat app/etc/env.php.bkp to see the DB credentials.

3 - Run these commands below changing the data like DB host, user, password, base URL, admin user, password, etc..

php -f ./bin/magento setup:install --base-url=http://localhost/ 

    --db-host=db 

    --db-name=magento 

    --db-user=magento 

    --db-password=magento 

    --admin-firstname=Magento 

    --admin-lastname=Commerce 

    --admin-email=user@example.com 

    --admin-user=admin 

    --admin-password=admin123 

    --language=en_US 

    --currency=USD 

    --timezone=America/Chicago 

    --use-rewrites=1 

    --backend-frontname=admin

4 - Finalize running these commands:

alias mage="php -d memory_limit=-1 -f bin/magento"



mage maintenance:enable

rm -rf var/view_preprocessed/ var/cache/ var/page_cache/ var/di/ var/tmp/ var/generation/ pub/static/frontend/ ;

mage setup:upgrade &&

mage setup:db-data:upgrade &&

mage dev:source-theme:deploy &&

mage cache:flush &&

mage indexer:reindex &

chmod -R 775 pub/static/ pub/media/ var/

mage setup:static-content:deploy

mage setup:di:compile

mage maintenance:disable

mage setup:db-schema:upgrade

mage setup:db-data:upgrade

mage setup:db:status

Done!

share|improve this answer

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

add a comment | 

0

I had the same problem and I got the solution doing this:

1. 
   

   Export database using the following command:

   
   
   

   
   
   mysqldump -h [database_host] --user=[database_username] --password=[password] --single-transaction main | sed -e 's/DEFINER[ ]*=[ ]*[^*]**/*/' | gzip > /path/to/database_name.sql.gz
   
   

   
   



2. Import the database again.

The error is caused because the user rb_magento2 doesn't exist or hasn't permissions.

Also you can try creating a user with name rb_magento2 but the first solution is the most recommended.

Check this doc:
https://devdocs.magento.com/guides/v2.2/cloud/live/stage-prod-migrate.html#troubleshooting-the-database-migration

share|improve this answer

edited Sep 26 '18 at 19:49

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110

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');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmagento.stackexchange.com%2fquestions%2f161635%2fmagento-2-im-unable-to-save-new-products%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

1 - You can fix that renaming the file app/etc/env.php to app/etc/env.php.bkp.

2 - Use the command cat app/etc/env.php.bkp to see the DB credentials.

3 - Run these commands below changing the data like DB host, user, password, base URL, admin user, password, etc..

php -f ./bin/magento setup:install --base-url=http://localhost/ 

    --db-host=db 

    --db-name=magento 

    --db-user=magento 

    --db-password=magento 

    --admin-firstname=Magento 

    --admin-lastname=Commerce 

    --admin-email=user@example.com 

    --admin-user=admin 

    --admin-password=admin123 

    --language=en_US 

    --currency=USD 

    --timezone=America/Chicago 

    --use-rewrites=1 

    --backend-frontname=admin

4 - Finalize running these commands:

alias mage="php -d memory_limit=-1 -f bin/magento"



mage maintenance:enable

rm -rf var/view_preprocessed/ var/cache/ var/page_cache/ var/di/ var/tmp/ var/generation/ pub/static/frontend/ ;

mage setup:upgrade &&

mage setup:db-data:upgrade &&

mage dev:source-theme:deploy &&

mage cache:flush &&

mage indexer:reindex &

chmod -R 775 pub/static/ pub/media/ var/

mage setup:static-content:deploy

mage setup:di:compile

mage maintenance:disable

mage setup:db-schema:upgrade

mage setup:db-data:upgrade

mage setup:db:status

Done!

share|improve this answer

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

add a comment | 

0

1 - You can fix that renaming the file app/etc/env.php to app/etc/env.php.bkp.

2 - Use the command cat app/etc/env.php.bkp to see the DB credentials.

3 - Run these commands below changing the data like DB host, user, password, base URL, admin user, password, etc..

php -f ./bin/magento setup:install --base-url=http://localhost/ 

    --db-host=db 

    --db-name=magento 

    --db-user=magento 

    --db-password=magento 

    --admin-firstname=Magento 

    --admin-lastname=Commerce 

    --admin-email=user@example.com 

    --admin-user=admin 

    --admin-password=admin123 

    --language=en_US 

    --currency=USD 

    --timezone=America/Chicago 

    --use-rewrites=1 

    --backend-frontname=admin

4 - Finalize running these commands:

alias mage="php -d memory_limit=-1 -f bin/magento"



mage maintenance:enable

rm -rf var/view_preprocessed/ var/cache/ var/page_cache/ var/di/ var/tmp/ var/generation/ pub/static/frontend/ ;

mage setup:upgrade &&

mage setup:db-data:upgrade &&

mage dev:source-theme:deploy &&

mage cache:flush &&

mage indexer:reindex &

chmod -R 775 pub/static/ pub/media/ var/

mage setup:static-content:deploy

mage setup:di:compile

mage maintenance:disable

mage setup:db-schema:upgrade

mage setup:db-data:upgrade

mage setup:db:status

Done!

share|improve this answer

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

add a comment | 

1 - You can fix that renaming the file app/etc/env.php to app/etc/env.php.bkp.

2 - Use the command cat app/etc/env.php.bkp to see the DB credentials.

3 - Run these commands below changing the data like DB host, user, password, base URL, admin user, password, etc..

php -f ./bin/magento setup:install --base-url=http://localhost/ 

    --db-host=db 

    --db-name=magento 

    --db-user=magento 

    --db-password=magento 

    --admin-firstname=Magento 

    --admin-lastname=Commerce 

    --admin-email=user@example.com 

    --admin-user=admin 

    --admin-password=admin123 

    --language=en_US 

    --currency=USD 

    --timezone=America/Chicago 

    --use-rewrites=1 

    --backend-frontname=admin

4 - Finalize running these commands:

alias mage="php -d memory_limit=-1 -f bin/magento"



mage maintenance:enable

rm -rf var/view_preprocessed/ var/cache/ var/page_cache/ var/di/ var/tmp/ var/generation/ pub/static/frontend/ ;

mage setup:upgrade &&

mage setup:db-data:upgrade &&

mage dev:source-theme:deploy &&

mage cache:flush &&

mage indexer:reindex &

chmod -R 775 pub/static/ pub/media/ var/

mage setup:static-content:deploy

mage setup:di:compile

mage maintenance:disable

mage setup:db-schema:upgrade

mage setup:db-data:upgrade

mage setup:db:status

Done!

share|improve this answer

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

php -f ./bin/magento setup:install --base-url=http://localhost/ 

    --db-host=db 

    --db-name=magento 

    --db-user=magento 

    --db-password=magento 

    --admin-firstname=Magento 

    --admin-lastname=Commerce 

    --admin-email=user@example.com 

    --admin-user=admin 

    --admin-password=admin123 

    --language=en_US 

    --currency=USD 

    --timezone=America/Chicago 

    --use-rewrites=1 

    --backend-frontname=admin

alias mage="php -d memory_limit=-1 -f bin/magento"



mage maintenance:enable

rm -rf var/view_preprocessed/ var/cache/ var/page_cache/ var/di/ var/tmp/ var/generation/ pub/static/frontend/ ;

mage setup:upgrade &&

mage setup:db-data:upgrade &&

mage dev:source-theme:deploy &&

mage cache:flush &&

mage indexer:reindex &

chmod -R 775 pub/static/ pub/media/ var/

mage setup:static-content:deploy

mage setup:di:compile

mage maintenance:disable

mage setup:db-schema:upgrade

mage setup:db-data:upgrade

mage setup:db:status

share|improve this answer

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

answered Dec 19 '17 at 16:10

Rafael Corrêa GomesRafael Corrêa Gomes

4,64023365

0

I had the same problem and I got the solution doing this:

1. 
   

   Export database using the following command:

   
   
   

   
   
   mysqldump -h [database_host] --user=[database_username] --password=[password] --single-transaction main | sed -e 's/DEFINER[ ]*=[ ]*[^*]**/*/' | gzip > /path/to/database_name.sql.gz
   
   

   
   



2. Import the database again.

The error is caused because the user rb_magento2 doesn't exist or hasn't permissions.

Also you can try creating a user with name rb_magento2 but the first solution is the most recommended.

Check this doc:
https://devdocs.magento.com/guides/v2.2/cloud/live/stage-prod-migrate.html#troubleshooting-the-database-migration

share|improve this answer

edited Sep 26 '18 at 19:49

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110

add a comment | 

0

I had the same problem and I got the solution doing this:

1. 
   

   Export database using the following command:

   
   
   

   
   
   mysqldump -h [database_host] --user=[database_username] --password=[password] --single-transaction main | sed -e 's/DEFINER[ ]*=[ ]*[^*]**/*/' | gzip > /path/to/database_name.sql.gz
   
   

   
   



2. Import the database again.

The error is caused because the user rb_magento2 doesn't exist or hasn't permissions.

Also you can try creating a user with name rb_magento2 but the first solution is the most recommended.

Check this doc:
https://devdocs.magento.com/guides/v2.2/cloud/live/stage-prod-migrate.html#troubleshooting-the-database-migration

share|improve this answer

edited Sep 26 '18 at 19:49

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110

add a comment | 

I had the same problem and I got the solution doing this:

1. 
   

   Export database using the following command:

   
   
   

   
   
   mysqldump -h [database_host] --user=[database_username] --password=[password] --single-transaction main | sed -e 's/DEFINER[ ]*=[ ]*[^*]**/*/' | gzip > /path/to/database_name.sql.gz
   
   

   
   



2. Import the database again.

The error is caused because the user rb_magento2 doesn't exist or hasn't permissions.

Also you can try creating a user with name rb_magento2 but the first solution is the most recommended.

Check this doc:
https://devdocs.magento.com/guides/v2.2/cloud/live/stage-prod-migrate.html#troubleshooting-the-database-migration

share|improve this answer

edited Sep 26 '18 at 19:49

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110

share|improve this answer

edited Sep 26 '18 at 19:49

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110

answered Sep 26 '18 at 19:44

Andres Rojas OrozcoAndres Rojas Orozco

165110