title: Detected failed migration to version Flyway
body: <p>I added a sql file to my project and now I am receiving the following error:</p>
  
  <blockquote>
    <p>nested exception is org.flywaydb.core.api.FlywayException: Validate failed: Detected failed migration to version 1.0.9 (update)</p>
  </blockquote>
  
  <p>Here is my sql file I'm adding:</p>
  
  <pre><code>ALTER TABLE `episodes`
  ADD COLUMN `rating` TINYINT(1) NULL DEFAULT NULL;
  </code></pre>
  
  <p>I added the same query to MySQL Workbench and it's working fine, so I think the error here is beyond the sql file added</p>
  
  <p>UPDATE: full stack trace below</p>
  
  <pre><code>org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.api.FlywayException: Validate failed: Detected failed migration to version 1.0.9 (update)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1708)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:581)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:503)
  at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:317)
  at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
  at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:304)
  at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:199)
  at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1089)
  at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:859)
  at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550)
  at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:140)
  at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:759)
  at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:395)
  at org.springframework.boot.SpringApplication.run(SpringApplication.java:327)
  at org.springframework.boot.SpringApplication.run(SpringApplication.java:1255)
  at org.springframework.boot.SpringApplication.run(SpringApplication.java:1243)
  at com.nbcuni.cds.Application.main(Application.java:12)
  Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Detected failed migration to version 1.0.9 (update)
  at org.flywaydb.core.Flyway.doValidate(Flyway.java:1286)
  at org.flywaydb.core.Flyway.access$100(Flyway.java:71)
  at org.flywaydb.core.Flyway$1.execute(Flyway.java:1176)
  at org.flywaydb.core.Flyway$1.execute(Flyway.java:1168)
  at org.flywaydb.core.Flyway.execute(Flyway.java:1655)
  at org.flywaydb.core.Flyway.migrate(Flyway.java:1168)
  at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1767)
  at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1704)
  ... 18 common frames omitted
  </code></pre>
  
  <blockquote>
    <p>UPDATE: When I run mvn:flyway-validate, I receive the following error:</p>
  </blockquote>
  
  <pre><code>org.flywaydb.core.api.FlywayException: Unable to connect to the database. Configure the url, user and password! 
  </code></pre>
  
  <blockquote>
    <p>I'm not sure where to configure it? It's already set in my applications.properties file? And w/o this version the spring application is working fine  </p>
  </blockquote>