Questions tagged [mysql-triggers]
The mysql-triggers tag has no usage guidance.
0
votes
1answer
34 views
Data Migration Error related to CREATE TRIGGER
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]: ...
0
votes
0answers
45 views
Restoring database triggers
There's been a known issue with Magento's backup/rollback process for a while, which was marked as resolved in 2.2.x & 2.3.x where taking a backup removed the mysql triggers:
(see: https://github....
0
votes
1answer
220 views
Could not save product - TRIGGER command denied to user
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 ...
1
vote
0answers
60 views
Creating trigger using mysql_setup
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 `...
1
vote
1answer
268 views
Magento 2 - MySQL privilege error on module install
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 ...
1
vote
0answers
133 views
Magento 2 : UpgradeSchema write mysql trigger
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 ...
2
votes
2answers
2k views
How to create MySQL Triggers through setup script
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\...
21
votes
3answers
7k views
what is mview in magento2?
First of all what i know :
Index management is useful for increasing store performance.
EAV has one disadvantage.it will store data into different tables.so that retrieving data is time consuming.
...
0
votes
1answer
48 views
Unable to nullify a custom field
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 ...
1
vote
3answers
77 views
Bypass reindex triggers on bulk upload in EE 1.14 (CE 1.9)
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. ...
5
votes
2answers
4k views
SQL Syntax error or access violation: 1142 TRIGGER command denied to user
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 '...
2
votes
0answers
278 views
Magento EE 1.14.2.0 Indexing Issue / Database Repair Tool failure “You have missed trigger(s)”
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 ...
8
votes
1answer
1k views
Is there a method in Magento that allows to create MySQL triggers and stored procedures?
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 ...
2
votes
1answer
124 views
Table with calculated column
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 ...
