id,summary,reporter,owner,description,type,status,component,version,severity,resolution,keywords,cc,stage,has_patch,needs_docs,needs_tests,needs_better_patch,easy,ui_ux 22665,Creating trigger in custom sql for mySQL failed with 1046 error,hudan@…,nobody,"In file ""clothing.mysql.sql"" is trigger creation: {{{#!sql CREATE TRIGGER ins_laundryflow_clothing BEFORE INSERT ON laundryflow_clothing FOR EACH ROW BEGIN SET NEW.SumWash = NEW.StartWash; END }}} If I run ""syncdb"", it ends with error: {{{ Failed to install custom SQL for laundryflow.Clothing model: (1064, ""You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1"") }}} If I remove ""BEGIN"" and ""END"", everything works: {{{#!sql CREATE TRIGGER ins_laundryflow_clothing BEFORE INSERT ON laundryflow_clothing FOR EACH ROW SET NEW.SumWash = NEW.StartWash; }}} Using ""DELIMITER"" didn't work at all. On Internet I found, that it's relevant only in command line MySQL client and shouldn't by use in Python-MySQL. BTW> Creating stored procedures has the same problem.",Uncategorized,closed,"Database layer (models, ORM)",1.6,Normal,invalid,,,Unreviewed,0,0,0,0,0,0