[Qgis-user] QGIS error & F29
Max Pyziur
pyz at brama.com
Tue Mar 12 07:23:14 PDT 2019
To add ... (see below)
On Tue, 12 Mar 2019, Max Pyziur wrote:
> 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.
When I add a PostGIS layer using the menus, and then edit the SQL, the Tab
in the SQL editing window is labelled "Layer"
When I try to build a Layer from the SQL editing window, execute the SQL,
then do all of the other clicks, including "Load As Layer" the tab
continues to be labelled "Query(TheNameOfTheDatabase)"
Thank you,
Max
> 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