This attribute in the registry is a check box in the administrator.
Click on the data source name in the Client Variable page,
then uncheck the "Purge data for clients that remain unvisited for X days"
check box.
--
Tom Jordahl
MacroMedia Server Development
-----Original Message-----
From: Rob Patrick [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 09, 2001 8:55 AM
To: CF-Linux
Subject: Re: CF45 Linux scheduled client data purge MySQL errors
I may have found what I'm looking for...
DoPurge = 1
Was set in cf.registry for clientvars, so I changed this value to 0 in the
hopes that this controls the built-in client data purge function. Can
somebody please confirm?
----- Original Message -----
From: "Rob Patrick" <[EMAIL PROTECTED]>
To: "CF-Linux" <[EMAIL PROTECTED]>
Sent: Saturday, June 09, 2001 8:45 AM
Subject: Re: CF45 Linux scheduled client data purge MySQL errors
> Thanks for the link - the template I need to run for clearing out the
client
> vars is listed there, but I can't find how to disable the current built-in
> process of clearing the variables...? Where can I turn this off?
>
>
> -Rob
>
>
> ----- Original Message -----
> From: "Deb Dickerson" <[EMAIL PROTECTED]>
> To: "CF-Linux" <[EMAIL PROTECTED]>
> Sent: Saturday, June 09, 2001 7:57 AM
> Subject: RE: CF45 Linux scheduled client data purge MySQL errors
>
>
> > You're correct that there's a problem expiring mySQL client variables,
due
> > to limitations of mySQL. There's a template provided,
> > /opt/coldfusion/scripts/mysql_expire.cfm, that will take care of it for
> you.
> > For more details, see this knowledge base article:
> > http://www.allaire.com/Handlers/index.cfm?ID=16201&Method=Full
> >
> > Deb
> >
> > > -----Original Message-----
> > > From: Rob Patrick [mailto:[EMAIL PROTECTED]]
> > > Sent: Saturday, June 09, 2001 2:04 AM
> > > To: CF-Linux
> > > Subject: CF45 Linux scheduled client data purge MySQL errors
> > >
> > >
> > > I'm getting these errors in my logs every so often, and it's causing
CF
> to
> > > hang up pretty hard.
> > >
> > > In executive.log I'm getting this:
> > > "Error","TID=2051","06/09/01","01:37:52"," Error running SQL
> > > to expire
> > > client data from Data Sourc clientvars: ODBC Error Code = 37000
> > > (Syntax error or access violation)<P>: [MERANT][ODBC MySql
> > > driver][MySql]You
> > > have an error in your SQL syntax near 'SELECT CGLOBAL.cfid FROM
CGLOBAL
> > > WHERE CGLOBAL.lvisit < '2001-05-30 01:37:52')' at line 1<P><P>"
> > >
> > > In mysql.log I'm getting a lot of these:
> > > 010609 1:36:47 Aborted connection 57 to db: 'sfa' user: 'root' host:
> > > `localhost' (Got an error reading communication packets)
> > >
> > > Data source "sba" is called from one of my CF web pages on a user's
> site.
> > >
> > > Looks like CF tries to run the scheduled task to clear out old client
> data
> > > from the data source "clientvars" which I've defined for CF to use as
a
> > > storage area for client variables. For some reason it's puking on
this
> > > task, which ends up causing something to hang, and then MySQL starts
> > > reporting errors when subsequent CF pages are hit.
> > >
> > >
> > > I think I remember reading somewhere about an issue with CF and MySQL
on
> > > Linux with this scheduled client data expiration task, but I can't
> recall
> > > the details. Please help! :)
> > >
> > >
> > > -Rob Patrick
> > >
> > >
> > >
> >
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
