Bug#194634: marked as done (Unabled to list bookmarks, with PostgreSQL 7.3.2 )
Your message dated Sat, 10 Jul 2004 19:12:10 +0200
with message-id <20040710171210.GF1381@djpig.de>
and subject line Package removed
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 25 May 2003 12:09:33 +0000
>From djw@compsoc.dur.ac.uk Sun May 25 07:09:21 2003
Return-path: <djw@compsoc.dur.ac.uk>
Received: from bylands.dur.ac.uk (compsoc.dur.ac.uk) [129.234.2.55]
by master.debian.org with esmtp (Exim 3.35 1 (Debian))
id 19JuJU-0008W8-00; Sun, 25 May 2003 07:09:20 -0500
Received: from djw by compsoc.dur.ac.uk with local (Exim 3.35 #1 (Debian))
id 19JuJT-0006yo-00; Sun, 25 May 2003 13:09:19 +0100
Date: Sun, 25 May 2003 13:09:19 +0100
From: Dan Walrond <djw@compsoc.dur.ac.uk>
To: submit@bugs.debian.org
Subject: Unabled to list bookmarks, with PostgreSQL 7.3.2
Message-ID: <20030525120919.GA26329@compsoc.dur.ac.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.3.28i
X-Uptime: 00:31:39 up 1 day, 8:42, 17 users, load average: 0.15, 0.09, 0.10
Delivered-To: submit@bugs.debian.org
X-Spam-Status: No, hits=-12.3 required=4.0
tests=BAYES_01,HAS_PACKAGE,USER_AGENT_MUTT
autolearn=ham version=2.53-bugs.debian.org_2003_05_24
X-Spam-Level:
X-Spam-Checker-Version: SpamAssassin 2.53-bugs.debian.org_2003_05_24 (1.174.2.15-2003-03-30-exp)
Package: bookmarker
Version: 2.8.0-4
When trying to view http://localhost/bookmark/list.php3 I get the
following error
Warning: PostgresSQL query failed: ERROR: LIMIT #,# syntax not
supported. Use separate LIMIT and OFFSET clauses. in
/var/www/bookmark/lib/phplib/db_pgsql.inc on line 63
Database error: Invalid SQL: select category.name as category_name,
bookmark.category_id, subcategory.name as subcategory_name,
bookmark.subcategory_id, bookmark.id, bookmark.url, bookmark.name as
bookmark_name, bookmark.ldesc, bookmark.keywords, rating.name as
rating_name, bookmark.rating_id, bookmark.username from bookmark,
category, subcategory, rating where ( bookmark.category_id = category.id
and category.username = bookmark.username and bookmark.subcategory_id =
subcategory.id and subcategory.username = bookmark.username and
bookmark.rating_id = rating.id and rating.username = bookmark.username )
and ( bookmark.username = 'dan' ) order by category.name,
subcategory.name, bookmark.name, bookmark.id limit 10,51
PostgreSQL Error: 1 (ERROR: LIMIT #,# syntax not supported. Use separate
LIMIT and OFFSET clauses. )
Session halted.
This occured after the upgrade of PostgreSQL in Sarge to,
postgresql 7.3.2r1-5
No other features appear to be effected.
-Dan
---------------------------------------
Received: (at 194634-done) by bugs.debian.org; 10 Jul 2004 17:16:28 +0000
>From frank@lichtenheld.de Sat Jul 10 10:16:28 2004
Return-path: <frank@lichtenheld.de>
Received: from mail.sorgfalt.net [217.160.169.191]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1BjLSe-0000qW-00; Sat, 10 Jul 2004 10:16:28 -0700
Received: from p54817b73.dip.t-dialin.net ([84.129.123.115] helo=djpigpb.djpig.de)
by mail.sorgfalt.net with asmtp (Exim 4.34 1)
id 1BjLSd-0001pW-G9; Sat, 10 Jul 2004 19:16:27 +0200
Received: from djpig by djpigpb.djpig.de with local (Exim 3.36 #1 (Debian))
id 1BjLOZ-0004R7-00; Sat, 10 Jul 2004 19:12:15 +0200
Date: Sat, 10 Jul 2004 19:12:10 +0200
From: Frank Lichtenheld <djpig@debian.org>
To: 238000-done@bugs.debian.org, 189458-done@bugs.debian.org,
194634-done@bugs.debian.org, 251120-done@bugs.debian.org,
174475-done@bugs.debian.org
Subject: Package removed
Message-ID: <20040710171210.GF1381@djpig.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.6+20040523i
Sender: Frank Lichtenheld <frank@lichtenheld.de>
Delivered-To: 194634-done@bugs.debian.org
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
X-CrossAssassin-Score: 3
bookmarker was removed a while ago from unstable, so I close these bugs
now.
Gruesse,
--
Frank Lichtenheld <djpig@debian.org>
www: http://www.djpig.de/
Reply to: