From owner-freebsd-questions@FreeBSD.ORG Sat May 12 00:42:37 2007 Return-Path: X-Original-To: freebsd-questions@freebsd.org Delivered-To: freebsd-questions@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [69.147.83.52]) by hub.freebsd.org (Postfix) with ESMTP id 749A016A415 for ; Sat, 12 May 2007 00:42:37 +0000 (UTC) (envelope-from danny@ricin.com) Received: from smtpq1.groni1.gr.home.nl (smtpq1.groni1.gr.home.nl [213.51.130.200]) by mx1.freebsd.org (Postfix) with ESMTP id 3AB7413C458 for ; Sat, 12 May 2007 00:42:37 +0000 (UTC) (envelope-from danny@ricin.com) Received: from [213.51.130.189] (port=43503 helo=smtp2.groni1.gr.home.nl) by smtpq1.groni1.gr.home.nl with esmtp (Exim 4.30) id 1Hmfgy-0002lz-87 for freebsd-questions@freebsd.org; Sat, 12 May 2007 02:42:36 +0200 Received: from cp464173-a.dbsch1.nb.home.nl ([84.27.214.242]:52180 helo=desktop.homenet) by smtp2.groni1.gr.home.nl with esmtp (Exim 4.30) id 1Hmfgu-00054Z-Cs for freebsd-questions@freebsd.org; Sat, 12 May 2007 02:42:32 +0200 From: Danny Pansters To: freebsd-questions@freebsd.org Date: Sat, 12 May 2007 02:41:29 +0200 User-Agent: KMail/1.9.6 References: <46447847.9030105@wilderness.homeip.net> <200705112244.41408.bramschoenmakers@xs4all.nl> In-Reply-To: <200705112244.41408.bramschoenmakers@xs4all.nl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200705120241.29260.danny@ricin.com> X-AtHome-MailScanner-Information: Please contact support@home.nl for more information X-AtHome-MailScanner: Found to be clean Subject: Re: STABLE + KEXI 1.1.2 (koffice 1.6.2) + KDE 3.5.6 = no sql? X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 12 May 2007 00:42:37 -0000 On Friday 11 May 2007 22:44:39 Bram Schoenmakers wrote: > Op vrijdag 11 mei 2007, schreef Drew Sanford: > > Hi, > > > I am using Kexi to track various things in my office, including time > > off. This works well because I can write queries for each employee > > showing me how much time they have requested off, etc. - however it > > appears that after a recent upgrade of all ports, which included a KDE > > update, SQL no longer works. For instance, I have a table called > > time_off that has many records in it, but even a simple query such as > > > > SELECT * FROM time_off; > > > > yields an empty result. Does anyone have any pointers on what it might > > take to get this working again? I have about 30 saved queries, none of > > them work any more. > > What kind of database? Native (SQLite), MySQL, Postgres? > > Kind regards, I think you should install the qt database(s) support you want via ports: qt-ibase-plugin qt-mysql-plugin qt-odbc-plugin qt-pgsql-plugin qt-sqlite-plugin qt4-ibase-plugin qt4-mysql-plugin qt4-odbc-plugin qt4-pgsql-plugin qt4-sql qt4-sqlite-plugin qt4-sqlite3-plugin All are in PORTSDIR/databases. Dan