Magento Table Rate Shipping Not Working

http://kongjinjie.wordpress.com/2012/03/11/magento-table-rate-shipping-not-working/

  1. Edit file “/app/code/core/Mage/Shipping/Model/Resource/Carrier/Tablerate.php
  2. Comment out row 128
  3. Add this line below the commented row “->order(array(‘dest_country_id DESC’, ‘dest_region_id DESC’, ‘dest_zip DESC’, ‘condition_value DESC’))”
  4. Save and try the calculation again.
 The section in the file should now look something like this:

$select = $adapter->select()
->from($this->getMainTable())
->where('website_id = :website_id')
//->order(array('dest_country_id DESC', 'dest_region_id DESC', 'dest_zip DESC'))
->order(array('dest_country_id DESC', 'dest_region_id DESC', 'dest_zip DESC', 'condition_value DESC'))
->limit(1);