Skip to main content
Magento

Questions tagged [mysql-triggers]

Ask Question

The tag has no summary.

15 questions
Newest Active Bountied Unanswered
1 vote
0 answers
244 views

Iam running magento2 2.3.5 and i want to make trigger in db between those table which will showing in following : this is a table names dropship_order include 9 column each column will generate from ...
Hamad Mohammed's user avatar
  • 21
0 votes
1 answer
506 views

I've got a problem with migrating data from Magento 1.9.4.2 to Magento 2.3.2 in migrate:data. In step: Stage I've got General error 1419 and I don't know how to fix it.
kubaJS's user avatar
  • 55
1 vote
1 answer
517 views

i'm getting the error when i try to run data step for the data migration tool. The extension "codisto" has been uninstalled while ago. Please advise [Zend_Db_Statement_Exception] SQLSTATE[42000]: ...
Mage Explorer's user avatar
  • 990
0 votes
1 answer
1k views

Could not save product in Magento 2.1.9 after copying the database from another Magento 2.1.9 shop and changing the mysql user (f.e. if you copy your develop database to production server, the ...
koseduhemak's user avatar
  • 345
1 vote
0 answers
235 views

I have created custom module and through which i want to created trigger. below is installer code. $installer = $this; $installer->startSetup(); $installer->run(" delimiter | CREATE TRIGGER `...
Karan Adhikari's user avatar
  • 225
1 vote
1 answer
2k views

I am getting the following error when installing a module on AWS. General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe ...
brentwpeterson's user avatar
  • 6,134
1 vote
0 answers
357 views

I am trying to add mysql trigger using the upgradeschema in magento 2 but I am getting the "Cannot execute multiple queries". Below is my trigger DELIMITER $$ CREATE TRIGGER ...
manish_khot's user avatar
  • 430
2 votes
2 answers
6k views

I placed trigger statement in installer script but it didn't create in MySQL. Created File here Custom/Module/Setup/UpgradeSchema.php <?php namespace Custom\Module\Setup; use Magento\Framework\...
Mahendra Jella's user avatar
  • 1,257
42 votes
4 answers
26k views

First of all what I know : Index management is useful for increasing store performance. EAV has one disadvantage.it will store data in different tables. So that retrieving data is time-consuming. So ...
Sivakumar K's user avatar
  • 2,023
0 votes
1 answer
74 views

There is a custom extension that manage the shipping address for a local shipping carriers. Besides some extra fields for local data there is a custom field called tipo_direccion (address type in ...
abiyi's user avatar
  • 217
1 vote
3 answers
143 views

We've recently upgraded to EE 1.14 (CE 1.9). The mysql triggers solve a lot of problems with our reindexing. However, we have several scripts that update thousands to millions of products at a time. ...
eisaacson's user avatar
  • 151
6 votes
2 answers
10k views

If I want to update a configurable product I do get an error message: SQLSTATE[42000]: Syntax error or access violation: 1142 TRIGGER command denied to user 'dbadmin_magento'@'localhost' for table '...
Stefan's user avatar
  • 1,507
2 votes
0 answers
369 views

Magento Details: Magento EE 1.14.2.0 12 Websites 80 Store Groups 160 Stores 3500 Categories 15k products 75 Customer Groups Mysql 5.5 php-fpm 5.6 My import process has always worked successfully ...
Rob's user avatar
  • 534
9 votes
1 answer
2k views

I am trying to find out if Magento has a method available that allows to create MySQL triggers and Stored Procedures. Currently, i am using the core resource DB adapter to insert the raw SQL directly ...
Shaughn's user avatar
  • 1,762
2 votes
1 answer
150 views

If I'd like to have a table with three columns: firstname, lastname and username (a combination of firstname and lastname) I'd like the table to auto generate the username as soon as a record is ...
Moose's user avatar
  • 7,505