[Qgis-user] QGIS error & F29

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
> 
> 
>