Hello,
I started working on my project and all of...
# box-productso
Ookma-Kyi
09/27/2022, 6:38 PMHello,
I started working on my project and all of a sudden I am getting this error:
Copy code
CommandBox> migrate install
ERROR (5.5.2+00578)
Invalid Syntax Closing [}] not found
\modules\commandbox-migrations\models\BaseMigrationCommand.cfc: line 88
86: // Check and see if a .cfmigrations.json file exists
87: if ( fileExists( "#directory#/.cfmigrations.json" ) ) {
88: variables.cfmigrationsInfo = deserializeJSON( fileRead( "#directory#/.cfmigrations.json" ) );
89: variables.systemSettings.expandDeepSystemSettings( variables.cfmigrationsInfo );
90: variables.cfmigrationsInfoType = "cfmigrations";
called from \modules\commandbox-migrations\models\BaseMigrationCommand.cfc: line 11
called from \modules\commandbox-migrations\commands\migrate\install.cfc: line 15
called from \system\services\CommandService.cfc: line 443
called from \system\services\CommandService.cfc: line 225
called from \system\Shell.cfc: line 819
called from \system\Shell.cfc: line 634
called from \system\Bootstrap.cfm: line 160
To enable full stack trace, run config set verboseErrors=trueinstallmigrate initmigrate installmigrate downmigrate upb
bdw429s
09/27/2022, 6:42 PM@Ookma-Kyi According to the error, your
.cfmigrations.jsonbdw429s
09/27/2022, 6:42 PMFix it and I assume you're error will go away!
bdw429s
09/27/2022, 6:42 PMI'm unclear why you tried running all those commands when the error clearly showed the deserializing of the JSON file was the issue.
o
Ookma-Kyi
09/27/2022, 6:42 PM@bdw429s It's being created automatically when I run
migrate initb
bdw429s
09/27/2022, 6:42 PMI assume it will continue to error for as along as the JSON is invalid
bdw429s
09/27/2022, 6:43 PMIf you want the error to go away, you will need to
• identify why the JSON is wrong
• fix it
bdw429s
09/27/2022, 6:43 PMAnd if the wrong JSON was auto-created for you, then I would enter a ticket with the steps to reproduce it
bdw429s
09/27/2022, 6:44 PMI'm not sure why you're showing me screenshots
bdw429s
09/27/2022, 6:44 PMLook in the actual JSON file and find the syntax error
bdw429s
09/27/2022, 6:44 PMThat is your fix here
bdw429s
09/27/2022, 6:44 PMNot showing screenshots of the error that we've already discussed
o
Ookma-Kyi
09/27/2022, 6:44 PMshowing you the commands I'm running
Ookma-Kyi
09/27/2022, 6:45 PMTo show I'm not creating the file myself
b
bdw429s
09/27/2022, 6:45 PMlol, that's great, but it doesn't change anything I've already said
o
Ookma-Kyi
09/27/2022, 6:45 PMand yea the auto-generator is broken
b
bdw429s
09/27/2022, 6:45 PM• find the bad JSON
• fix the bad JSON
• enter a ticket with steps to re-create the bad JSON
bdw429s
09/27/2022, 6:45 PMStart with bullet #1
bdw429s
09/27/2022, 6:46 PMI don't really use migrations myself so the commands don't mean anything to me personally. You can include those details in your ticket.
bdw429s
09/27/2022, 6:46 PMI'm just telling you based on the error what the issue is
o
Ookma-Kyi
09/27/2022, 6:47 PMHow do you do database stuff then?
Ookma-Kyi
09/27/2022, 6:48 PMFound the error and fixed it. Now it works. Thanks! How do I open a ticket?
b
bdw429s
09/27/2022, 6:51 PMI would assume in the Github repo, which is linked to from the ForgeBox listing
https://github.com/commandbox-modules/commandbox-migrations/issues
o
Ookma-Kyi
09/27/2022, 7:15 PMb
bdw429s
09/27/2022, 7:19 PMCool, thx 👍
bdw429s
09/27/2022, 7:20 PMCC/ @elpete