Announcement

05-12-04, 06:51 AM

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]>

05-12-04, 07:11 AM

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!

05-12-04, 08:00 AM

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]>
>
>

05-12-04, 08:14 AM

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]>
>
>

05-12-04, 08:42 AM

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]>
> >
> >

Announcement

Open Maintenance - Affiliate Session DBF

Open Maintenance - Affiliate Session DBF

Comment

Comment

Comment

Comment

Comment