All shipment rule are not display

[Timoune974]

I have an issue with my shipping rules

I have 7 shipping rules
1) shop delivery => no zip code and no fees
2) delivery for zip code 97410 =>
    a) min zip code 97410
    b) max zip code 97410
    c) fees 8 euros
3) delivery for zip code 97432=>
    a) min zip code 97432
    b) max zip code 97432
    c) fees 8 euros
4) delivery for zip code 97430 =>
    a) min zip code 9730
    b) max zip code 97430
    c) fees 8 euros
5) delivery for zip code 97429 =>
    a) min zip code 97429
    b) max zip code 97429
    c) fees 8 euros
6) delivery for zip code 97442 =>
    a) min zip code 97442
    b) max zip code 97442
    c) fees 8 euros
7) delivery for zip code 97480 =>
    a) min zip code 97480
    b) max zip code 97480
    c) fees 8 euros

The shipping rules is working fine in the basket until the client add product in the basket without logging in and log after to valid his basket. and after that the display is wrong all time ...

I put my site in debug mode and i can see the shipping rules was correctly evaluate.
For this test the client postcode is 97410 and the shipment validation is true for the 2 rights rules

Code Select Expand

<div class="alert-message"><span class="vmdebug" >12 vmdebug shipmentmethod Retrait Magasin = TRUE for variable weight = 1250 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >13 vmdebug shipmentmethod Retrait Magasin = TRUE for variable order amount = 119 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >14 vmdebug shipmentmethod Retrait Magasin = TRUE for variable zip = 97410 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >15 vmdebug shipmentmethod Retrait Magasin = TRUE for variable virtuemart_country_id = 174, Reason: Countries in rule  or none set</span></div>
<div class="alert-message"><span class="vmdebug" >16 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable weight = 1250 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >17 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable order amount = 119 Reason: no boundary conditions set</span></div>
<div class="alert-message"><span class="vmdebug" >18 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable zip = 97410 Reason: is within Range of the condition from 97410 to 97410</span></div>
<div class="alert-message"><span class="vmdebug" >19 vmdebug shipmentmethod Livraison Interne Express Saint Pierre 1 = TRUE for variable virtuemart_country_id = 174, Reason: Countries in rule  or none set</span></div>
                                             

But the "Livraison Interne Express Saint Pierre" is not display

Code Select Expand

<tr class="sectiontableentry1" valign="top">
<td colspan="4" align="left">
    <h4>Mode de livraison sélectionné</h4> <span class="vmshipment_name">Retrait Magasin</span><span class="vmshipment_description">Retrait dans notre Magasin sur Petite Ile sur Rendez-Vous en nous contactant au 06 93 55 64 94
Pour les autres modes de livraison vous devez renseigner une adresse de livraison.</span> </td>

<td align="right" class="cart-hide"><span  class='priceColor2'></span> </td>
<td align="right" class="cart-hide"></td>
<td align="right">
      <div class="badge inline"></div>    </td>
</tr>

The entire page code is in the attached zip file.

If someone have an idea about the mistake

[Timoune974]

For information my versions are

Joomla! 3.9.11 Stable
VirtueMart 3.6.0 10113

And I already tryed the solution give in "Topic: Shipping or Payment Method Not Showing?"

I think the problem is coming with the virtuemart version 3.6 because during all my test in 3.4 all are working fine.

[GJC Web Design]

There is a problem with some shipping methods on VM3.6.0

please try ( on a non production site) the bug fix http://dev.virtuemart.net/attachments/download/1185/com_virtuemart.3.6.1.10152_package_or_extract.zip

[Timoune974]

Hello,

I installed the patch and I have now the following error message when I try to edit a product.

Code Select Expand

1054 Champ 'c.virtuemart_shoppergroup_id' inconnu dans field list

In the front end I have the same message when I try to add a product in the basket.

Regards

[GJC Web Design]

3.6.2 is released

http://dev.virtuemart.net/attachments/1187/com_virtuemart.3.6.2.10155.zip

[Timoune974]

Same issuer with

Code Select Expand

1054 Champ 'c.virtuemart_shoppergroup_id' inconnu dans field list

Perhaps I missed something during the update procedure ?

[aLioneL]

Bonjour,

I've got the same error message than Timoune974
#1054 Unknown column 'c.virtuemart_shoppergroup_id' in 'field list'
but just after upgrade to VM3.6.2.10.159 today

Thanks by advance for your help ;-)
LioneL

[GJC Web Design]

you need to further debug this so we can help .. find the function that is calling this

http://forum.virtuemart.net/index.php?topic=117042.0

[aLioneL]

reBonjour,

Je viens de trouver la solution ;-)

J'ai comparé les tables mysql '_virtuemart_customs'
celle de mon vm avec celle de vm3.6.2 :

dans mon vieux vm3.6.1, il y avait "custom_field_desc", qui n'existait plus dans vm3.6.2

que j'ai donc remplacé par "virtuemart_shoppergroup_id" qui m'etait manquant

(j'ai utilisé phpMyAdmin)

et Alleluia !!!! tout refonctionne :-)

Merci encore a celles et ceux qui se sont penché(e)s sur mon soucis
Amicalement,
LioneL