[DBAL-157] Exception given when updating schema Created: 22/Aug/11  Updated: 18/Nov/11  Resolved: 18/Nov/11

Status: Resolved
Project: Doctrine DBAL
Component/s: Schema Managers
Affects Version/s: None
Fix Version/s: 2.1.5

Type: Bug Priority: Minor
Reporter: Chris Assignee: Benjamin Eberlei
Resolution: Fixed Votes: 1
Labels: None
Environment:

Mac OSX 10.6.7
PHP 5.3.4



 Description   

Been experimenting with Symfony2 past days, and somehow managed to generate an Exception in the MySqlSchemaManager Classes of Doctrine.

I've build my schema once, the next time i run the command i'm receiving following error:

[ErrorException]
Notice: Undefined index: default in /Users/chris/Sites/Symfony/vendor/doctrine-dbal/lib/Doctrine/DBAL/Schema/MySqlSchemaManager.php line 157

i can't figure out an error in my classes.

When i drop the database table, i can re-run the command again without exception.. even though another run it will throw it up again.

I've checked the code in line #157, and adpted it slightls:

prev:

'default' => $tableColumn['default'],

modified:
'default' => (isset($tableColumn['default'])) ? $tableColumn['default'] : null,

Can anyone confirm this issue?

Greetings,
Chris



 Comments   
Comment by Chris K [ 25/Sep/11 ]

Hi, I'm also seeing this exact issue using Sf2 and Doctrine. You can't use the console to force update the schema, you have to completely drop all of the tables to get the command to work again. Also using Mac locally.

Comment by Benjamin Eberlei [ 18/Nov/11 ]

Interesting that some MySQL versions dont seem to have the default field then in information_schema?

Comment by Benjamin Eberlei [ 18/Nov/11 ]

Fixed, will be in 2.1.4

Generated at Mon Dec 22 05:39:31 UTC 2014 using JIRA 6.2.3#6260-sha1:63ef1d6dac3f4f4d7db4c1effd405ba38ccdc558.