search

nens / threedi-api-qgis-client

3Di Models & Simulations plugin
https://plugins.lizard.net/
Other
2 stars 0 forks source link

Import Surfhyd algorithm not compatible with current threedi schema #595

Closed Overmeen closed 1 month ago

Overmeen commented 1 month ago

The 'Import Surfhyd' algorithm seems not compatible with the current database schema. It is expecting a field value that no longer exists.

Reported by a user, his .hyd file: https://we.tl/t-kFjZunId3t

Traceback: File "C:\Users\Stijn.Overmeen\AppData\Roaming\3Di\QGIS3\profiles\default\python\plugins\threedi_results_analysis\deps\sqlalchemy\engine\default.py", line 745, in do_executemany cursor.executemany(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) table v2_orifice has no column named max_capacity [SQL: INSERT INTO v2_orifice (code, display_name, connection_node_start_id, connection_node_end_id, crest_type, crest_level, cross_section_definition_id, discharge_coefficient_positive, discharge_coefficient_negative, sewerage, max_capacity) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: [(' _062325 - _062317 -2', ' _062325 - _062317 -2', 5796, 5792, 4, 16.1, 6, 0.0, 0.0, 1, 0.0), (' _108360 - _108340 -1', ' _108360 - _108340 -1', 10105, 10103, 4, 20.65, 64, 0.0, 0.0, 1, 0.0)]] (Background on this error at: https://sqlalche.me/e/20/e3q8)

Overmeen commented 1 month ago

moved to correct repo: https://github.com/nens/ThreeDiToolbox/issues/1030