From owner-freebsd-questions@FreeBSD.ORG Mon Feb 2 17:50:48 2004 Return-Path: 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 364CB16A4CE for ; Mon, 2 Feb 2004 17:50:48 -0800 (PST) Received: from ns1.tiadon.com (SMTP.tiadon.com [69.27.132.161]) by mx1.FreeBSD.org (Postfix) with ESMTP id A38FE43D3F for ; Mon, 2 Feb 2004 17:50:46 -0800 (PST) (envelope-from kdk@daleco.biz) Received: from daleco.biz ([69.27.131.0]) by ns1.tiadon.com with Microsoft SMTPSVC(6.0.3790.0); Mon, 2 Feb 2004 19:50:48 -0600 Message-ID: <401EFE37.2020407@daleco.biz> Date: Mon, 02 Feb 2004 19:49:43 -0600 From: "Kevin D. Kinsey, DaleCo, S.P." User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.5) Gecko/20031124 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=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 03 Feb 2004 01:50:48.0702 (UTC) FILETIME=[258329E0:01C3E9F8] 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 03 Feb 2004 01:50:48 -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: > > > Which page? > 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! > > This would probably be a great one for the folks at the phpbuilder.com forums. Before you head there, I'd suggest Googling for the error message, and also checking phpbb.org to see if this is a FAQ for PHPBB (IIRC, there is...) Obviously, some call is returning a value of negative one. This seems a tad unusual for PHP, which generally returns 1 on success, zero on failure. I doubt that PHPBB calls to system() or shell_exec(), so it's a little beyond me. On my PHPBB, line 152 is blank... but I'm not recalling what version I have, and I have multiple installations... Kevin Kinsey