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

[Bob Crandell]

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

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