Open Maintenance - Affiliate Session DBF

------=_NextPart_000_0015_01C43805.8A4F9600
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Why would the affiliate session .dbf have a large file size if I do not
have any affiliates set up in my store?
=20
Marc
=20
Marc Anderson
Hemslojd, Inc.
201 N Main St
PO Box 152
Lindsborg, KS 67456
Toll Free: 1-800-779-3344
www.hemslojd.com <<A HREF ="http://www.hemslojd.com>=20">http://www.hemslojd.com>=20</A>
www.glass-decorators.com <<A HREF ="http://www.glass-decorators.com>=20">http://www.glass-decorators.com>=20</A>
[email protected] <mailto:[email protected]>=20


------=_NextPart_000_0015_01C43805.8A4F9600--

Open Maintenance - Affiliate Session DBF



Miva Merchant versions prior to and including 4.12 had this bug, and I
believe it was re-introduced in 4.14, had a bug which caused the
affsess.dbf and its related indexes to balloon exponentially.

You can resolve the problem by upgrading to 4.13 AND using a db editor
to clean out the affsess.dbf. You can also periodically empty the
database and overwrite the large file if you don't care to upgrade.

You can also hire someone to edit the dbf for you, if you're not
comfortable doing it yourself.

Vic Vega
WolfPaw Computers
Miva Merchant Hosting Specialists
"Put the power of the pack to work for you!"(sm)
Ph: 1 (866) WOLFPAW
www.wpcomp.com


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Marc Anderson
Sent: Wednesday, May 12, 2004 9:43 AM
To: [email protected]
Subject: [mru] Open Maintenance - Affiliate Session DBF


Why would the affiliate session .dbf have a large file size if I do not
have any affiliates set up in my store?

Marc

Marc Anderson
Hemslojd, Inc.
201 N Main St
PO Box 152
Lindsborg, KS 67456
Toll Free: 1-800-779-3344
www.hemslojd.com <<A HREF ="http://www.hemslojd.com> ">http://www.hemslojd.com> </A>
www.glass-decorators.com <<A HREF ="http://www.glass-decorators.com> ">http://www.glass-decorators.com> </A>
[email protected] <mailto:[email protected]>

Force price and/or availability to have minimum quantity per item



Is there a module to force a price and/or availabiltiy group to have a
minimum number of each item in the basket and checkout.
Thanks much!

Open Maintenance - Affiliate Session DBF



Vic....can I just overwrite those files with an empty file?

Thanks,
Russ Taylor
[email protected]

----- Original Message -----
From: "WolfPaw Computers - Miva List" <[email protected]>
To: "'Marc Anderson'" <[email protected]>; <[email protected]>
Sent: Wednesday, May 12, 2004 10:51 AM
Subject: RE: [mru] Open Maintenance - Affiliate Session DBF


> Miva Merchant versions prior to and including 4.12 had this bug, and I
> believe it was re-introduced in 4.14, had a bug which caused the
> affsess.dbf and its related indexes to balloon exponentially.
>
> You can resolve the problem by upgrading to 4.13 AND using a db editor
> to clean out the affsess.dbf. You can also periodically empty the
> database and overwrite the large file if you don't care to upgrade.
>
> You can also hire someone to edit the dbf for you, if you're not
> comfortable doing it yourself.
>
> Vic Vega
> WolfPaw Computers
> Miva Merchant Hosting Specialists
> "Put the power of the pack to work for you!"(sm)
> Ph: 1 (866) WOLFPAW
> www.wpcomp.com
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Marc Anderson
> Sent: Wednesday, May 12, 2004 9:43 AM
> To: [email protected]
> Subject: [mru] Open Maintenance - Affiliate Session DBF
>
>
> Why would the affiliate session .dbf have a large file size if I do not
> have any affiliates set up in my store?
>
> Marc
>
> Marc Anderson
> Hemslojd, Inc.
> 201 N Main St
> PO Box 152
> Lindsborg, KS 67456
> Toll Free: 1-800-779-3344
> www.hemslojd.com <<A HREF ="http://www.hemslojd.com> ">http://www.hemslojd.com> </A>
> www.glass-decorators.com <<A HREF ="http://www.glass-decorators.com> ">http://www.glass-decorators.com> </A>
> [email protected] <mailto:[email protected]>
>
>

Open Maintenance - Affiliate Session DBF



That depends on how that empty file was created. It still has to be a
dbf in the same format as the file you're replacing. Just with no
records in it.

Vic Vega
WolfPaw Computers
Miva Merchant Hosting Specialists
"Put the power of the pack to work for you!"(sm)
Ph: 1 (866) WOLFPAW
www.wpcomp.com


