-- HikaShop version -- : 4.2.3
-- Joomla version -- : 3.9.16
-- Browser(s) name and version -- : Safari the latest version
-- Error-message(debug-mod must be tuned on) -- : No shipping method found
If I use the manual shipping method I am presented with shipping prices. (Set it to produce a shipping price for 20% of the cost of the items in the cart.) If I use FedEx, completely setup with all the FedEx API, I receive "No shipping method found" when I proceed to checkout from the cart.
All items have weights, package sizes, etc. etc. They produce pricing with the manual shipping method. Again, this works with other shipping methods.
From the debug I get the following when searching for debug data about "shipping":
SELECT *
FROM v92qi_hikashop_shipping
WHERE (shipping_currency IN ('','_','all') OR shipping_currency LIKE '%,2,%')
AND (shipping_access = 'all' OR shipping_access LIKE '%,9,%')
ORDER BY shipping_ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE v92qi_hikashop_shipping ALL NULL NO INDEX KEY COULD BE USED NULL NULL 2 Using where; Using filesort
SELECT *
FROM v92qi_hikashop_field as a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND (a.field_address_type='shipping' OR a.field_address_type='')
AND a.field_table='address'
AND (a.field_access = 'all' OR a.field_access LIKE '%,9,%')
ORDER BY a.`field_ordering` ASC
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE a ALL NULL NO INDEX KEY COULD BE USED NULL NULL 15 Using where; Using filesort