Bez treści komunikatów nie jestem w stanie pomóc, a gdzie jest qgis?
Być może problem z biblioteką gdal (nieaktualna )...
Spisz zainstalowane wtyczki wyeksportuj adresy wms i wfs a następnie odinstaluj program później pobierz instalator qgis wersja osgeo i zainstaluj program...
Na razie tyle mogę pomóc...
Cześć,
Witam, pozwolę sobie napisać nowy post w tym temacie, ponieważ zauważyłem ten sam błąd w 3.4 i 3.4.1. Otóż korzystając z bazy spatialite poprzez "Bazy danych" i "Zarządzanie bazami danych" polecenie "Aktualizuj bazę SQL..." nie działa.
Generalnie coś chyba jest ogólnie nie tak z "Bazami danych" ponieważ, kiedy otwieram poprzednie swoje 'pola pracy' z warstwami spatialite z ustawionymi filtrami, otrzymuję komunikat, że warstwy są uszkodzone i wszystko trzeba ustawiać od zera.
Aktualizacja po sprawdzeniu 'pola pracy' z warstwami spatialite w Qgisie 2.18.25 - tutaj wszystko działa jak powinno. Problem tkwi w 3.4.
Poniżej przykładowe błędy pythona:
2018-11-05T17:10:09 WARNING Błąd SQLite podczas próby wstrzyknięcia ROWID:no such column: 2018_08_02 adresy.ROWID
SQL: SELECT ROWID FROM (SELECT "2018_08_02 adresy".ROWID, * FROM "2018_08_02 stali_spatial"
) as "subQuery_0" WHERE ROWID IS NOT NULL LIMIT 1
2018-11-05T17:10:09 WARNING Błąd SQLite: no such column: 2018_08_02 adresy.ROWID
SQL: select srid("geometry"), geometrytype("geometry") from (SELECT "2018_08_02 adresy".ROWID, * FROM "2018_08_02 stali_spatial"
) as "subQuery_0" WHERE "data_ur" 1958 limit 1
2018-11-05T17:10:09 WARNING Błąd SQLite podczas próby wstrzyknięcia ROWID:no such column: 2018_08_02 adresy.ROWID
SQL: SELECT ROWID FROM (SELECT "2018_08_02 adresy".ROWID, * FROM "2018-08-02_60minus"
) as "subQuery_0" WHERE ROWID IS NOT NULL LIMIT 1
2018-11-05T17:10:09 WARNING Błąd SQLite: no such column: 2018_08_02 adresy.ROWID
SQL: select srid("geometry"), geometrytype("geometry") from (SELECT "2018_08_02 adresy".ROWID, * FROM "2018-08-02_60minus"
) as "subQuery_0" limit 1
2018-11-05T17:10:09 WARNING Błąd SQLite podczas próby wstrzyknięcia ROWID:no such column: 2018_08_02_60plus_sami.ROWID
SQL: SELECT ROWID FROM (SELECT "2018_08_02_60plus_sami".ROWID, * FROM "2018-08-02_60plus_sami_l"
) as "subQuery_0" WHERE ROWID IS NOT NULL LIMIT 1
2018-11-05T17:10:09 WARNING Błąd SQLite: no such column: 2018_08_02_60plus_sami.ROWID
SQL: select srid("geometry"), geometrytype("geometry") from (SELECT "2018_08_02_60plus_sami".ROWID, * FROM "2018-08-02_60plus_sami_l"
) as "subQuery_0" limit 1
2018-11-05T17:10:09 WARNING Błąd SQLite podczas próby wstrzyknięcia ROWID:no such column: 2018_08_02 adresy.ROWID
SQL: SELECT ROWID FROM (SELECT "2018_08_02 adresy".ROWID, * FROM "2018-08-02_61plus"
) as "subQuery_0" WHERE ROWID IS NOT NULL LIMIT 1
2018-11-05T17:10:09 WARNING Błąd SQLite: no such column: 2018_08_02 adresy.ROWID
SQL: select srid("geometry"), geometrytype("geometry") from (SELECT "2018_08_02 adresy".ROWID, * FROM "2018-08-02_61plus"
) as "subQuery_0" limit 1
2018-11-05T17:10:51 WARNING Błąd SQLite: no such table: idx_2018_08_02 stali_spatial_geometry
SQL: SELECT "ROWID", AsBinary("geometry") FROM "2018_08_02 stali_spatial" WHERE "ROWID" IN (SELECT pkid FROM "idx_2018_08_02 stali_spatial_geometry" WHERE xmin = 6522484.67653362639248371 AND ymin = 5545601.73693221714347601)
przepraszam powyżej błędy Spatialite.
Python tutaj:
2018-11-05T17:10:44 WARNING Traceback (most recent call last):
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\db_manager\db_manager_plugin.py", line 96, in onUpdateSqlLayer
self.dlg.runSqlLayerWindow(l)
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\db_manager\db_manager.py", line 207, in runSqlLayerWindow
query = DlgSqlLayerWindow(self.iface, layer, self)
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\db_manager\dlg_sql_layer_window.py", line 167, in __init__
self.executeSql()
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\db_manager\dlg_sql_layer_window.py", line 262, in executeSql
self.lblResult.setText(self.tr("{0} rows, {1:.3f} seconds").format(model.affectedRows(), model.secs()))
ValueError: Single '}' encountered in format string
2018-11-05T17:10:01 WARNING warning:C:\PROGRA~1\QGIS3~1.4\apps\Python37\lib\site-packages\requests\status_codes.py:18: DeprecationWarning: invalid escape sequence \o
"""
traceback: File "", line 1, in
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 335, in startPlugin
plugins[packageName] = package.classFactory(iface)
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\MetaSearch\__init__.py", line 29, in classFactory
from MetaSearch.plugin import MetaSearchPlugin
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\MetaSearch\plugin.py", line 34, in
from MetaSearch.dialogs.maindialog import MetaSearchDialog
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python/plugins\MetaSearch\dialogs\maindialog.py", line 50, in
from owslib.csw import CatalogueServiceWeb # spellok
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:\PROGRA~1\QGIS3~1.4\apps\Python37\lib\site-packages\owslib\csw.py", line 27, in
from owslib.util import OrderedDict
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:\PROGRA~1\QGIS3~1.4\apps\Python37\lib\site-packages\owslib\util.py", line 32, in
import requests
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:\PROGRA~1\QGIS3~1.4\apps\Python37\lib\site-packages\requests\__init__.py", line 114, in
from .models import Request, Response, PreparedRequest
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 728, in exec_module
File "", line 219, in _call_with_frames_removed
File "C:\PROGRA~1\QGIS3~1.4\apps\Python37\lib\site-packages\requests\models.py", line 43, in
from .status_codes import codes
File "C:/PROGRA~1/QGIS3~1.4/apps/qgis/./python\qgis\utils.py", line 672, in _import
mod = _builtin_import(name, globals, locals, fromlist, level)
File "", line 983, in _find_and_load
File "", line 967, in _find_and_load_unlocked
File "", line 677, in _load_unlocked
File "", line 724, in exec_module
File "", line 860, in get_code
File "", line 791, in source_to_code
File "", line 219, in _call_with_frames_removed
Pewnie dalej błędy młodości trójeczki. Trzymajcie się LTR, po co przechodzicie na 3? Jest tam jakaś funkcjonalność Wam niezbędna? W lutym wyjdzie 3,4 LTR i wtedy pewnie większość problemów będzie rozwiązana (i wiele więcej przepisanych wtyczek).
Natomiast jeśli już wykryliście jakiś błąd i prawdopodobnie jest to wina programu, to skierujcie zgłoszenie tam gdzie potrzeba (do autorów), a nie tui na forum Dzięki temu może go naprawią, skoro go wykryliście - wszyscy zyskują.