ارور :001:
JInstaller: :نصب: ایراد SQL تابع دیتابیس با ارور 1146 مواجه شد
Table 'foroskah.bsj01_vm_payment_method' doesn't exist SQL=INSERT INTO bsj01_vm_payment_method (`vendor_id`, `payment_method_name`, `payment_class`, `shopper_group_id`, `payment_method_discount`, `payment_method_discount_is_percent`, `payment_method_discount_max_amount`, `payment_method_discount_min_amount`, `list_order`, `payment_method_code`, `enable_processor`, `is_creditcard`, `payment_enabled`, `accepted_creditcards`, `payment_extrainfo`) VALUES ('1', 'بانک ملت', 'ps_joominamellat', '5', '0.00', '0', '0.00', '0.00', '0', 'JMELLAT', 'P', '0', 'Y', '', 'f(\\"user_info_id\\").\\"\\''\\"; $dbbt = new ps_DB; $dbbt->setQuery($q); $dbbt->query(); $dbbt->next_record(); // Get ship_to information if( $db->f(\\"user_info_id\\") != $dbbt->f(\\"user_info_id\\")) { $q2 = \\"SELECT * FROM #__vm_user_info WHERE user_info_id=\\''\\".$db->f(\\"user_info_id\\").\\"\\''\\"; $dbst = new ps_DB; $dbst->setQuery($q2); $dbst->query(); $dbst->next_record(); } else { $dbst = $dbbt; } $tid= TERMINALID; $u= USERNAME; $p= PASSWORD; $on= $db->f(\\"order_number\\"); $url = JRoute::_(JURI::root().\\''components/com_joominamellat/jmellatcon.php\\''); $backurl = JRoute::_(JURI::root().\\"components/com_joominamellat/jmellatcallback.php?on=$on&tid=$tid&u=$u&p=$p\\"); $unit = UNIT; $amount = number_format($db->f(\\"order_total\\"), 0, \\''.\\'', \\''\\''); if ($unit=="t"){ $amount = $amount / 10; } ?>
\\" method=\\"post\\" /> \\" />
\\" /> \\" /> \\" /> \\" /> \\" />
');
SQL =
INSERT INTO #__vm_payment_method (`vendor_id`, `payment_method_name`, `payment_class`, `shopper_group_id`, `payment_method_discount`, `payment_method_discount_is_percent`, `payment_method_discount_max_amount`, `payment_method_discount_min_amount`, `list_order`, `payment_method_code`, `enable_processor`, `is_creditcard`, `payment_enabled`, `accepted_creditcards`, `payment_extrainfo`)
VALUES ('1', 'بانک ملت', 'ps_joominamellat', '5', '0.00', '0', '0.00', '0.00', '0', 'JMELLAT', 'P', '0', 'Y', '', 'f(\\"user_info_id\\").\\"\\''\\";
$dbbt = new ps_DB;
$dbbt->setQuery($q);
$dbbt->query();
$dbbt->next_record();
// Get ship_to information
if( $db->f(\\"user_info_id\\") != $dbbt->f(\\"user_info_id\\")) {
$q2 = \\"SELECT * FROM #__vm_user_info WHERE user_info_id=\\''\\".$db->f(\\"user_info_id\\").\\"\\''\\";
$dbst = new ps_DB;
$dbst->setQuery($q2);
$dbst->query();
$dbst->next_record();
}
else {
$dbst = $dbbt;
}
$tid= TERMINALID;
$u= USERNAME;
$p= PASSWORD;
$on= $db->f(\\"order_number\\");
$url = JRoute::_(JURI::root().\\''components/com_joominamellat/jmellatcon.php\\'');
$backurl = JRoute::_(JURI::root().\\"components/com_joominamellat/jmellatcallback.php?on=$on&tid=$tid&u=$u&p=$p\\");
$unit = UNIT;
$amount = number_format($db->f(\\"order_total\\"), 0, \\''.\\'', \\''\\'');
if ($unit=="t"){
$amount = $amount / 10;
}
?>
\\" method=\\"post\\" />
\\" />
\\" /> \\" /> \\" /> \\" /> \\" />
');
نصب کامپوننت: ایراد در فایل SQL تابع دیتابیس با ارور 1146 مواجه شد
Table 'foroskah.bsj01_vm_payment_method' doesn't exist SQL=INSERT INTO bsj01_vm_payment_method (`vendor_id`, `payment_method_name`, `payment_class`, `shopper_group_id`, `payment_method_discount`, `payment_method_discount_is_percent`, `payment_method_discount_max_amount`, `payment_method_discount_min_amount`, `list_order`, `payment_method_code`, `enable_processor`, `is_creditcard`, `payment_enabled`, `accepted_creditcards`, `payment_extrainfo`) VALUES ('1', 'بانک ملت', 'ps_joominamellat', '5', '0.00', '0', '0.00', '0.00', '0', 'JMELLAT', 'P', '0', 'Y', '', 'f(\\"user_info_id\\").\\"\\''\\"; $dbbt = new ps_DB; $dbbt->setQuery($q); $dbbt->query(); $dbbt->next_record(); // Get ship_to information if( $db->f(\\"user_info_id\\") != $dbbt->f(\\"user_info_id\\")) { $q2 = \\"SELECT * FROM #__vm_user_info WHERE user_info_id=\\''\\".$db->f(\\"user_info_id\\").\\"\\''\\"; $dbst = new ps_DB; $dbst->setQuery($q2); $dbst->query(); $dbst->next_record(); } else { $dbst = $dbbt; } $tid= TERMINALID; $u= USERNAME; $p= PASSWORD; $on= $db->f(\\"order_number\\"); $url = JRoute::_(JURI::root().\\''components/com_joominamellat/jmellatcon.php\\''); $backurl = JRoute::_(JURI::root().\\"components/com_joominamellat/jmellatcallback.php?on=$on&tid=$tid&u=$u&p=$p\\"); $unit = UNIT; $amount = number_format($db->f(\\"order_total\\"), 0, \\''.\\'', \\''\\''); if ($unit=="t"){ $amount = $amount / 10; } ?> \\" method=\\"post\\" /> \\" />
\\" /> \\" /> \\" /> \\" /> \\" />
');
SQL =
INSERT INTO #__vm_payment_method (`vendor_id`, `payment_method_name`, `payment_class`, `shopper_group_id`, `payment_method_discount`, `payment_method_discount_is_percent`, `payment_method_discount_max_amount`, `payment_method_discount_min_amount`, `list_order`, `payment_method_code`, `enable_processor`, `is_creditcard`, `payment_enabled`, `accepted_creditcards`, `payment_extrainfo`)
VALUES ('1', 'بانک ملت', 'ps_joominamellat', '5', '0.00', '0', '0.00', '0.00', '0', 'JMELLAT', 'P', '0', 'Y', '', 'f(\\"user_info_id\\").\\"\\''\\";
$dbbt = new ps_DB;
$dbbt->setQuery($q);
$dbbt->query();
$dbbt->next_record();
// Get ship_to information
if( $db->f(\\"user_info_id\\") != $dbbt->f(\\"user_info_id\\")) {
$q2 = \\"SELECT * FROM #__vm_user_info WHERE user_info_id=\\''\\".$db->f(\\"user_info_id\\").\\"\\''\\";
$dbst = new ps_DB;
$dbst->setQuery($q2);
$dbst->query();
$dbst->next_record();
}
else {
$dbst = $dbbt;
}
$tid= TERMINALID;
$u= USERNAME;
$p= PASSWORD;
$on= $db->f(\\"order_number\\");
$url = JRoute::_(JURI::root().\\''components/com_joominamellat/jmellatcon.php\\'');
$backurl = JRoute::_(JURI::root().\\"components/com_joominamellat/jmellatcallback.php?on=$on&tid=$tid&u=$u&p=$p\\");
$unit = UNIT;
$amount = number_format($db->f(\\"order_total\\"), 0, \\''.\\'', \\''\\'');
if ($unit=="t"){
$amount = $amount / 10;
}
?>
\\" method=\\"post\\" />
\\" />
\\" /> \\" /> \\" /> \\" /> \\" />
');
