Re: [Phpgroupware-users] Bug with Sessions

[Ruben I Safir]

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