Build failure trying to run localhost in sagan-site

[lukzhang]

I'm on Windows and followed the apparent fix: #979 (comment)

Now, when I run sagan-site/SiteApplication I get essentially what seems to be SQL script errors:
Caused by: org.flywaydb.core.internal.command.DbMigrate$FlywayMigrateException:
Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException:
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "ALTER TABLE PROJECT_SAMPLE MODIFY[*] TITLE VARCHAR(255) NOT NULL"; expected "., ADD, SET, RENAME, DROP, ALTER"; SQL statement:

logfile.txt

[shree675]

@lukzhang For me, replacing MODIFY with ALTER keyword worked on Windows.

The file name is ./sagan-site\src\main\resources\db\migration\V5__project_refactoring.sql. That is where the error is coming from. I replaced the three lines to the following:

ALTER TABLE project_sample ALTER title VARCHAR(255) NOT NULL;
ALTER TABLE project_sample ALTER url VARCHAR(255) NOT NULL;
ALTER TABLE project_sample ALTER description VARCHAR(255) NOT NULL;