Re: [Phpgroupware-users] Bug with Sessions

[Ruben I Safir]

Now it's in an endless loop

on this error, and the setup is broken because I tried to fix a conflict with
phpwrapper whatever




On Thu, Aug 29, 2002 at 12:19:44PM -0400, Ruben I Safir 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