Re: [Phpgroupware-developers] E-Mail in version 0.9.14.002

[Ralf Becker]

Bob Crandell wrote:
> Hi,
>
> I was finally able to get this error again.  It was while trying to open the
> phpGroupware folder which has 6264 messages.
>
> Database error: Invalid SQL: UPDATE phpgw_app_sessions SET
> content='a:2:{s:12:\"msgball_list\";a:6264:{i:0;a:4:{s:6:\"msgnum\";i:349;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=349&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:1;a:4:{s:6:\"msgnum\";i:351;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=351&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:2;a:4:{s:6:\"msgnum\";i:352;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=352&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:3;a:4:{s:6:\"msgnum\";i:353;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=353&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:4;a:4:{s:6:\"msgnum\";i:354;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\
"!
> ;s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=354&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:5;a:4:{s:6:\"msgnum\";i:355;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=355&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:6;a:4:{s:6:\"msgnum\";i:356;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=356&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:7;a:4:{s:6:\"msgnum\";i:357;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=357&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:8;a:4:{s:6:\"msgnum\";i:358;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=358&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\"
;!
> }i:9;a:4:{s:6:\"msgnum\";i:359;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=359&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:10;a:4:{s:6:\"msgnum\";i:365;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=365&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:11;a:4:{s:6:\"msgnum\";i:363;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=363&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:12;a:4:{s:6:\"msgnum\";i:360;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=360&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:13;a:4:{s:6:\"msgnum\";i:364;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:
\!
> "msgball[msgnum]=364&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:14;a:4:{s:6:\"msgnum\";i:362;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=362&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:15;a:4:{s:6:\"msgnum\";i:361;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=361&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:16;a:4:{s:6:\"msgnum\";i:366;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=366&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:17;a:4:{s:6:\"msgnum\";i:367;s:6:\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgball[msgnum]=367&msgball[folder]=mail%2FListServe%2FphpGroupware&msgball[acctnum]=0\";}i:18;a:4:{s:6:\"msgnum\";i:368;s:
6!
> :\"folder\";s:31:\"mail%2FListServe%2FphpGroupware\";s:7:\"acctnum\";i:0;s:3:\"uri\";s:86:\"msgb

The next line would be the interesting one, as it gives the error and 
the kind db (mysql, pgSql) you use.

I would guess it says pgSql is the value to big/long for a field of type 
text and your pgSql version in not very up to date.

Ralf

> Nothing else has been upgraded yet.  I did a CVS update, went to 
> /phpgroupware/setup
> and upgraded phpgwapi and went to Administration/Site Configuration to make 
> sure all
> my settings were still there.  I did submit it even though there were no 
> changes.
>
> My client is supposed to be cleaning out their INBOXes to eliminate that as a
> possible source of error.  I'll check with them later today when they start 
> moving
> around and see if that helped.
>
> Thanks.
>
> Chris Weiss (address@hidden) wrote:
>
> > was anything else upgraded on the server? mysql or the imap server or anything?
> > the lib versions php is using for these are very picky and will cause apache the
> > segfault if you upgrade the server and not the php module.
> >
> > Bob Crandell (address@hidden) wrote:
> >
> > > I forgot to look there and what do you know there is a segfault.
> > >
> > > [Tue Mar 25 17:40:49 2003] [notice] child pid 29000 exit signal Segmentation 
> > > fault
> >
> > (11)
> >
> > > This is repeated alot with different pid numbers.
> > >
> > > Thanks
> > >
> > > Chris Weiss (address@hidden) wrote:
> > >
> > > > anything in the apache error logs?  typicaly no data means the apache child
> >
> > segfaulted.
> >
> > > > Bob Crandell (address@hidden) wrote:
> > > >
> > > > > The actual error message sometimes is "Page contains no data".  Sometimes it's 
> > > > > an
> > > > > SQL Select error.  I didn't write it down.  Sometimes it works.  This is all 
> > > > > with
> > > > > the same account.
>
>
> > > > > Thanks
> > > > >
> > > > > Chris Weiss (address@hidden) wrote:
> > > > >
> > > > > > > So I'm looking for confirmation.  Have them clean their INBOX out and their
> > > > > > > problems will go away?
> > > > > >
> > > > > > not likely.  messy inbox might cause timeouts, but not "cannot open stream"
>
>
> --
> Bob Crandell
> Assured Computing
> When you need to be sure.
> address@hidden
> www.assuredcomp.com
> Voice - 541-689-9159
> FAX - 541-463-1627
> Eugene, Oregon
>
>
>
>
> _______________________________________________
> Phpgroupware-developers mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-developers

--
----------------------------------------------------------------------
Ralf Becker
digital ROCK, Becker & Macht GbR            Telefon +49 (631) 31657-51
Leibnizstraße 17                            Telefax +49 (631) 31657-52
D-67663 Kaiserslautern                 EMail address@hidden