custom data type + schema updated

[jjbier]

I have created a custom data type "timestamp" but whe exec
"php app/console d:s:u --force" this comand reponse all time

Updating database schema...
Database schema updated successfully! "17" queries were executed

Can you help me?

[guilhermeblanco]

I think we require WAY more information than that.
For example, run your console command again with --dump-sql, together with your Type code on a Gist. That way, we can understand the problem and investigate if this is an issue of DBAL or your own code.
Here we track deficiencies of DoctrineBundle, not DBAL ones.

[jjbier]

Sorry for late answer,

• The data type is :
  https://gist.github.com/jjbier/8911690
• The mysqldump in one table the other 16 tables all equals in fiel timestamp
  https://gist.github.com/jjbier/8911730
  https://gist.github.com/jjbier/8918725
• The source code
  https://gist.github.com/jjbier/8911770

This error is how Level "warning"

The command "php app/console d:s:u --force" run correctly ,

But If I do not change the schema, and I run the command again this send:
"Database schema updated successfully! "17" queries were executed "

But It really does not change anything in the database.

[stof]

Well, the dumped SQL does not seem to indicate an issue related to your custom type: it is changing lots of columns, not only the timestamp ones

[fatganz]

I also have similar issue - My custom types are always updated.
"doctrine/doctrine-bundle" "version": "v1.2.0",

https://gist.github.com/fatganz/411ca82eec4e3c17de5e

[trsteel88]

Did anyone ever work out what is causing this issue? I'm getting this on my machine. Seems to be only when a table contains comments (e.g. "(DC2Type:datetime)").

This is only occurring for me in MariaDB 10.2.8. I removed this install and replaced it with MySQL 5.7.19 and it stopped the repetitive updates.

[Majkl578]

@trsteel88 In your case it'd possibly be the same issue as doctrine/orm#6565 / doctrine/dbal#2825?

[belgattitude]

@trsteel88

This is only occurring for me in MariaDB 10.2.8. I removed this install and replaced it with MySQL 5.7.19 and it stopped the repetitive updates.

Should be fixed with doctrine/dbal#2825

[lcobucci]

doctrine/dbal#2825 has just been merged and it will be released on DBAL v2.7.0, please test if your issue is fixed when using "doctrine/dbal": "2.7.x-dev@dev" and let us know.

[ostrolucky]

Closing for lack of feedback. I'm sure anyone reading this understands.