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

[Bob Crandell]

I'm using MySQL. version 3.23.39 on Slackware 8.0 with php 4.0.6. and Apache 
1.3.20

Either I didn't wait long enough or there wasn't a next line.

Thanks

Ralf Becker (address@hidden) wrote:
>
>
>
>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: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
>
>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
>
>
>
>_______________________________________________
>Phpgroupware-developers mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-developers
>

--
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