Article ID: 120611, created on Mar 19, 2014, last review on Apr 27, 2014

  • Applies to:
  • Odin Business Automation Standard 4.5
  • Odin Business Automation Standard 4.3


I use Parallels Business Automation - Standard (PBA-S) XML API HSPC/API/PP. However method get_saved_paymethod_list does not work correctly.

According to PBA-S SDK guide only two values, "plugin_id" and "account_id" are required. Both are given, so the request should return:

paymethod_id => NUMBER,
name => STRING,
paytype => STRING,
paytype_id => STRING,
expire_date => STRING,

But for some reason MySQL query produced by XML API is incorrect and thus it cannot work. The following error occurs in DEBUG PBA-S log:

Error-TEXT: 53:58] [FATAL] [9927] [HSPC::Exc::Mysql::new] DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '))  AND  (`plugin`.`status` IN ('1','0'))  AND  ( `plugin`.`account_no`='860' ) ' at line 1 at /usr/lib/perl5/site_perl/5.8.8/HSPC/ line 286.
 SELECT  `plugin`.`id`,`plugin`.`name`,`plugin`.`type`,`plugin`.`expire_date`,`plugin`.`status`,`plugin`.`account_no`,`plugin`.`enabled` FROM (`plugin_pm` `plugin`)  WHERE  (`plugin`.`type` IN ())  AND  (`plugin`.`status` IN ('1','0'))  AND  ( `plugin`.`account_no`='860' )  AND  ( `plugin`.`enabled`='1' )


The 'get_saved_paymethod_list' method is not applicable for redirect payment plug-ins.

Search Words


get_saved_paymethod_list does not work


You have an error in your SQL syntax

624ca542e40215e6f1d39170d8e7ec75 caea8340e2d186a540518d08602aa065 400e18f6ede9f8be5575a475d2d6b0a6 70a5401e8b9354cd1d64d0346f2c4a3e 807e9c1dc97aefd951b912a17e50c428

Email subscription for changes to this article
Save as PDF