Opened 18 years ago

Closed 17 years ago

Last modified 15 years ago

#252 closed defect (fixed)

query builder missing for PostGIS

Reported by: venturato@… Owned by: mhugent
Priority: major: does not work as expected Milestone:
Component: Data Provider Version: 0.8
Keywords: postgis query builder Cc:
Must Fix for Release: No Platform: Debian
Platform Version: etch Awaiting user input: no

Description

The (very useful) query builder for PostGIS layers does no longer show operators and examples. Only textual SQL queries are now possible. r5742

Attachments (2)

querybuilder.jpg (109.0 KB ) - added by venturato@… 18 years ago.
test-ticket-252.tar.gz (2.2 KB ) - added by wonder 17 years ago.
tiny test project

Download all attachments as: .zip

Change History (20)

comment:1 by g_j_m, 18 years ago

It shows them for me. Can you attach a screenshot to illustrate?

by venturato@…, 18 years ago

Attachment: querybuilder.jpg added

comment:2 by venturato@…, 18 years ago

Further testing: samples values are showed (correctly) when I choose the column name. Operators instead are not showed at all. I attached the screenshot.

comment:3 by g_j_m, 18 years ago

What version of qt is your version of qgis compiled against?

comment:4 by venturato@…, 18 years ago

# On the box where QGIS was compiled: lia@helo:~$ dpkg --list | grep qt | grep dev ii libqt4-dev 4.1.4-1 Qt 4 development files ii qt4-dev-tools 4.1.4-1 Qt 4 development tools

# On the box running QGIS: lia@helo:~$ ldd $(which qgis) | grep -i qt

libQtCore.so.4 => /usr/lib/libQtCore.so.4 (0xa7d3b000) libQt3Support.so.4 => /usr/lib/libQt3Support.so.4 (0xa7a51000) libQtGui.so.4 => /usr/lib/libQtGui.so.4 (0xa752c000) libQtNetwork.so.4 => /usr/lib/libQtNetwork.so.4 (0xa74d5000) libQtXml.so.4 => /usr/lib/libQtXml.so.4 (0xa7490000) libQtSvg.so.4 => /usr/lib/libQtSvg.so.4 (0xa744e000) libQtTest.so.4 => /usr/lib/libQtTest.so.4 (0xa743e000) libQtDesigner.so.4 => /usr/lib/libQtDesigner.so.4 (0xa72ca000) libQtSql.so.4 => /usr/lib/libQtSql.so.4 (0xa66b0000)

comment:5 by g_j_m, 18 years ago

Beats me. Is there anything you can do to the dialog box to make the operator appear? Could you try resizing the dialog box, etc?

comment:6 by venturato@…, 18 years ago

I tried resizing, open/closing the dialog box but nothing appened. I'm sorry.

comment:7 by wonder, 18 years ago

The same dialog is used also for creating queries when searching in attribute table. Please could you check whether also there are missing buttons for operators?

comment:8 by venturato@…, 18 years ago

Yes, it's the same.

comment:9 by cavallini@…, 17 years ago

On the windows preview2 version it works as expected

comment:10 by g_j_m, 17 years ago

Are they still missing when qgis is compiled against Qt 4.2.0?

comment:11 by cavallini@…, 17 years ago

Don't know. On Debian testing we still have 4.1.4-1.1

comment:12 by wonder, 17 years ago

Must Fix for Release: No

It seems that Debian has already Qt 4.2. Please could you retest?

Do you have a possibility to test on another computer to check whether it's a problem also somewhere else?

If you have still the same problem, could you try some older SVN revisions to help us find out where could be the problem?

Martin

by wonder, 17 years ago

Attachment: test-ticket-252.tar.gz added

tiny test project

comment:13 by wonder, 17 years ago

I've prepared a small project for testing. Download attached tarball (test-ticket-252.tar.gz) and extract it. In that directory try to run:

qmake
make
./test-ticket-252

(Make sure that you're using Qt4 qmake and that you have Qt4 development files)

When you run that compiled binary (test-ticket-252) you should get the postgis builder dialog. Please report whether the buttons are missing or not. If they're missing, the problem will be probably in UI file. If they're shown OK, we'll have to search for other sources of the problem.

comment:14 by cavallini@…, 17 years ago

Resolution: fixed
Status: newclosed

now it works (rev 6160)

comment:15 by luca.casagrande@…, 17 years ago

Resolution: fixed
Status: closedreopened

This problem happen on both some gentoo machine and a debian one. I tried the test app,deleting 1 button and then recreate it and it's showed. This problem disappear if use qt4.2.1 (at least on my machine).

comment:16 by anonymous, 17 years ago

AFAIK wgis requirers 4.2?

comment:17 by wonder, 17 years ago

Resolution: fixed
Status: reopenedclosed

Should be fixed in 6483 (0.8 branch) and 6484 (trunk).

comment:18 by (none), 15 years ago

Milestone: Version 0.8

Milestone Version 0.8 deleted

Note: See TracTickets for help on using tickets.