I have a problem with the shipping. I get always the same error:
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.
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 " .
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?