[DBAL-346] Generated schema fails on MySQL (BLOB/TEXT cant have DEFAULT value) Created: 19/Sep/12 Updated: 20/Sep/12 Resolved: 20/Sep/12
|Reporter:||Sascha Ahmann||Assignee:||Benjamin Eberlei|
Symfony 2.1.x (dev/master), Doctrine 2.2.3, MySQL 5.5.x
In my symfony 2.1 project i was including JMSPaymentCoreBundle and did the vanilla installation.
After that i ran
A lot of schema updates were done. I ran it again, and two schema updates were still showing up.
I then tried to run the two schema updates against my database and MySQL complains with the following error:
According to the Documentation BLOB/TEXT indeed cannot have default values. I am not sure why Doctrine thinks it has to set this default value.
The statements look like this:
I already reported this problem in the JMSPaymentCoreBundle Issue Queue where i then was referred to over here.
Also, i am not sure if Doctrine DBAL is the best match for this issue, so if it is wrong please move it to the right project issue queue.
Thank you very much and best of Regards!