Description: ------------ I wanna to run a Schema XML file. DB Driver->MySQL 5.1.33 Test script: --------------- $result = $schema->installSchema($main_file, $variables, $base_file, $data, $create, $debug); Expected result: ---------------- MDB2 Error: not found : _doQuery: [Error message: Could not execute statement] [Last executed query: CREATE TRIGGER test_pk_delete_trg BEFORE DELETE ON test1 FOR EACH ROW BEGIN SET FOREIGN_KEY_CHECKS = 0; IF (SELECT `test2`.test_id AS test_id FROM `test2` WHERE test_id = OLD.id) IS NOT NULL AND (NEW.id <> OLD.id) THEN CALL delete_ON_TABLE_test2_VIOLATES_FOREIGN_KEY_CONSTRAINT(); END IF; SET FOREIGN_KEY_CHECKS = 1; END;] [Native code: 1363] [Native message: There is no NEW row in on DELETE trigger]

Added patch Schema.XML.file.

Looks to me an error on MDB2 end. It is not handling properly the creation of ON DELETE triggers. This can be relevant: http://forums.mysql.com/read.php?99,252405,252405

This bug has been fixed in SVN. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better.