کامپونتت اتصال ویرچومارت به بانک ملت

[aquapresco 0]

ارور :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\\" />

\\" />

\\" /> \\" /> \\" /> \\" /> \\" />

');

[مصطفی صفرعلی 2,891]

با سلام

افزونه رو بطور کامل از روی هاست و دیتابیس حذف کنید و مجدد نصب کنید . در صورتی که مشکل همچنان پابر جا بود آخرین ورژن را از سایت سازنده دریافت کنید و نصب کنید

موفق و پیروز باشید

یا حق

:64 (17):

[pablogh 0]

سلام.

برای منم دقیقا همین مشکل وجود داره.

[فرحزادیان 947]

با سلام

به انجمن جومینا خوش آمدید

به پست قبل از خودتون(پست شماره 2 همین تاپیک) دقت کردید!؟ انجام دادید!؟

موفق باشید

[pablogh 0]

آخرین ورژن چی؟ویرچو مارت؟جوملا؟چی...