Issue with new install and migrator

[siri...@gmail.com]

I have CFwheels insalled on a CF2018 server. I have the site and datasource set up. I can hit the initial wheels welcome screen. I created some scaffolding and when I look at the migrator in the admin window it says:

Database Error
Error Executing Database Query.

 I've tried to check what I know and I can't figure out why it is saying that. What am I missing here?

[Tom King]

I'm afraid we'll need a lot more information than that. Try turning on the more verbose error handling in the CF admin?

T

[Sebastien Fock-Chow-Tho]

Never seen this before. I'd try a few things:

- I'd append ?reload=true within the migrator page

- I'd check the datasource settings in the Lucee administration panel, making sure that you have the bare minimum access for Lucee

- I'd also check the database and make sure that it grants the proper access to your Lucee application

[siri...@gmail.com]

Sorry I am not seeing any errors at all in the CF administrator for this application. This is all the page says. Does cfwheels write logs out anywhere different?

[Tom King]

That just means it can't connect to your database (it tries to do simple lookup to work out if you've got any database migrations already applied). 
Check your database connectivity.
T

[siri...@gmail.com]

In the CF administrator I check the connection and returns OK in green. Is there anywhere in the cfwheels app where I need to tell it to use the CF server specifically? So far I have just put the datasource name in.

[Tom King]

Could possibly also mean it can't find a migrations table in your database.
T

[siri...@gmail.com]

Ahhh OK I got it. I checked the SQL server user permissions and it didn't have permissions to create the table. Once I tweaked that it connected. Thanks for your help.