[Qgis-user] QGIS error & F29

[DelazJ]

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?

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20190312/423656a1/attachment.html>