From owner-freebsd-questions@FreeBSD.ORG  Mon Feb  2 18:25:27 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id B580A16A4CE
	for <freebsd-questions@freebsd.org>;
	Mon,  2 Feb 2004 18:25:27 -0800 (PST)
Received: from tromso-dhcp-235-56.bluecom.no (tromso-dhcp-235-56.bluecom.no
	[62.101.235.56])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 0839343D39
	for <freebsd-questions@freebsd.org>;
	Mon,  2 Feb 2004 18:25:26 -0800 (PST)
	(envelope-from lists@jonepet.net)
Received: from localhost (localhost.jonepet.net [127.0.0.1])
	by tromso-dhcp-235-56.bluecom.no (Postfix) with ESMTP
	id CB58A729; Tue,  3 Feb 2004 03:26:31 +0100 (CET)
Received: from tromso-dhcp-235-56.bluecom.no ([127.0.0.1])
 by localhost (discovery.jonepet.net [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 15061-09; Tue,  3 Feb 2004 03:26:31 +0100 (CET)
Received: from jonepet.net (unknown [10.2.33.5])
	by tromso-dhcp-235-56.bluecom.no (Postfix) with ESMTP
	id 85A5D71B; Tue,  3 Feb 2004 03:26:31 +0100 (CET)
Message-ID: <401F0691.90703@jonepet.net>
Date: Tue, 03 Feb 2004 03:25:21 +0100
From: Jon-Eirik Pettersen <lists@jonepet.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.6b) Gecko/20031205 Thunderbird/0.4
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: ecrist@adtechintegrated.com
References: <200402021436.24242.ecrist@adtechintegrated.com>
In-Reply-To: <200402021436.24242.ecrist@adtechintegrated.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at jonepet.net
cc: freebsd-questions@freebsd.org
Subject: Re: phpBB problems with mysql? [OT?]
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 03 Feb 2004 02:25:27 -0000

Eric F Crist wrote:

>This may be a little off-topic, if so, I apologize.  I'm running phpBB2 on my 
>webserver.  I finally got it working, and it's been great since Friday.  This 
>afternoon, when I try to load the page, I get the following error:
>
> phpBB : Critical Error 
>
> Error creating new session
>
>DEBUG MODE
>
>SQL Error : 1062 Duplicate entry '-1' for key 2
>
>INSERT INTO phpbb_sessions (session_id, session_user_id, session_start, 
>session_time, session_ip, session_page, session_logged_in) VALUES 
>('8f431818aa903b05979098a737674ac3', -1, 1075754200, 1075754200, '3fe40ef5', 
>0, 0)
>
>Line : 152
>File : /www/seccomp/htdocs/phpBB2/includes/sessions.php 
>
>Does anyone have any suggestions?  Thanks!
>  
>
Try to empty the "phpbb_sessions"-table, (DELETE FROM phpbb_sessions). 
Remember to back it up first.