PecanProject / pecan

The Predictive Ecosystem Analyzer (PEcAn) is an integrated ecological bioinformatics toolbox.
www.pecanproject.org
Other
202 stars 230 forks source link

Uninformative error when machine id isn't registered in BETY #3063

Open Aariq opened 1 year ago

Aariq commented 1 year ago

Bug Description

If the hostname in pecan.xml isn't registered in BETY, then prepare.settings() errors with the following:

Error in postgresqlExecStatement(conn, statement, ...) : 
  RPosgreSQL error: could not Retrieve the result : ERROR:  syntax error at or near ")"
LINE 7: WHERE ("machine_id" = )
                              ^

To Reproduce

Set hostname to something arbitrary, run prepare.settings()

Expected behavior

It should probably just register the hostname with BETY and print a message. If this should be an error, the error should explain next steps to the user

github-actions[bot] commented 10 months ago

This issue is stale because it has been open 365 days with no activity.