https://issues.qgis.org/https://issues.qgis.org/favicon.ico2016-11-26T04:09:06ZQGIS Issue TrackingQGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=734872016-11-26T04:09:06ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Open</i> to <i>Feedback</i></li></ul><p>I cannot confirm on either Windows and Linux, using the latest available versions of LTR. Is this still true for you?</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=734962016-11-28T06:12:37ZFrank Donnelly
<ul></ul><p>I just tried it again using 2.14.9 Essen on Linux - Linux Mint 17.3 (on Ubuntu 14.04 Trusty base) 64 bit - and I'm still getting the same Python error. I have also tried 2.14.9 on a 64-bit Windows 7 machine and did not get the error there.</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=738852017-01-02T09:34:38ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>It works fine here on 2.18.2 on the same platform. Could you test with 2.18.2 and/or with the latest ltr (2.14.10)?</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=740412017-01-08T09:38:20ZFrank Donnelly
<ul></ul><p>I just tried it again on the latest LTR - 2.14.10, on the same OS - Linux Mint 17.3 64 bit (on Ubuntu 14.04 Trusty base) and am still getting the same error - re-pasted below. I've also tried it on MS Windows and never had a problem - problem only seems to be on Linux.</p>
<p>I'll try 2.18 and see if it works - but I work in an academic environment and we only use the LTR versions there, and won't update until the next LTR comes out.</p>
<p>AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible' <br />Traceback (most recent call last):<br /> File "/usr/share/qgis/python/plugins/db_manager/db_manager.py", line 194, in runSqlWindow<br /> query = DlgSqlWindow(self.iface, db, self)<br /> File "/usr/share/qgis/python/plugins/db_manager/dlg_sql_window.py", line 73, in <i>init</i><br /> self.editSql.setMarginVisible(True)<br />AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible'</p>
<p>Python version: 2.7.6 (default, Oct 26 2016, 20:33:43) [GCC 4.8.4] <br />QGIS version: 2.14.10-Essen Essen, exported</p>
<p>Python Path:<br />/usr/share/qgis/python/plugins/processing<br />/usr/share/qgis/python<br />/home/USER/.qgis2/python<br />/home/USER/.qgis2/python/plugins<br />/usr/share/qgis/python/plugins<br />/usr/lib/python2.7<br />/usr/lib/python2.7/plat-x86_64-linux-gnu<br />/usr/lib/python2.7/lib-tk<br />/usr/lib/python2.7/lib-old<br />/usr/lib/python2.7/lib-dynload<br />/usr/local/lib/python2.7/dist-packages<br />/usr/lib/python2.7/dist-packages<br />/usr/lib/python2.7/dist-packages/PILcompat<br />/usr/lib/python2.7/dist-packages/gst-0.10<br />/usr/lib/python2.7/dist-packages/gtk-2.0<br />/usr/lib/pymodules/python2.7<br />/usr/lib/python2.7/dist-packages/ubuntu-sso-client<br />/usr/lib/python2.7/dist-packages/wx-2.8-gtk2-unicode<br />/home/USER/.qgis2//python<br />/usr/share/qgis/python/plugins/fTools/tools</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=740502017-01-08T22:18:46ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Frank Donnelly wrote:</p>
<blockquote>
<p>I just tried it again on the latest LTR - 2.14.10, on the same OS - Linux Mint 17.3 64 bit (on Ubuntu 14.04 Trusty base) and am still getting the same error - re-pasted below. I've also tried it on MS Windows and never had a problem - problem only seems to be on Linux.</p>
</blockquote>
<p>Linux or just Linux Mint with a specific DE (Cinnamon? Mate? else?). Can you test (maybe in a VM) if the same happens on other distributions or DEs?</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=741252017-01-12T04:03:41Zamedeo fadinifame@libero.it
<ul></ul><p>Just happened in 2.14.10 LTR on Ubuntu 14.04 (osgeolive9.5 with updates). Until yesterday it worked fine. Something related apt-get upgrade.</p>
<p>Traceback (most recent call last):<br /> File "/usr/share/qgis/python/plugins/db_manager/db_manager.py", line 194, in runSqlWindow<br /> query = DlgSqlWindow(self.iface, db, self)<br /> File "/usr/share/qgis/python/plugins/db_manager/dlg_sql_window.py", line 73, in <i>init</i><br /> self.editSql.setMarginVisible(True)<br />AttributeError: 'SqlEdit' object has no attribute 'setMarginVisible'</p>
<p>Versione Python: 2.7.6 (default, Oct 26 2016, 20:33:43) [GCC 4.8.4] <br />Versione di QGIS: 2.14.10-Essen Essen, exported</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=741272017-01-12T04:11:47ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>OS version</strong> deleted (<del><i>Mint 17.3</i></del>)</li><li><strong>Affected QGIS version</strong> changed from <i>2.14.5</i> to <i>2.14.10</i></li><li><strong>Priority</strong> changed from <i>Normal</i> to <i>Severe/Regression</i></li></ul><p>amedeo fadini wrote:</p>
<blockquote>
<p>Just happened in 2.14.10 LTR on Ubuntu 14.04 (osgeolive9.5 with updates). Until yesterday it worked fine. Something related apt-get upgrade.</p>
</blockquote>
<p>will give it a try then.</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=741312017-01-12T04:52:32Zamedeo fadinifame@libero.it
<ul></ul><p>Nope, <br />didn't found anything meaningful in apt-get and Synaptic history... (the upgrade was proposed by system)</p>
<p>I've got it working commenting line 73 in /usr/share/qgis/python/plugins/db_manager/dlg_sql_window.py</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=747142017-02-28T12:46:13ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>I really cannot replicate (on the same Linux platforms) this issue, anyway the new LTR is due very soon, and 2.14.* is unlikely to get any fix.<br />Please test 2.18.4 and see if there you have the same problem or not. Thanks!</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=750922017-03-08T02:01:10ZBernd Marcusbmarcus@giswana.de
<ul></ul><p>I had the same error message by trying to call the sql-editor with all QGIS 2.14 versions. An upgrade to 2.18.4 solved the problem on openSuse 42.1</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=750932017-03-08T02:03:17ZGiovanni Manghigiovanni.manghi@gmail.com
<ul></ul><p>Bernd Marcus wrote:</p>
<blockquote>
<p>I had the same error message by trying to call the sql-editor with all QGIS 2.14 versions. An upgrade to 2.18.4 solved the problem on openSuse 42.1</p>
</blockquote>
<p>Good. As 2.18 will be the next release, and that is due pretty soon, I'm not really sure that 2.14 will receive any fix/backport in the future, so my gues is that this ticket should be closed.</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=751362017-03-08T11:13:20ZFrank Donnelly
<ul></ul><p>Thanks for investigating this. In my environment I have to stick with an LTR release so I'll wait for the big 3.0 to come out. My work-around has been to use the database GUI's (pgAdmin or Spatialite GUI) and create spatial views whenever I need to visualize a query in QGIS.</p> QGIS Application - Bug report #15819: DB Manager SQL Window Not Launchinghttps://issues.qgis.org/issues/15819?journal_id=756122017-04-29T03:20:28ZGiovanni Manghigiovanni.manghi@gmail.com
<ul><li><strong>Status</strong> changed from <i>Feedback</i> to <i>Closed</i></li><li><strong>Resolution</strong> set to <i>wontfix</i></li></ul>