I figured out what was going on... Seems like a minor coding error. (missing ' " ', etc...)
line 223 of Virtuemart.php (plubin):
$vendor_id = 1; // *** fix up this hack!
// *** working on this bit 20060712
$q = "SELECT * FROM #__vm_shopper_vendor_xref WHERE `vendor_id`=".$vendor_id." AND `user_id`=" . $user->id;
$database->setQuery($q);
$database->query();
$vm_sgi = $_REQUEST;
$vm_cn = $_REQUEST;
if ( strlen($vm_sgi)==0 ) $vm_sgi=0;
if ( strlen($vm_cn)==0 ) $vm_cn="''";
if( sizeof($database->loadRowList()) < 1 ) {
// Insert Shopper -ShopperGroup - Relationship
$q = "INSERT INTO #__vm_shopper_vendor_xref ";
$q .= "(user_id,vendor_id,shopper_group_id,customer_number) ";
$q .= "VALUES (".$user->id.", $vendor_id,".$vm_sgi.", ".$vm_cn.")";
}
TO:
$vendor_id = "1"; // *** fix up this hack!
// *** working on this bit 20060712
$q = "SELECT * FROM #__vm_shopper_vendor_xref WHERE `vendor_id`=".$vendor_id." AND `user_id`=" . $user->id;
$database->setQuery($q);
$database->query();
$vm_sgi = $_REQUEST;
$vm_cn = $_REQUEST;
if ( strlen($vm_sgi)==0 ) $vm_sgi="1";
if ( strlen($vm_cn)==0 ) $vm_cn="''";
if( sizeof($database->loadRowList()) < 1 ) {
// Insert Shopper -ShopperGroup - Relationship
$q = "INSERT INTO #__vm_shopper_vendor_xref ";
$q .= "(user_id,vendor_id,shopper_group_id,customer_number) ";
$q .= "VALUES (".$user->id.", ".$vendor_id.",".$vm_sgi.", ".$vm_cn.")";
}
----
this is assuming default shopper group is "1"
Thank you
---
I hope this helps...
Post edited by: yupio, at: 2006/09/11 01:52