Author Topic: Error Description: DHL XML Response missing result code  (Read 12131 times)

linpi

  • Beginner
  • *
  • Posts: 1
Error Description: DHL XML Response missing result code
« on: June 16, 2009, 15:50:02 pm »
I have a problem with the shipping. I get always the same error:
Code: [Select]
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

  • Beginner
  • *
  • Posts: 40
Re: Error Description: DHL XML Response missing result code
« Reply #1 on: August 18, 2009, 13:26:29 pm »
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

  • Beginner
  • *
  • Posts: 3
Re: Error Description: DHL XML Response missing result code
« Reply #2 on: February 01, 2010, 20:48:04 pm »
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?