From owner-freebsd-questions@FreeBSD.ORG Fri Jul 25 22:30:11 2014 Return-Path: Delivered-To: freebsd-questions@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 97DEABEF for ; Fri, 25 Jul 2014 22:30:11 +0000 (UTC) Received: from cyrus.watson.org (cyrus.watson.org [198.74.231.69]) by mx1.freebsd.org (Postfix) with ESMTP id 6DCC124BB for ; Fri, 25 Jul 2014 22:30:11 +0000 (UTC) Received: from fledge.watson.org (fledge.watson.org [198.74.231.63]) by cyrus.watson.org (Postfix) with ESMTPS id 6373A46B2A for ; Fri, 25 Jul 2014 18:30:10 -0400 (EDT) Received: from fledge.watson.org (doug@localhost.watson.org [127.0.0.1]) by fledge.watson.org (8.14.8/8.14.8) with ESMTP id s6PMUAAV078531 for ; Fri, 25 Jul 2014 18:30:10 -0400 (EDT) (envelope-from doug@fledge.watson.org) Received: from localhost (doug@localhost) by fledge.watson.org (8.14.8/8.14.8/Submit) with ESMTP id s6PMUAFD078528 for ; Fri, 25 Jul 2014 18:30:10 -0400 (EDT) (envelope-from doug@fledge.watson.org) Date: Fri, 25 Jul 2014 18:30:10 -0400 (EDT) From: doug Reply-To: doug@safeport.com To: freebsd-questions@FreeBSD.org Subject: pkgng question Message-ID: User-Agent: Alpine 2.11 (BSF 23 2013-08-11) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII X-Greylist: Sender IP whitelisted, not delayed by milter-greylist-4.4.3 (fledge.watson.org [127.0.0.1]); Fri, 25 Jul 2014 18:30:10 -0400 (EDT) X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 25 Jul 2014 22:30:11 -0000 I started with a 9.2-release system with xfce-4.10_5 plus related/needed other stuff and did the following: freebsd-update to 9.2-RELEASE-p10 #0; updated ports with portsnap; and finally installed pgk via pkg_add. So to try some things I did: 'pkg info' which looked okay; 'pkg check -d -n -a' returned no ouput, I figured no news was good news. For pkg stats I got: Local package database: Installed packages: 418 Disk space occupied: 1 GB Still cool. Then I tried 'pkg upgrade -n' and got 'Nothing to do' after several hundred of the following: "pkg: sqlite: near "ORDER": syntax error (pkgdb.c:3186)" probably 418 lines but written to SYSERROR so difficult to count. Several questions come to mind: 1) The system was build around Dec 2013, so I think 'nothing to do is probably not the right answer. 2) Are the sql errors correct? Probably because you can not order the null set but should be suppressed?? I am late to the game but I did scan PRs and questions before asking. An unrelated question. Everything I used seems to be there except for pkg_tree. Perhaps the need goes away but I would not expect an autoupdate of 418 packages to work after 7 months of no changes. pkg_tree was helpful in attacking upgrading in cases I did not want to delete all and start again. Thanks for any thoughts and/or guidence Doug