Bug in StoredProcedure [Nop_ShippingMethodLoadAll]

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 years ago
Hi,

Maybe I'm wrong, but it seems to me that there is a bug in SP [Nop_ShippingMethodLoadAll].
If shipping is enabled to several countries only, these countries are inserted in table:
[Nop_ShippingMethod_RestrictedCountries].

During checkout, I get the message that shipping isn't possible to the selected country because
the SP doesn't load a shipping method - please have a look at the following query:

SELECT  sm.*    FROM [Nop_ShippingMethod] sm
WHERE     sm.ShippingMethodID NOT IN
        (
            SELECT smc.ShippingMethodID
            FROM   [Nop_ShippingMethod_RestrictedCountries] smc
            WHERE
            smc.CountryID = @FilterByCountryID AND
            sm.ShippingMethodID = smc.ShippingMethodID
        )

Shouldn't this 'NOT IN' be better an 'IN' to get the right result ?!?
(this problem exists up to current version 1.70 of NopCommerce)

Thanks !
13 years ago
You restrict countries on that page (not allow). So it works fine
13 years ago
OK, so that was a misunderstanding because
'restricted' translated to german also means 'limited to', so
I thought only these countries are possible for shipping to -
just the opposite.

I've been only wondering where these entries in this table
come from - maybe I've played around too much on the
administration page ;-)

Thank you for answering !
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.