Error Description: DHL XML Response missing result code

[linpi]

I have a problem with the shipping. I get always the same error:

Code Select Expand


Please select a Shipping Method!
No valid database connection Unknown column 'user_info_id' in 'where clause' SQL=SELECT * FROM jos_users, jos_vm_country WHERE user_info_id='0202506fbbebefba16125e959374b1c1' AND ( country=country_2_code OR country=country_3_code)
Error Description: DHL XML Response missing result code

as any one an idea how to fix that? I use VirtueMart 1.1.3 and Joomla 1.5.11.

[yakkes]

you can change line 96 in class/shipping/dhl.php

      $q  = "SELECT * FROM #__users, #__{vm}_country " .

to
      $q  = "SELECT * FROM #__{vm}_user_info, #__{vm}_country " .

[mcavani]

I jut started getting a similar error code on the order confirmation page:

No valid database connection Unknown column 'user_info_id' in 'where clause' SQL=SELECT * FROM jos_users WHERE user_info_id='3d73d666b50934cbf97fa269661c89d2'

Is there a simple code fix for this as well?