search

Castronova / EMIT

Environmental Model Integration Project (EMIT)
GNU General Public License v2.0
0 stars 2 forks source link

ODM2 SQLite fails to load #412

Open Castronova opened 8 years ago

Castronova commented 8 years ago

The ODM2 local database fails to load in the TimeSeries tab

Traceback (most recent call last):
  File "C:\Users\Tony Castronova\Documents\EMIT\gui\views\LowerPanelView.py", line 125, in DbChanged
    self.OLVRefresh(event)
  File "C:\Users\Tony Castronova\Documents\EMIT\gui\views\LowerPanelView.py", line 328, in OLVRefresh
    value = self.refresh_database()
  File "C:\Users\Tony Castronova\Documents\EMIT\gui\views\LowerPanelView.py", line 272, in refresh_database
    session = dbconnection.createConnection(engine=db['args']['engine'], address=db['args']['address'])
TypeError: createConnection() takes exactly 6 arguments (3 given)
Castronova commented 8 years ago

The error above has been fixed, but we now have other issues.

2016-05-09 15:53:27,217 - [ERROR] ---  [C:\Users\Tony Castronova\Documents\EMIT\db\dbapi_v2.py, __init__ (line 71)] --- Encountered and error when attempting to load mod_spatialite: SQLError: The specified module could not be found.

I suggest that we remove spatial geometry representation in the SQLite database for now since it is causing so much trouble on Windows. We can re-add this as an enhancement for later. If we choose this route, geometries will be saved as WKT rather than Geometries.