[Qgis-user] QGIS error & F29
Max Pyziur
pyz at brama.com
Tue Mar 12 07:12:58 PDT 2019
On Tue, 12 Mar 2019, DelazJ wrote:
> Hi,
>
> Le mar. 12 mars 2019 à 14:55, Max Pyziur <pyz at brama.com> a écrit :
> On Tue, 12 Mar 2019, Richard Duivenvoorde wrote:
>
> > Ah...
> >
> > Now I see 2.7 ????
> > That is very old, please upgrade to the one available via
> > https://qgis.org/en/site/forusers/alldownloads.html#fedora
>
> Much thanks for your replies.
>
> I've done this, but this has led to another issue. Either it's a bug or
> I'm not executing something correctly (clicking checkboxes etc.
>
> If I go Database -> DB Manager
> Establish a connection to my postgresql/postgis database
>
> F2 to open the SQL editing window, type:
> SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'
>
> Hit Execute, Load As layer
>
>
> At this point, the dialog expands new options in which you may need to indicate the PK and the geometry fields.
> And then press on "Load" to have layer and features in the application.
>
> Are these options not visible? Or do you simply skip these steps in your feedback?
I do all of these things:
insert a SQL statement:
SELECT * FROM "shapefiles"."us_states"
Click "Execute"
The results appear
Click "Load As New Layer"
Check "Column(s) with unique values"
Click "Retrieve Values"
Add a layer name in the appropriate window
Click "Load"
And nothing shows up.
But if I go to the Layer -> Add Layer -> Add postgis layers
It loads appropriately from a table containing shapefile data.
I can then edit the SQL foundation of that layer, something like
SELECT * FROM "shapefiles"."us_states"
adding
SELECT * FROM "shapefiles"."us_states" WHERE state = 'Texas'
and the results are
reflected.
I've been using QGIS since 2012, and this is a first for me.
Max
> Harrissou
>
> Nothing appears in either the Layers pane or the main window.
>
> However, if I go
> Layer -> Add Layer -> Add PostGIS Layers
>
> and then select a table built upon a shapefile
>
> the map loads.
>
> I can then edit the SQL for that layer by right-clicking on the layer in
> the layer pane, Update sql, and my modifications are reflected in the
> layer.
>
> How do I get DB Manager to add a layer?
>
> Much thanks,
>
> Max Pyziur
>
>
> > Regards,
> >
> > Richard Duivenvoorde
> >
> >
> > On 12/03/2019 07.08, Richard Duivenvoorde wrote:
> >> Hi Max,
> >>
> >> The error means that the python-cpp bridge is not working because wrong
> >> paths to (python) libs.
> >> Are you maybe in a Python Virtual Environment at that moment, which in
> >> that case screws up your python path?
> >>
> >> Or else: did you miss some QGIS-Python package (if installed via package
> >> manager)?
> >>
> >> Regards,
> >>
> >> Richard Duivenvoorde
> >>
> >> On 11/03/2019 23.15, Max Pyziur wrote:
> >>>
> >>>
> >>> Greetings,
> >>>
> >>> My use of QGis Desktop is occassional; when I do use it, I construct
> >>> layers using PostGIS & PostgreSQL.
> >>>
> >>> The key component that facilitates this in QGis is a Python plugin
> >>> called DB Manager.
> >>>
> >>> When I started Qgis today, there was an error message that appeared
> >>> something like this:
> >>>
> >>> Couldn't load PyQGIS. Python support will be disabled.
> >>>
> >>>
> >>> Traceback (most recent call last):
> >>> File "", line 1, in
> >>> File "/usr/lib64/python2.7/site-packages/qgis/gui/__init__.py", line
> >>> 27, in
> >>> from qgis._gui import *
> >>> RuntimeError: the PyQt4.QtCore module failed to register with the sip
> >>> module
> >>>
> >>>
> >>> Python version:
> >>> 2.7.15 (default, Oct 15 2018, 15:26:09)
> >>> [GCC 8.2.1 20180801 (Red Hat 8.2.1-2)]
> >>>
> >>> QGIS version:
> >>> 2.18.20 'Las Palmas', exported
> >>>
> >>> After clicking away the error away, the existing layers that I had built
> >>> using PostGIS/PostgreSQL were still available in my key critical project.
> >>>
> >>> However, when I went to look for DB Manager, it wasn't available.
> >>>
> >>> After some searching, I upgraded to QGIS 3.6 from a non-Fedora
> >>> repository (the guidance is here:
> >>> https://stackoverflow.com/questions/53716778/the-pyqt4-qtcore-module-failed-to-register-with-the-sip-module)
> >>>
> >>>
> >>> and now I have access to the DB Manager functionality.
> >>>
> >>> Is the Fedora/QGis community aware of this issue?
> >>>
> >>> Thanks!
> >>>
> >>> Max Pyziur
> >>> pyz at brama.com
> >>> _______________________________________________
> >>> Qgis-user mailing list
> >>> Qgis-user at lists.osgeo.org
> >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org
> >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >>
> >
> > _______________________________________________
> > Qgis-user mailing list
> > Qgis-user at lists.osgeo.org
> > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
> >_______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
More information about the Qgis-user
mailing list