[Qgis-user] QGIS error & F29

[Max Pyziur]

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

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
>