Error when adding a trigger

[zengheng3]

Hello,

I got an error when I tried to add a trigger by using the query() command of Mysql\pool under PHP 7.0. However, when I changed to PHP7.2, the error just disappeared. Here is the error message:

PHP TypeError:  Argument 1 passed to Amp\Mysql\ConnectionResultSet::makeIterator() must be an instance of Amp\Mysql\Internal\ResultProxy, instance of Amp\Mysql\CommandResult given, called in /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/ConnectionResultSet.php on line 134 in /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/ConnectionResultSet.php on line 32
PHP Stack trace:
PHP   1. {main}() /var/www/html/mysql-data-anonymizer/test2.php:0
PHP   2. Globalis\MysqlDataAnonymizer\Anonymizer->run() /var/www/html/mysql-data-anonymizer/test2.php:51
PHP   3. Amp\Loop::run() /var/www/html/mysql-data-anonymizer/src/Anonymizer.php:247
PHP   4. Amp\Loop\NativeDriver->run() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Loop.php:84
PHP   5. Amp\Loop\NativeDriver->tick() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Loop/Driver.php:72
PHP   6. Amp\Loop\NativeDriver->dispatch() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Loop/Driver.php:134
PHP   7. Amp\Loop\NativeDriver->selectStreams() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Loop/NativeDriver.php:97
PHP   8. Amp\ByteStream\ResourceInputStream::Amp\ByteStream\{closure:/var/www/html/mysql-data-anonymizer/vendor/amphp/byte-stream/lib/ResourceInputStream.php:70-100}() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Loop/NativeDriver.php:206
PHP   9. Amp\Deferred->resolve() /var/www/html/mysql-data-anonymizer/vendor/amphp/byte-stream/lib/ResourceInputStream.php:99
PHP  10. {anonymous-class:/var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Deferred.php:20-25}->resolve() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Deferred.php:45
PHP  11. Amp\Coroutine->Amp\{closure:/var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Coroutine.php:60-101}() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Internal/Placeholder.php:130
PHP  12. Generator->send() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Coroutine.php:76
PHP  13. Amp\Mysql\Internal\Processor->read() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Coroutine.php:76
PHP  14. Amp\Mysql\Internal\Processor->processData() /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/Internal/Processor.php:257
PHP  15. Amp\Mysql\Internal\Processor->parsePayload() /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/Internal/Processor.php:277
PHP  16. Amp\Mysql\Internal\Processor->handleQuery() /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/Internal/Processor.php:1350
PHP  17. Amp\Deferred->resolve() /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/Internal/Processor.php:829
PHP  18. {anonymous-class:/var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Deferred.php:20-25}->resolve() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Deferred.php:45
PHP  19. Amp\Coroutine->Amp\{closure:/var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Coroutine.php:60-101}() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Internal/Placeholder.php:130
PHP  20. Generator->send() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Coroutine.php:76
PHP  21. Amp\Mysql\ConnectionResultSet->Amp\Mysql\{closure:/var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/ConnectionResultSet.php:125-139}() /var/www/html/mysql-data-anonymizer/vendor/amphp/amp/lib/Coroutine.php:76
PHP  22. Amp\Mysql\ConnectionResultSet::makeIterator() /var/www/html/mysql-data-anonymizer/vendor/amphp/mysql/src/ConnectionResultSet.php:134

[trowski]

I haven't been able to reproduce this. Do you have an example query that causes the error?

[trowski]

Closing as no further feedback has been received. Feel free to reopen this issue or create a new one if you need further assistance.