MvSKIP problem in compiled module

Hi folks --

I'm getting an "Invalid record number" from an MvSKIP tag in a compiled
module. This code has been working fine in various customers' sites for a
long time, but it's possible that this combination of circumstances hasn't
occurred before ...

I wrote the tag with no ROWS attribute, just <MvSKIP NAME="thedatabase">
. Is there a requirement in compiled Miva that the ROWS attribute be
present in MvSKIPs? I always thought you could leave it out, and the tag
would default to skipping forward one row. Is there any other type of
problem that could cause an "invalid record number" error?

Thanks --

Kent Multer | /| P.O.Box 701895, Dallas TX 75370
Magic Metal Productions | / | (214) 570 8264 voice/fax
| | [email protected]
* Web developer/designer http://TheMagicM.com
* E-commerce and Miva
* Author, The Official Miva Web Scripting Book -- available on-line:
<A HREF ="http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA">http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA</A>

MvSKIP problem in compiled module



No change in compiled, the ROWS attribute still defaults to one.

--

Adam
http://vikingcoders.com

Kent Multer wrote:
> Hi folks --
>
> I'm getting an "Invalid record number" from an MvSKIP tag in a compiled
> module. This code has been working fine in various customers' sites for
> a long time, but it's possible that this combination of circumstances
> hasn't occurred before ...
>
> I wrote the tag with no ROWS attribute, just <MvSKIP NAME="thedatabase">
> . Is there a requirement in compiled Miva that the ROWS attribute be
> present in MvSKIPs? I always thought you could leave it out, and the
> tag would default to skipping forward one row. Is there any other type
> of problem that could cause an "invalid record number" error?

MvSKIP problem in compiled module



It's might be possible that for some reason one or more of the indexes
you opened with the database are not "synced up" with the actual
database. Try putting a "MvREINDEX" tag right after you open the
database and see if the error goes away. Is it possible that a record
was added or deleted without having all the relavent indexes open at
some point in your script?

This error is index related. I didn't test it, but this error might come
up if you use MvSKIP without opening an index with the database. Maybe
you didn't have an index open when you were using the ROWS attribute and
now that you aren't using it the system is looking for an index to be
open and gives you that error.

Just some ideas-

Scot

Kent Multer wrote:
> Hi folks --
>
> I'm getting an "Invalid record number" from an MvSKIP tag in a compiled
> module. This code has been working fine in various customers' sites for
> a long time, but it's possible that this combination of circumstances
> hasn't occurred before ...
>
> I wrote the tag with no ROWS attribute, just <MvSKIP NAME="thedatabase">
> . Is there a requirement in compiled Miva that the ROWS attribute be
> present in MvSKIPs? I always thought you could leave it out, and the
> tag would default to skipping forward one row. Is there any other type
> of problem that could cause an "invalid record number" error?
>
> Thanks --
>
> Kent Multer | /| P.O.Box 701895, Dallas TX 75370
> Magic Metal Productions | / | (214) 570 8264 voice/fax
> | | [email protected]
> * Web developer/designer http://TheMagicM.com
> * E-commerce and Miva
> * Author, The Official Miva Web Scripting Book -- available on-line:
> <A HREF ="http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA">http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA</A>
>
>
>

Inventory module that will not remove product quantity for payments



I need an inventory module that will not remove product quantity if the
payments is made with a check or a money order.

I am still using Miva v 3 with Bill Weiland's inventory module that
is modified to skip the money order and check payments. From what I
understand , his inventory module upgrade can't be modified to do this.

I would like to upgrade to the latest Miva version but I can't have the
customers remove products from the inventory by check or money order
since most of them are not sending in the orders.

Thank you
Aron
RingsideCollectibles.com

MvSKIP problem fixed



FYI, Scot was on the right track: the problem was in the index
file. Although we like to think that packing rebuilds an index, there's a
certain amount of "core" data in there that can't be rebuilt. Apparently
some of that was corrupted. I replaced the .mvx with a known-good one from
my own test store, and then packed again. That fixed the problem.

Thanks to all who offered some ideas! Good night --


Kent Multer | /| P.O.Box 701895, Dallas TX 75370
Magic Metal Productions | / | (214) 570 8264 voice/fax
| | [email protected]
* Web developer/designer http://TheMagicM.com
* E-commerce and Miva
* Author, The Official Miva Web Scripting Book -- available on-line:
<A HREF ="http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA">http://www.amazon.com/exec/obidos/ISBN=0966103211/magicmetalproducA</A>

Inventory module that will not remove product quantity for payments with check and money order.



I'm not aware of anything that would do that, as the Inventory is
normally contingent on the basket and whether or not the shopper checked
out, regardless of the payment method.

Pamela
Get the NEW Official Miva Merchant Book!
AND learn how to Make the BEST of Your Online Store.
<A HREF ="http://www.designextend.com ">http://www.designextend.com </A>

