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

[Chris Weiss]

6k messages!  you're flooding the session table!  Use php4 sessions or upgrade 
to
Anglemail and install the email table by "upgrading" in setup.

Bob Crandell (address@hidden) 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:i:1;a:4:i:2;a:4:i:3;a:4: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:i:6;a:4:i:7;a:4: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:i:10;a:4:i:11;a:4:i:12;a:4: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:i:15;a:4:i:16;a:4:i:17;a:4: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"
>>>>>>
>>>>>>
>
>Voice - 541-689-9159
>FAX - 541-463-1627
>Eugene, Oregon
>
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>