Edit report at https://bugs.php.net/bug.php?id=64571&edit=1
ID: 64571
Comment by: email at philsturgeon dot co dot uk
Reported by: jehoshua02 at gmail dot com
Summary: PDO CREATE TRIGGER
Status: Not a bug
Type: Bug
Package: PDO related
Operating System: Ubuntu 12.10 Desktop 64bit
PHP Version: 5.4.13
Block user comment: N
Private report: N
New Comment:
This should actually be $pdo->exec('CREATE TRIGGER...');
Previous Comments:
------------------------------------------------------------------------
[2013-04-06 15:43:25] fel...@php.net
DELIMITER is not a mysql statement, but a mysql client command.
Use a separated statement for create trigger part. e.g. $pdo->query("CREATE
TRIGGER ...");
------------------------------------------------------------------------
[2013-04-03 00:28:44] jehoshua02 at gmail dot com
Could the root of this problem be somehow related to the multiple-query problem?
------------------------------------------------------------------------
[2013-04-03 00:09:02] jehoshua02 at gmail dot com
Description:
------------
I'm using PDO in some simple script to do database migrations and realized that
my triggers weren't being created. I checked to make sure the triggers were
correct by first copying and pasting them into mysql interactive console, then
by using `SOURCE ...`, then by passing the file name into mysql command, each
time verifying the trigger was created by using "SHOW TRIGGERS WHERE `Trigger`
= :trigger". I concluded that the problem was not with my trigger statements,
or with mysql, but with PDO.
The actual PHP version is 5.4.6-1ubuntu1.2 so I chose the closest one.
Test script:
---------------
https://gist.github.com/jehoshua02/5297332
Expected result:
----------------
I would expect to see the trigger printed as an associative array.
Actual result:
--------------
The trigger is not created even though the script completes without any errors
or exceptions.
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=64571&edit=1