> -----Original Message-----
> From: [email protected]
> [mailto:[email protected]] On Behalf Of Ringside
> Collectibles
> Sent: Tuesday, January 25, 2005 2:44 AM
> To: Miva Merchant coders list
> Subject: [mrc] Inventory module that will not remove product
> quantity for payments with check and money order.
>
>
> I need an inventory module that will not remove product
> quantity if the
> payments is made with a check or a money order.
>
> I am still using Miva v 3 with Bill Weiland's inventory
> module that
> is modified to skip the money order and check payments. From what I
> understand , his inventory module upgrade can't be modified
> to do this.
>
> I would like to upgrade to the latest Miva version but I
> can't have the
> customers remove products from the inventory by check or money order
> since most of them are not sending in the orders.
>
> Thank you
> Aron
> RingsideCollectibles.com
>
>
>
>
>

Inventory module that will not remove product quantity for



--Boundary_(ID_4cvFNW/ZXc79oirl6ao+UQ)
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT


I hope that there is a way that we can accept money orders and checks in
our Miva store without reducing the inventory.

The problem is that most of the check and money order orders are put by
kids who will never buy anything. This creates a problem in keeping up
with the inventory to a point that we will have to give up the idea of
upgrading to the latest Miva version and forget about Miva as our store
all together.

I hope that someone had solved this problem before and has the code that
will make baskets that were paid by check or money order skip inventory.
Or if someone can point me to the code in MMUI were the payment method
and the inventory are introduced to the basket. I probably could take it
from there and try to figure it out. Please help me with this problem so
I can stay with Miva and go for the upgrade.

Thanks
Aron

Media Services Int'l, Inc. wrote:

>I'm not aware of anything that would do that, as the Inventory is
>normally contingent on the basket and whether or not the shopper checked
>out, regardless of the payment method.
>
>Pamela
>Get the NEW Official Miva Merchant Book!
>AND learn how to Make the BEST of Your Online Store.
><A HREF ="http://www.designextend.com ">http://www.designextend.com </A>
>
>
>
>>-----Original Message-----
>>From: [email protected]
>>[mailto:[email protected]] On Behalf Of Ringside
>>Collectibles
>>Sent: Tuesday, January 25, 2005 2:44 AM
>>To: Miva Merchant coders list
>>Subject: [mrc] Inventory module that will not remove product
>>quantity for payments with check and money order.
>>
>>
>>I need an inventory module that will not remove product
>>quantity if the
>>payments is made with a check or a money order.
>>
>>I am still using Miva v 3 with Bill Weiland's inventory
>>module that
>>is modified to skip the money order and check payments. From what I
>>understand , his inventory module upgrade can't be modified
>>to do this.
>>
>>I would like to upgrade to the latest Miva version but I
>>can't have the
>>customers remove products from the inventory by check or money order
>>since most of them are not sending in the orders.
>>
>>Thank you
>>Aron
>>RingsideCollectibles.com
>>
>>
>>
>>
>>

Inventory module that will not remove product quantity for payments with check and money order.



There are two things to consider:

1. Make a statement that items will only be held for X amount of days.

2. Get an account to accept online checks, to avoid the problem
altogether. You could also utilize PayPal for this.

There's no module that I'm aware of that will release the inventory
based on the payment method. Inventory is reduced when an item is added
to the basket, and remains reduced when the final checkout procedure
occurs, regardless of payment method.

Editing the MMUI generally won't fix this. The inventory is not tied to
the method of payment. Thus, the functionality of the module would need
to be completely re-written (as it doesn't matter what the payment
method is).

Pamela
Get the NEW Official Miva Merchant Book!
AND learn how to Make the BEST of Your Online Store.
<A HREF ="http://www.designextend.com ">http://www.designextend.com </A>

-----Original Message-----
From: Ringside Collectibles [mailto:[email protected]]
Sent: Tuesday, January 25, 2005 7:20 PM
To: [email protected]
Cc: 'Miva Merchant coders list'
Subject: Re: [mrc] Inventory module that will not remove product
quantity for payments with check and money order.



I hope that there is a way that we can accept money orders and checks in
our Miva store without reducing the inventory.

The problem is that most of the check and money order orders are put by
kids who will never buy anything. This creates a problem in keeping up
with the inventory to a point that we will have to give up the idea of
upgrading to the latest Miva version and forget about Miva as our store
all together.

I hope that someone had solved this problem before and has the code that
will make baskets that were paid by check or money order skip inventory.
Or if someone can point me to the code in MMUI were the payment method
and the inventory are introduced to the basket. I probably could take it
from there and try to figure it out. Please help me with this problem so
I can stay with Miva and go for the upgrade.

Thanks
Aron

Media Services Int'l, Inc. wrote:

I'm not aware of anything that would do that, as the Inventory is
normally contingent on the basket and whether or not the shopper checked
out, regardless of the payment method.

