Hi,
On Friday, October 17, 2014 10:18:34 AM UTC+5:30, Prashant wrote:
Solved the problem.
I had used a single script that contained both the create tables and triggers statements. If I separate the create trigger statements into a separate script it works.
Note :
If CakePHP encounters a CREATE/UPDATE/DELETE tables/views it will split the sql string based on the character ";"
Since the create trigger statements had a ";" contained within them - it didnt work properly. Separating all the trigger statements into a separate string solved the problem.
Regards.
-- On Friday, October 17, 2014 10:18:34 AM UTC+5:30, Prashant wrote:
Hi,I have verified it, it works correctly under phpMyAdmin.
Regards.
Solved the problem.
I had used a single script that contained both the create tables and triggers statements. If I separate the create trigger statements into a separate script it works.
Note :
If CakePHP encounters a CREATE/UPDATE/DELETE tables/views it will split the sql string based on the character ";"
Since the create trigger statements had a ";" contained within them - it didnt work properly. Separating all the trigger statements into a separate string solved the problem.
Regards.
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment