search

pyarchinit / pyarchinit

Official repository of pyArchInit since Python 3 porting
GNU General Public License v2.0
9 stars 9 forks source link

SCOMPARSO PYARCHINIT AL RIAVVIO MACCHINA V. 4.6.1 #569

Closed montarob closed 11 months ago

montarob commented 1 year ago

Buongiorno, sono andato ad aprire QGIS questa mattina dopo averci lavorato nei giorni a dietro e non si apre più pyArchinit. mi dà il seguente errore (ho provato anche a eliminare il config. e a riavviare ma l'errore persiste): Impossibile caricare il plugin 'pyarchinit-master' a causa di un errore chiamando il metodo classFactory()

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "MULTIPOLYGON": syntax error [SQL: CREATE TABLE pyunitastratigrafiche ( gid INTEGER NOT NULL, area_s INTEGER, scavo_s TEXT, us_s INTEGER, stratigraph_index_us INTEGER, tipo_us_s TEXT, rilievo_originale TEXT, disegnatore TEXT, data TEXT, tipo_doc TEXT, nome_doc TEXT, coord TEXT, the_geom geometry(MULTIPOLYGON,-1), unita_tipo_s TEXT, PRIMARY KEY (gid), CONSTRAINT "ID_us_unico_s" UNIQUE (gid) ) ] (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1802, in _execute_context self.dialect.do_execute( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\default.py", line 719, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: near "MULTIPOLYGON": syntax error

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 423, in _startPlugin plugins[packageName] = package.classFactory(iface) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master__init__.py", line 243, in classFactory from .pyarchinitPlugin import PyArchInitPlugin File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitPlugin.py", line 28, in from .pyarchinitDockWidget import PyarchinitPluginDialog File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitDockWidget.py", line 29, in from .tabs.Deteta import pyarchinit_Deteta File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\tabs\Deteta.py", line 34, in from ..modules.db.pyarchinit_db_manager import Pyarchinit_db_management File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_manager.py", line 44, in from modules.db.pyarchinit_db_mapper import US, UT, SITE, PERIODIZZAZIONE, POTTERY, \ File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_mapper.py", line 85, in from modules.db.structures.pyunitastratigrafiche import pyunitastratigrafiche File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\pyunitastratigrafiche.py", line 12, in class pyunitastratigrafiche: File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\pyunitastratigrafiche.py", line 45, in pyunitastratigrafiche metadata.create_all(engine) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\schema.py", line 4785, in create_all bind._run_ddl_visitor( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 3110, in _run_ddl_visitor conn._run_ddl_visitor(visitorcallable, element, kwargs) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 2113, in _run_ddl_visitor visitorcallable(self.dialect, self, kwargs).traverse_single(element) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\visitors.py", line 524, in traverse_single return meth(obj, kw) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\ddl.py", line 846, in visit_metadata self.traverse_single( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\visitors.py", line 524, in traverse_single return meth(obj, kw) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\ddl.py", line 890, in visit_table self.connection.execute( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1289, in execute return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\ddl.py", line 77, in _execute_on_connection return connection._execute_ddl( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1381, in _execute_ddl ret = self._execute_context( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1845, in _execute_context self._handle_dbapi_exception( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 2026, in _handle_dbapiexception util.raise( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\util\compat.py", line 207, in raise_ raise exception File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1802, in _execute_context self.dialect.do_execute( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\default.py", line 719, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "MULTIPOLYGON": syntax error [SQL: CREATE TABLE pyunitastratigrafiche ( gid INTEGER NOT NULL, area_s INTEGER, scavo_s TEXT, us_s INTEGER, stratigraph_index_us INTEGER, tipo_us_s TEXT, rilievo_originale TEXT, disegnatore TEXT, data TEXT, tipo_doc TEXT, nome_doc TEXT, coord TEXT, the_geom geometry(MULTIPOLYGON,-1), unita_tipo_s TEXT, PRIMARY KEY (gid), CONSTRAINT "ID_us_unico_s" UNIQUE (gid) )

] (Background on this error at: https://sqlalche.me/e/14/e3q8)

Versione Python: 3.9.5 (tags/v3.9.5:0a7dcbd, May 3 2021, 17:27:52) [MSC v.1928 64 bit (AMD64)] Versione di QGIS: 3.30.0-'s-Hertogenbosch 's-Hertogenbosch, f186b8efe0e

Percorso Python: C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\gui\ui C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\resources C:/OSGeo4W/apps/qgis/./python C:/Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python C:/Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins C:/OSGeo4W/apps/qgis/./python/plugins C:\OSGeo4W\bin\python39.zip C:\OSGeo4W\apps\Python39\DLLs C:\OSGeo4W\apps\Python39\lib C:\OSGeo4W\bin C:\OSGeo4W\apps\Python39 C:\OSGeo4W\apps\Python39\lib\site-packages C:\OSGeo4W\apps\Python39\lib\site-packages\win32 C:\OSGeo4W\apps\Python39\lib\site-packages\win32\lib C:\OSGeo4W\apps\Python39\lib\site-packages\Pythonwin C:/Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\qgis2web C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins

enzococca commented 1 year ago

Ciao, credo che tu abbia una versione non allineata anche se è scritto 4.6.1. prova a reinstallare pyarchinit e fammi sapere.questa parte qui è stata cambiata l'11 agosto 2023: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "MULTIPOLYGON": syntax error [SQL: CREATE TABLE pyunitastratigrafiche ( gid INTEGER NOT NULL, area_s INTEGER, scavo_s TEXT, us_s INTEGER, stratigraph_index_us INTEGER, tipo_us_s TEXT, rilievo_originale TEXT, disegnatore TEXT, data TEXT, tipo_doc TEXT, nome_doc TEXT, coord TEXT, the_geom geometry(MULTIPOLYGON,-1), unita_tipo_s TEXT, PRIMARY KEY (gid), CONSTRAINT "ID_us_unico_s" UNIQUE (gid) è il codice non è questo.

E

Il giorno ven 13 ott 2023 alle ore 10:30 montarob @.***> ha scritto:

Buongiorno, sono andato ad aprire QGIS questa mattina dopo averci lavorato nei giorni a dietro e non si apre più pyArchinit. mi dà il seguente errore (ho provato anche a eliminare il config. e a riavviare ma l'errore persiste): Impossibile caricare il plugin 'pyarchinit-master' a causa di un errore chiamando il metodo classFactory()

sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "MULTIPOLYGON": syntax error [SQL: CREATE TABLE pyunitastratigrafiche ( gid INTEGER NOT NULL, area_s INTEGER, scavo_s TEXT, us_s INTEGER, stratigraph_index_us INTEGER, tipo_us_s TEXT, rilievo_originale TEXT, disegnatore TEXT, data TEXT, tipo_doc TEXT, nome_doc TEXT, coord TEXT, the_geom geometry(MULTIPOLYGON,-1), unita_tipo_s TEXT, PRIMARY KEY (gid), CONSTRAINT "ID_us_unico_s" UNIQUE (gid) ) ] (Background on this error at: https://sqlalche.me/e/14/e3q8) Traceback (most recent call last): File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1802, in _execute_context self.dialect.do_execute( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\default.py", line 719, in do_execute cursor.execute(statement, parameters) sqlite3.OperationalError: near "MULTIPOLYGON": syntax error

The above exception was the direct cause of the following exception:

Traceback (most recent call last): File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 423, in

startPlugin plugins[packageName] = package.classFactory(iface) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master_init.py", line 243, in classFactory from .pyarchinitPlugin import PyArchInitPlugin File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitPlugin.py", line 28, in from .pyarchinitDockWidget import PyarchinitPluginDialog File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitDockWidget.py", line 29, in from .tabs.Deteta import pyarchinit_Deteta File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\tabs\Deteta.py", line 34, in from ..modules.db.pyarchinit_db_manager import Pyarchinit_db_management File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_manager.py", line 44, in from modules.db.pyarchinit_db_mapper import US, UT, SITE, PERIODIZZAZIONE, POTTERY, File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_mapper.py", line 85, in from modules.db.structures.pyunitastratigrafiche import pyunitastratigrafiche File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\pyunitastratigrafiche.py", line 12, in class pyunitastratigrafiche: File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\pyunitastratigrafiche.py", line 45, in pyunitastratigrafiche metadata.create_all(engine) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\schema.py", line 4785, in create_all bind._run_ddl_visitor( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 3110, in _run_ddl_visitor conn._run_ddl_visitor(visitorcallable, element, kwargs) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 2113, in _run_ddl_visitor visitorcallable(self.dialect, self, kwargs).traverse_single(element) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\visitors.py", line 524, in traverse_single return meth(obj, kw) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\ddl.py", line 846, in visit_metadata self.traverse_single( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\visitors.py", line 524, in traverse_single return meth(obj, kw) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\ddl.py", line 890, in visit_table self.connection.execute( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1289, in execute return meth(self, multiparams, params, _EMPTY_EXECUTION_OPTS) File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\sql\ddl.py", line 77, in _execute_on_connection return connection._execute_ddl( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1381, in _execute_ddl ret = self._execute_context( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1845, in _execute_context self.

handle_dbapi_exception( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 2026, in handle_dbapi_exception util.raise( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\util\compat.py", line 207, in raise raise exception File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\base.py", line 1802, in _execute_context self.dialect.do_execute( File "C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs\sqlalchemy\engine\default.py", line 719, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "MULTIPOLYGON": syntax error [SQL: CREATE TABLE pyunitastratigrafiche ( gid INTEGER NOT NULL, area_s INTEGER, scavo_s TEXT, us_s INTEGER, stratigraph_index_us INTEGER, tipo_us_s TEXT, rilievo_originale TEXT, disegnatore TEXT, data TEXT, tipo_doc TEXT, nome_doc TEXT, coord TEXT, the_geom geometry(MULTIPOLYGON,-1), unita_tipo_s TEXT, PRIMARY KEY (gid), CONSTRAINT "ID_us_unico_s" UNIQUE (gid) )

] (Background on this error at: https://sqlalche.me/e/14/e3q8)

Versione Python: 3.9.5 (tags/v3.9.5:0a7dcbd, May 3 2021, 17:27:52) [MSC v.1928 64 bit (AMD64)] Versione di QGIS: 3.30.0-'s-Hertogenbosch 's-Hertogenbosch, f186b8efe0e

Percorso Python: C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\gui\ui C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\resources C:/OSGeo4W/apps/qgis/./python C:/Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python C:/Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins C:/OSGeo4W/apps/qgis/./python/plugins C:\OSGeo4W\bin\python39.zip C:\OSGeo4W\apps\Python39\DLLs C:\OSGeo4W\apps\Python39\lib C:\OSGeo4W\bin C:\OSGeo4W\apps\Python39 C:\OSGeo4W\apps\Python39\lib\site-packages C:\OSGeo4W\apps\Python39\lib\site-packages\win32 C:\OSGeo4W\apps\Python39\lib\site-packages\win32\lib C:\OSGeo4W\apps\Python39\lib\site-packages\Pythonwin C:/Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins\pyarchinit-master\ext-libs C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\qgis2web C:\Users\Vision 2\AppData\Roaming\QGIS\QGIS3\profiles\default\python\plugins

— Reply to this email directly, view it on GitHub https://github.com/pyarchinit/pyarchinit/issues/569, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2P5KH5LC5AE5QISV7XODTX7D3Y7AVCNFSM6AAAAAA56ZGIBWVHI2DSMVQWIX3LMV43ASLTON2WKOZRHE2DCNBZGY2DANQ . You are receiving this because you are subscribed to this thread.Message ID: @.***>

-- Enzo Cocca PhD in "Science and Technology for Archaeology and Cultural Heritage"

ISMEO International Association of Mediterranean and Oriental Studies

mail: @.*** cell: +393495087014

montarob commented 1 year ago

Ho provato a fare questa cosa ma il problema sussiste

enzococca commented 1 year ago

Ma dovrebbe essere un altro errore

Il ven 13 ott 2023, 13:17 montarob @.***> ha scritto:

Ho provato a fare questa cosa ma il problema sussiste

— Reply to this email directly, view it on GitHub https://github.com/pyarchinit/pyarchinit/issues/569#issuecomment-1761272018, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2P5KCK3VOQUOQZYNMMCW3X7EILXAVCNFSM6AAAAAA56ZGIBWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONRRGI3TEMBRHA . You are receiving this because you commented.Message ID: @.***>

montarob commented 11 months ago

Buongiorno, avevamo risolto tale problema aggiornando la libreria geoalchemy2 da OSGeo, tuttavia, oggi riavviando il pc, di nuovo pyarchinit non si carica e mi da il seguente problema:

TypeError: Invalid argument(s) 'convert_unicode' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components. Traceback (most recent call last): File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 423, in _startPlugin plugins[packageName] = package.classFactory(iface) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master__init__.py", line 243, in classFactory from .pyarchinitPlugin import PyArchInitPlugin File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitPlugin.py", line 28, in from .pyarchinitDockWidget import PyarchinitPluginDialog File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitDockWidget.py", line 29, in from .tabs.Deteta import pyarchinit_Deteta File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\tabs\Deteta.py", line 34, in from ..modules.db.pyarchinit_db_manager import Pyarchinit_db_management File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_manager.py", line 44, in from modules.db.pyarchinit_db_mapper import US, UT, SITE, PERIODIZZAZIONE, POTTERY, \ File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_mapper.py", line 65, in from modules.db.structures.Campioni_table import Campioni_table File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\Campioni_table.py", line 11, in class Campioni_table: File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\Campioni_table.py", line 17, in Campioni_table engine = create_engine(internal_connection.conn_str(), echo=True, convert_unicode=True) File "", line 2, in create_engine File "C:\OSGeo4W\apps\Python39\lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned return fn(*args, **kwargs) # type: ignore[no-any-return] File "C:\OSGeo4W\apps\Python39\lib\site-packages\sqlalchemy\engine\create.py", line 680, in create_engine raise TypeError( TypeError: Invalid argument(s) 'convert_unicode' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

Versione Python: 3.9.5 (tags/v3.9.5:0a7dcbd, May 3 2021, 17:27:52) [MSC v.1928 64 bit (AMD64)] Versione di QGIS: 3.30.0-'s-Hertogenbosch 's-Hertogenbosch, f186b8efe0e

enzococca commented 11 months ago

Reinstalla pyarchinit

Il lun 23 ott 2023, 11:01 montarob @.***> ha scritto:

Buongiorno, avevamo risolto tale problema aggiornando la libreria geoalchemy2 da OSGeo, tuttavia, oggi riavviando il pc, di nuovo pyarchinit non si carica e mi da il seguente problema:

TypeError: Invalid argument(s) 'convert_unicode' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components. Traceback (most recent call last): File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 423, in

startPlugin plugins[packageName] = package.classFactory(iface) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master_init.py", line 243, in classFactory from .pyarchinitPlugin import PyArchInitPlugin File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitPlugin.py", line 28, in from .pyarchinitDockWidget import PyarchinitPluginDialog File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\pyarchinitDockWidget.py", line 29, in from .tabs.Deteta import pyarchinit_Deteta File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\tabs\Deteta.py", line 34, in from ..modules.db.pyarchinit_db_manager import Pyarchinit_db_management File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_manager.py", line 44, in from modules.db.pyarchinit_db_mapper import US, UT, SITE, PERIODIZZAZIONE, POTTERY, File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\pyarchinit_db_mapper.py", line 65, in from modules.db.structures.Campioni_table import Campioni_table File "C:\OSGeo4W/apps/qgis/./python\qgis\utils.py", line 888, in _import mod = _builtin_import(name, globals, locals, fromlist, level) File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\Campioni_table.py", line 11, in class Campioni_table: File "C:\Users/Vision 2/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\pyarchinit-master\modules\db\structures\Campioni_table.py", line 17, in Campioni_table engine = create_engine(internal_connection.conn_str(), echo=True, convert_unicode=True) File "", line 2, in create_engine File "C:\OSGeo4W\apps\Python39\lib\site-packages\sqlalchemy\util\deprecations.py", line 281, in warned return fn(*args, **kwargs) # type: ignore[no-any-return] File "C:\OSGeo4W\apps\Python39\lib\site-packages\sqlalchemy\engine\create.py", line 680, in create_engine raise TypeError( TypeError: Invalid argument(s) 'convert_unicode' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

Versione Python: 3.9.5 (tags/v3.9.5:0a7dcbd, May 3 2021, 17:27:52) [MSC v.1928 64 bit (AMD64)] Versione di QGIS: 3.30.0-'s-Hertogenbosch 's-Hertogenbosch, f186b8efe0e

— Reply to this email directly, view it on GitHub https://github.com/pyarchinit/pyarchinit/issues/569#issuecomment-1774634715, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2P5KC474HAQE7LXF5NK4DYAYP6VAVCNFSM6AAAAAA56ZGIBWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZUGYZTINZRGU . You are receiving this because you commented.Message ID: @.***>

montarob commented 11 months ago

Ho reinstallato pyarchinit, ho anche cancellato prima la cartella pyarchinit-master all'interno dei plugin di QGIS ma ho sempre lo stesso errore e non si installa più. TypeError: Invalid argument(s) 'convert_unicode' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

enzococca commented 11 months ago

lo fa solo con un pc oppure con tutti?

hai fatto qualche aggiornamento a sqlalchemy?

Il giorno lun 23 ott 2023 alle ore 13:33 montarob @.***> ha scritto:

Ho reinstallato pyarchinit, ho anche cancellato prima la cartella pyarchinit-master all'interno dei plugin di QGIS ma ho sempre lo stesso errore e non si installa più. TypeError: Invalid argument(s) 'convert_unicode' sent to create_engine(), using configuration SQLiteDialect_pysqlite/QueuePool/Engine. Please check that the keyword arguments are appropriate for this combination of components.

— Reply to this email directly, view it on GitHub https://github.com/pyarchinit/pyarchinit/issues/569#issuecomment-1774995041, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2P5KH3DAHFYIGDLMW4NALYAZIXLAVCNFSM6AAAAAA56ZGIBWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZUHE4TKMBUGE . You are receiving this because you commented.Message ID: @.***>

-- Enzo Cocca PhD in "Science and Technology for Archaeology and Cultural Heritage"

ISMEO International Association of Mediterranean and Oriental Studies

mail: @.*** cell: +393495087014

montarob commented 11 months ago

lo fa solo su un PC. Non ho fatto alcun aggiornamento.

enzococca commented 11 months ago

Cancella il file di config di pyarchinit e riavvia qgis

Il lun 23 ott 2023, 16:57 montarob @.***> ha scritto:

lo fa solo su un PC. Non ho fatto alcun aggiornamento.

— Reply to this email directly, view it on GitHub https://github.com/pyarchinit/pyarchinit/issues/569#issuecomment-1775265553, or unsubscribe https://github.com/notifications/unsubscribe-auth/AA2P5KAVNMPWE3UIFLRKGTTYAZZULAVCNFSM6AAAAAA56ZGIBWVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTONZVGI3DKNJVGM . You are receiving this because you commented.Message ID: @.***>

montarob commented 11 months ago

Ho provato a fare anche questa cosa ma ho comunque lo stesso problema. Anche cancellando il config. e riavviando

montarob commented 11 months ago

Ho provato sia ad reinstallare pyarchinit avviando qgis come amministratore, sia ad installarlo su un altro profilo, ma ottengo sempre lo stesso problema

montarob commented 11 months ago

Probabilmente tale problema è legato all'installazione/aggiornamento di QGIS tramite Osgeo, infatti, disinstallando QGIS e reinstallandolo come standalone ho risolto il problema.