Pamela
Get the NEW Official Miva Merchant Book!
AND learn how to Make the BEST of Your Online Store.
<A HREF ="http://www.designextend.com ">http://www.designextend.com </A>


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Ringside
Collectibles
Sent: Tuesday, January 25, 2005 2:44 AM
To: Miva Merchant coders list
Subject: [mrc] Inventory module that will not remove product
quantity for payments with check and money order.


I need an inventory module that will not remove product
quantity if the
payments is made with a check or a money order.

I am still using Miva v 3 with Bill Weiland's inventory
module that
is modified to skip the money order and check payments. From what I
understand , his inventory module upgrade can't be modified
to do this.

I would like to upgrade to the latest Miva version but I
can't have the
customers remove products from the inventory by check or money order
since most of them are not sending in the orders.

Thank you
Aron
RingsideCollectibles.com

Inventory module that will not remove product quantity for payments with check and money order.



Well, if you use a truXoft notification module, you can force the restocking
of the products from the current order by a simple Miva Script in the
footer:

<MvASSIGN NAME="g.TxRestock" VALUE="{Orders.d.pay_id EQ X}">

... where instead of X, you set the numeric ID of the shipping method for
which you do not wish the products to be taken from the inventory. You could
also use the pay_data field instead of pay_id - that's more verbose, but at
some shipping modules may be changing. Look up the right values for the
pay_id in your orders.dbf data file.

When you want to include two methods, just use a logical expression:

<MvASSIGN NAME="g.TxRestock" VALUE="{Orders.d.pay_id EQ X OR Orders.d.pay_id
EQ Y}">


PS: I did not test it, but it should work, assuming you have the TxINVOICE
library v2.00099 or higher. You can see the library versions in the
mouse-over info over the main module version in its configuration screen. If
it is older, just hit the link "update" at the top and wait till the page
fully reloads.

PPS: the restocking may be triggered also by other conditions, of course

Ivo Truxa

| http://miva.truxoft.com
| Advanced Miva Merchant modules



-----Original Message-----
From: Media Services Int'l, Inc.


There are two things to consider:

1. Make a statement that items will only be held for X amount of days.

2. Get an account to accept online checks, to avoid the problem
altogether. You could also utilize PayPal for this.

There's no module that I'm aware of that will release the inventory
based on the payment method. Inventory is reduced when an item is added
to the basket, and remains reduced when the final checkout procedure
occurs, regardless of payment method.

Editing the MMUI generally won't fix this. The inventory is not tied to
the method of payment. Thus, the functionality of the module would need
to be completely re-written (as it doesn't matter what the payment
method is).

Pamela
Get the NEW Official Miva Merchant Book!
AND learn how to Make the BEST of Your Online Store.
<A HREF ="http://www.designextend.com ">http://www.designextend.com </A>

-----Original Message-----
From: Ringside Collectibles [mailto:[email protected]]
Sent: Tuesday, January 25, 2005 7:20 PM
To: [email protected]
Cc: 'Miva Merchant coders list'
Subject: Re: [mrc] Inventory module that will not remove product
quantity for payments with check and money order.



I hope that there is a way that we can accept money orders and checks in
our Miva store without reducing the inventory.

The problem is that most of the check and money order orders are put by
kids who will never buy anything. This creates a problem in keeping up
with the inventory to a point that we will have to give up the idea of
upgrading to the latest Miva version and forget about Miva as our store
all together.

I hope that someone had solved this problem before and has the code that
will make baskets that were paid by check or money order skip inventory.
Or if someone can point me to the code in MMUI were the payment method
and the inventory are introduced to the basket. I probably could take it
from there and try to figure it out. Please help me with this problem so
I can stay with Miva and go for the upgrade.

Thanks
Aron

Media Services Int'l, Inc. wrote:

I'm not aware of anything that would do that, as the Inventory is
normally contingent on the basket and whether or not the shopper checked
out, regardless of the payment method.

Pamela
Get the NEW Official Miva Merchant Book!
AND learn how to Make the BEST of Your Online Store.
<A HREF ="http://www.designextend.com ">http://www.designextend.com </A>


-----Original Message-----
From: [email protected]
[mailto:[email protected]] On Behalf Of Ringside
Collectibles
Sent: Tuesday, January 25, 2005 2:44 AM
To: Miva Merchant coders list
Subject: [mrc] Inventory module that will not remove product
quantity for payments with check and money order.


I need an inventory module that will not remove product
quantity if the
payments is made with a check or a money order.

I am still using Miva v 3 with Bill Weiland's inventory
module that
is modified to skip the money order and check payments. From what I
understand , his inventory module upgrade can't be modified
to do this.

I would like to upgrade to the latest Miva version but I
can't have the
customers remove products from the inventory by check or money order
since most of them are not sending in the orders.

Thank you
Aron
RingsideCollectibles.com