Re: [Phpgroupware-users] Bug with Sessions

[Chris Weiss]

this is a new error.  The last one was in sessions not setup.

I'm saying that postgres has too small of a default TEXT field size for
phpGW, I was showing the MySQl longtext as a compaison...16k vs 4Gig.

Ruben I Safir (address@hidden) wrote*:
>
>This is not MYSQL
>
>It is Postgres
>
>This error message:
>
>Database error: Invalid SQL: CREATE TABLE phpgw_config (config_app varchar
(50), config_name varchar(255) NOT NULL, config_value varchar(100), UNIQUE
(config_name))
>PostgreSQL Error: 1 (ERROR: Relation 'phpgw_config' already exists )
>
>
>on the setup should be handled more gracefully....
>
>Ruben
>
>On Thu, Aug 29, 2002 at 01:48:42PM +0000, Chris Weiss wrote:
>> 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
>> >
>>
>>
>>
>> _______________________________________________
>> 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
>