Re: [Phpgroupware-users] Bug with Sessions

[Chris Weiss]

did you change the default size of the text datatype?

in mysql the session content field is a longtext, which is L+4 bytes, where L
< 2^32 (L being the size fo the content) or a max of 4,294,967,296 bytes (4.2
Gig? wow).  Using the email app the session can get quite big because it's
caching your mailbox to greatly improve speed.

Ruben I Safir (address@hidden) wrote*:
>
>This is the latet pg.
>
>7 something.
>
>i just installed it by hand
>
>Ruben
>
>Should it produce such large sessions
>
>Ruben
>
>On Wed, Aug 28, 2002 at 03:59:42PM +0000, Chris Weiss wrote:
>> Are you using Anglemail?  what version of Postgres?  I recall and old bug
>> where postgres's "text" datatype had a very small default size.
>>
>> Ruben I Safir (address@hidden) wrote*:
>> >
>> >I'd like to report the following bug from PHP Groupware
>> >with sessions when using mail
>> >
>> >The sessions is DB
>> >Postgres
>> >Apache 1.3x
>> >
>> >Mail Server qpopper
>> >
>> >PHPGW - latest
>> >Database error: Invalid SQL: INSERT INTO phpgw_app_sessions
>> (sessionid,loginid,app,location,content,session_dla) VALUES
>> >
>>
(''4d68f869f2c7447905e131e3c3309a08','12','email','acctnum=0;data_name=msgball
>> _list','a:2:i:1;a:4:
>> {s:6:\"msgnum\";i:1252;s:6:\"folder\";s:5:\"INBOX\";s:7...continued on to
one
>> insanely long string
>> >
>> >PostgreSQL Error: 1 (PQsendQuery() -- query is too long. Maximum length is
>> 16382 )
>> >
>> >File: /home/httpd/html/phpgroupware/phpgwapi/inc/class.sessions_db.inc.php
>> >Line: 801
>> >
>> >Session halted.
>> >Fatal error: Call to undefined function: parse_navbar_end()
>> in /home/httpd/html/phpgroupware/phpgwapi/inc/footer.inc.php on line 62
>> >
>> >
>> >_______________________________________________
>> >Phpgroupware-users mailing list
>> >address@hidden
>> >http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>> >
>>
>>
>>
>> _______________________________________________
>> Phpgroupware-users mailing list
>> address@hidden
>> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>