-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: Wednesday, May 12, 2004 11:00 AM
To: [email protected]; 'Marc Anderson'; [email protected]
Subject: Re: [mru] Open Maintenance - Affiliate Session DBF


Vic....can I just overwrite those files with an empty file?

Thanks,
Russ Taylor
[email protected]

----- Original Message -----
From: "WolfPaw Computers - Miva List" <[email protected]>
To: "'Marc Anderson'" <[email protected]>; <[email protected]>
Sent: Wednesday, May 12, 2004 10:51 AM
Subject: RE: [mru] Open Maintenance - Affiliate Session DBF


> Miva Merchant versions prior to and including 4.12 had this bug, and I

> believe it was re-introduced in 4.14, had a bug which caused the
> affsess.dbf and its related indexes to balloon exponentially.
>
> You can resolve the problem by upgrading to 4.13 AND using a db editor

> to clean out the affsess.dbf. You can also periodically empty the
> database and overwrite the large file if you don't care to upgrade.
>
> You can also hire someone to edit the dbf for you, if you're not
> comfortable doing it yourself.
>
> Vic Vega
> WolfPaw Computers
> Miva Merchant Hosting Specialists
> "Put the power of the pack to work for you!"(sm)
> Ph: 1 (866) WOLFPAW
> www.wpcomp.com
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Marc Anderson
> Sent: Wednesday, May 12, 2004 9:43 AM
> To: [email protected]
> Subject: [mru] Open Maintenance - Affiliate Session DBF
>
>
> Why would the affiliate session .dbf have a large file size if I do
> not have any affiliates set up in my store?
>
> Marc
>
> Marc Anderson
> Hemslojd, Inc.
> 201 N Main St
> PO Box 152
> Lindsborg, KS 67456
> Toll Free: 1-800-779-3344
> www.hemslojd.com <<A HREF ="http://www.hemslojd.com>">http://www.hemslojd.com></A>
> www.glass-decorators.com <<A HREF ="http://www.glass-decorators.com> ">http://www.glass-decorators.com> </A>
> [email protected] <mailto:[email protected]>
>
>

Open Maintenance - Affiliate Session DBF



If you are not using the Affiliate Feature in Merchant you can just replace
the affiliate files with emptys. If you need empty files let me know off
list.

Luray M. Williams
Santa Fe Mall, Inc.
Miva Merchant Display Modules
<A HREF ="http://www.santafemall.com">http://www.santafemall.com</A>
[email protected]


> Vic....can I just overwrite those files with an empty file?
>
> Thanks,
> Russ Taylor
> [email protected]
>
> ----- Original Message -----
> From: "WolfPaw Computers - Miva List" <[email protected]>
> To: "'Marc Anderson'" <[email protected]>; <[email protected]>
> Sent: Wednesday, May 12, 2004 10:51 AM
> Subject: RE: [mru] Open Maintenance - Affiliate Session DBF
>
>
> > Miva Merchant versions prior to and including 4.12 had this bug, and I
> > believe it was re-introduced in 4.14, had a bug which caused the
> > affsess.dbf and its related indexes to balloon exponentially.
> >
> > You can resolve the problem by upgrading to 4.13 AND using a db editor
> > to clean out the affsess.dbf. You can also periodically empty the
> > database and overwrite the large file if you don't care to upgrade.
> >
> > You can also hire someone to edit the dbf for you, if you're not
> > comfortable doing it yourself.
> >
> > Vic Vega
> > WolfPaw Computers
> > Miva Merchant Hosting Specialists
> > "Put the power of the pack to work for you!"(sm)
> > Ph: 1 (866) WOLFPAW
> > www.wpcomp.com
> >
> >
> > -----Original Message-----
> > From: [email protected]
> > [mailto:[email protected]] On Behalf Of Marc Anderson
> > Sent: Wednesday, May 12, 2004 9:43 AM
> > To: [email protected]
> > Subject: [mru] Open Maintenance - Affiliate Session DBF
> >
> >
> > Why would the affiliate session .dbf have a large file size if I do not
> > have any affiliates set up in my store?
> >
> > Marc
> >
> > Marc Anderson
> > Hemslojd, Inc.
> > 201 N Main St
> > PO Box 152
> > Lindsborg, KS 67456
> > Toll Free: 1-800-779-3344
> > www.hemslojd.com <<A HREF ="http://www.hemslojd.com>">http://www.hemslojd.com></A>
> > www.glass-decorators.com <<A HREF ="http://www.glass-decorators.com>">http://www.glass-decorators.com></A>
> > [email protected] <mailto:[email protected]>
> >
> >