Re: [Qgis-user] QGIS error & F29

Tue, 12 Mar 2019 07:23:39 -0700 

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 <[email protected]> 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
      >>> [email protected]
      >>> _______________________________________________
      >>> Qgis-user mailing list
      >>> [email protected]
      >>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
      >>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
      >>
      >> _______________________________________________
      >> Qgis-user mailing list
      >> [email protected]
      >> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
      >> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
      >>
      >
      > _______________________________________________
      > Qgis-user mailing list
      > [email protected]
      > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
      > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
      >_______________________________________________
      Qgis-user mailing list
      [email protected]
      List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
      Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



_______________________________________________
Qgis-user mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Reply via email to