[imp] Database error (HordeDB): Invalid SQL: DELETE FROMactive_sessions WHERE changed < '20010228225321' AND name = 'HordeSession'

C.M. Rahman (jr.) cmrahman@ccsi.com
Sat, 3 Mar 2001 14:42:54 -0600


I am using the phplib that came with horde. I am using version imp 2.2.0
and horde 1.2.0.

The include_patch from phpinfo() is
.:/usr/local/phplib:/usr/local/etc/httpd/htdocs/webmail/horde

PHP Module Capabilities
IMAP Support: Yes
LDAP Support: No
MySQL Support: Yes
PostgreSQL Support: No

No error on reloading the test.php3 .  My OS is  Sun Solaris 7.

Thanks




&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&
C.M. Rahman
Network Engineer
CCS Internet
13740 Research Blvd. Suite O-4
Austin, TX 78758
cmrahman@ccsi.com
----- Original Message -----
From: Brent J. Nordquist <bjn@horde.org>
To: <imp@lists.horde.org>
Sent: Saturday, March 03, 2001 2:00 PM
Subject: Re: [imp] Database error (HordeDB): Invalid SQL: DELETE
FROMactive_sessions WHERE changed < '20010228225321' AND name =
'HordeSession'


> On Thu, 1 Mar 2001, C.M. Rahman (jr.) <cmrahman@ccsi.com> wrote:
>
> > Database error (HordeDB): Invalid SQL: DELETE FROM active_sessions WHERE
> > changed < '20010228225321' AND name = 'HordeSession'
>
> Let's start with the basics:  What version of Horde, IMP, Apache, PHP,
> database, IMAP server, etc. are you using?  Are you sure you are using the
> Horde-customized version of PHPLIB (horde/phplib directory in the
> tarball)?  Does the horde/test.php3 page show any errors (red items)?
> What does the test.php3 "phpinfo()" link say your include_path is, and
> does it include the horde/phplib directory?
>
> --
> Brent J. Nordquist <bjn@horde.org>
> Yahoo!: Brent_Nordquist / AIM: BrentJNordquist / ICQ: 76158942
>
>
> --
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
>



>From chuck@horde.org Date: Sat,  3 Mar 2001 16:11:29 -0500
Return-Path: <chuck@horde.org>
Mailing-List: contact imp-help@lists.horde.org; run by ezmlm
Delivered-To: mailing list imp@lists.horde.org
Received: (qmail 20538 invoked from network); 3 Mar 2001 21:12:30 -0000
Received: from 208-59-178-62.c3-0.smr-ubr1.sbo-smr.ma.cable.rcn.com (HELO marina.horde.org) (208.59.178.62)
  by horde.org with SMTP; 3 Mar 2001 21:12:30 -0000
Received: by marina.horde.org (Postfix, from userid 33)
	id 576153CA9; Sat,  3 Mar 2001 16:11:29 -0500 (EST)
Received: from 192.168.0.101 ( [192.168.0.101])
	as user chuck@marina.horde.org by marina.horde.org with HTTP;
	Sat,  3 Mar 2001 16:11:28 -0500
Message-ID: <983653888.3aa15e01041f3@marina.horde.org>
Date: Sat,  3 Mar 2001 16:11:29 -0500
From: Chuck Hagenbuch <chuck@horde.org>
To: imp@lists.horde.org
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
User-Agent: Internet Messaging Program (IMP) 2.3.7-cvs
Subject: Re: [imp] Undefined index: contact in ...

Quoting The Hermit Hacker <scrappy@hub.org>:

> Okay, quickly moving forward with this ... main URL displays the Horde
> login, and lets me go to 'IMP' ... IMP let's me login to my IMAP server,
> and displays my mailboxes ... but displays the following two errors at the
> top of my screen:
> 
> Warning: Undefined index: contact in
> /usr/local/apache/horde/imp/../lib/Registry.php on line 61
[snip]
> $this->registry['mail']['compose'] = 'imp';
> //$this->registry['contact']['search'] = 'turba';
> //$this->registry['net']['finger'] = 'nic';

I've just removed the allow_directory_search config item, and put in some 
checks that keep errors like the above from happening. Now if you don't have a 
contact manager defined in the registry, the contacts link won't show up.

-chuck

--
Charles Hagenbuch, <chuck@horde.org>
"We have no fuel on board, plus or minus 8 kilograms." -A NASA scientist