[Self-Hosted] online payment gateway problem

system · March 15, 2019, 3:28am

Hi
I’m self hosting v4.5.11.

When I try to do something with online payment gateways I get the following error:

production.ERROR:
***Omnipay\Common\Exception\RuntimeException*** [0] :
/vendor/omnipay/common/src/Omnipay/Common/GatewayFactory.php [Line 105] => Class '\Omnipay\Dwolla\Gateway' not found

Any help is appreciated.

hillel · March 15, 2019, 3:50am

What do you see if you load /update (or /public/update)

system · March 15, 2019, 4:08am

is_executable(): open_basedir restriction in effect. File(/opt/plesk/php/7.2/bin/php) is not within the allowed path(s):

Thank you - so I guess the update scripts may not run, because they are not within the allowed path(s)

hillel · March 15, 2019, 4:11am

I think so

https://invoice-ninja.readthedocs.io/en/latest/update.html

system · March 15, 2019, 4:32am

done. But now I get a sql error executing /update:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'only_notify_owned' (SQL: alter tableusersaddonly_notify_ownedtinyint(1) null default '0')

can I do the sql update scripts manually?

system · March 15, 2019, 4:55am

Thank you Hillel,

I just dropped manually the users.only_notify_owned column - and the /update was successful

hillel · March 16, 2019, 6:29am

Glad to hear it’s working!

robink · April 17, 2019, 1:13pm

Hello Hillel,

I’m getting this same error mentionned : is_executable(): open_basedir restriction in effect. File(/opt/plesk/php/7.2/bin/php) is not within the allowed path(s): (/var/www/vhosts/mysite/:/tmp/)

but on sign-up screen (when submitting the install form) didn’t manage to pass that form yet.(but all connexion tests on bd, mail etc are succesful.

and same error case if I type /update in the url, same error indeed.
I’m in Lastest version 4.5.12

Any advice would be super welcome
many thanks
Robin

robink · April 17, 2019, 1:37pm

Ok found the solution here…
I’m on CEntOS + plesk Onyx.

for information : https://support.plesk.com/hc/en-us/articles/115000278993-A-website-hosted-in-Plesk-is-not-accessible-open-basedir-restriction-in-effect-File-is-not-within-the-allowed-path-s-

hillel · April 17, 2019, 3:45pm

Thanks for sharing the solution!

sasax · November 17, 2019, 9:13am

Same problem here.
I’m at version 4.5.16 selfhosted.

(1/1) RuntimeException
Class ‘\Omnipay\Custom3\Gateway’ not found

in GatewayFactory.php (line 105)

at GatewayFactory->create('\\Omnipay\\Custom3\\Gateway')
at call_user_func_array(array(object(GatewayFactory), 'create'), array('Custom3'))
in Omnipay.php (line 115)
at Omnipay::__callStatic('create', array('Custom3'))
in Gateway.php (line 217)
at Gateway->getFields()
in AccountGatewayController.php (line 138)
at AccountGatewayController->getViewModel()
in AccountGatewayController.php (line 95)
at AccountGatewayController->create()
at call_user_func_array(array(object(AccountGatewayController), 'create'), array())
in Controller.php (line 54)
at Controller->callAction('create', array())
in ControllerDispatcher.php (line 45)
at ControllerDispatcher->dispatch(object(Route), object(AccountGatewayController), 'create')
in Route.php (line 212)
at Route->runController()
in Route.php (line 169)
at Route->run()
in Router.php (line 658)
at Router->Illuminate\Routing\{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in PermissionsRequired.php (line 53)
at PermissionsRequired->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in Authenticate.php (line 122)
at Authenticate->handle(object(Request), object(Closure), 'user')
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in DatabaseLookup.php (line 21)
at DatabaseLookup->handle(object(Request), object(Closure), 'user')
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in StartupCheck.php (line 241)
at StartupCheck->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in QueryLogging.php (line 32)
at QueryLogging->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in DuplicateSubmissionCheck.php (line 41)
at DuplicateSubmissionCheck->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in TransformsRequest.php (line 30)
at TransformsRequest->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in VerifyCsrfToken.php (line 68)
at VerifyCsrfToken->handle(object(Request), object(Closure))
in VerifyCsrfToken.php (line 44)
at VerifyCsrfToken->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in StartSession.php (line 63)
at StartSession->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in AddQueuedCookiesToResponse.php (line 37)
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in EncryptCookies.php (line 66)
at EncryptCookies->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Router.php (line 660)
at Router->runRouteWithinStack(object(Route), object(Request))
in Router.php (line 635)
at Router->runRoute(object(Request), object(Route))
in Router.php (line 601)
at Router->dispatchToRoute(object(Request))
in Router.php (line 590)
at Router->dispatch(object(Request))
in Kernel.php (line 176)
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in InjectDebugbar.php (line 51)
at InjectDebugbar->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in HandlePreflight.php (line 46)
at HandlePreflight->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Kernel.php (line 151)
at Kernel->sendRequestThroughRouter(object(Request))
in Kernel.php (line 116)
at Kernel->handle(object(Request))
in index.php (line 51)

sasax · November 18, 2019, 2:10am

Any help is appreciated.

I remember that i configure PayPal express a long time ago, in early versions.

hillel · November 18, 2019, 8:05pm

It looks similar to this issue:

https://github.com/invoiceninja/invoiceninja/issues/2051

sasax · November 18, 2019, 11:01pm

Thanks for your support.

I have followed your steps. The error now is different.

(1/1) RuntimeException
Class '\Omnipay\Custom3\Gateway' not found
in GatewayFactory.php (line 105)
at GatewayFactory->create('\\Omnipay\\Custom3\\Gateway')
at call_user_func_array(array(object(GatewayFactory), 'create'), array('Custom3'))
in Omnipay.php (line 115)
at Omnipay::__callStatic('create', array('Custom3'))
in Gateway.php (line 217)
at Gateway->getFields()
in AccountGatewayController.php (line 138)
at AccountGatewayController->getViewModel()
in AccountGatewayController.php (line 95)
at AccountGatewayController->create()
at call_user_func_array(array(object(AccountGatewayController), 'create'), array())
in Controller.php (line 54)
at Controller->callAction('create', array())
in ControllerDispatcher.php (line 45)
at ControllerDispatcher->dispatch(object(Route), object(AccountGatewayController), 'create')
in Route.php (line 212)
at Route->runController()
in Route.php (line 169)
at Route->run()
in Router.php (line 658)
at Router->Illuminate\Routing\{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in PermissionsRequired.php (line 53)
at PermissionsRequired->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in Authenticate.php (line 122)
at Authenticate->handle(object(Request), object(Closure), 'user')
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in DatabaseLookup.php (line 21)
at DatabaseLookup->handle(object(Request), object(Closure), 'user')
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in StartupCheck.php (line 241)
at StartupCheck->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in QueryLogging.php (line 32)
at QueryLogging->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in DuplicateSubmissionCheck.php (line 41)
at DuplicateSubmissionCheck->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in TransformsRequest.php (line 30)
at TransformsRequest->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in VerifyCsrfToken.php (line 68)
at VerifyCsrfToken->handle(object(Request), object(Closure))
in VerifyCsrfToken.php (line 44)
at VerifyCsrfToken->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in ShareErrorsFromSession.php (line 49)
at ShareErrorsFromSession->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in StartSession.php (line 63)
at StartSession->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in AddQueuedCookiesToResponse.php (line 37)
at AddQueuedCookiesToResponse->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in EncryptCookies.php (line 66)
at EncryptCookies->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Router.php (line 660)
at Router->runRouteWithinStack(object(Route), object(Request))
in Router.php (line 635)
at Router->runRoute(object(Request), object(Route))
in Router.php (line 601)
at Router->dispatchToRoute(object(Request))
in Router.php (line 590)
at Router->dispatch(object(Request))
in Kernel.php (line 176)
at Kernel->Illuminate\Foundation\Http\{closure}(object(Request))
in Pipeline.php (line 30)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in InjectDebugbar.php (line 51)
at InjectDebugbar->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in CheckForMaintenanceMode.php (line 46)
at CheckForMaintenanceMode->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in HandlePreflight.php (line 46)
at HandlePreflight->handle(object(Request), object(Closure))
in Pipeline.php (line 149)
at Pipeline->Illuminate\Pipeline\{closure}(object(Request))
in Pipeline.php (line 53)
at Pipeline->Illuminate\Routing\{closure}(object(Request))
in Pipeline.php (line 102)
at Pipeline->then(object(Closure))
in Kernel.php (line 151)
at Kernel->sendRequestThroughRouter(object(Request))
in Kernel.php (line 116)
at Kernel->handle(object(Request))
in index.php (line 51)

I put the contents of the tables referred to payments:

gateways


2018-02-21 17:58:00	2018-02-21 17:58:00	Authorize.Net AIM	AuthorizeNet_AIM	1	1	5	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Authorize.Net SIM	AuthorizeNet_SIM	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	CardSave	CardSave	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:46	Eway Rapid	Eway_RapidShared	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	FirstData Connect	FirstData_Connect	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:46	GoCardless	GoCardless	1	2	10000	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Migs ThreeParty	Migs_ThreeParty	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Migs TwoParty	Migs_TwoParty	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:47	Mollie	Mollie	1	1	8	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	MultiSafepay	MultiSafepay	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Netaxept	Netaxept	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	NetBanx	NetBanx	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:47	PayFast	PayFast	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Payflow Pro	Payflow_Pro	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-03-11 13:20:10	PaymentExpress PxPay	PaymentExpress_PxPay	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2019-03-11 13:20:10	PaymentExpress PxPost	PaymentExpress_PxPost	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2019-11-19 09:47:47	PayPal Express	PayPal_Express	1	1	4	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	PayPal Pro	PayPal_Pro	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Pin	Pin	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	SagePay Direct	SagePay_Direct	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:47	SagePay Server	SagePay_Server	1	2	10000	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	SecurePay DirectPost	SecurePay_DirectPost	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Stripe	Stripe	1	1	1	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	TargetPay Direct eBanking	TargetPay_Directebanking	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	TargetPay Ideal	TargetPay_Ideal	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	TargetPay Mr Cash	TargetPay_Mrcash	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:48	TwoCheckout	TwoCheckout	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2019-11-19 09:47:48	WorldPay	WorldPay	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	BeanStream	BeanStream	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Psigate	Psigate	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	moolah	AuthorizeNet_AIM	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Alipay	Alipay_Express	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Buckaroo	Buckaroo_CreditCard	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:48	Coinbase	Coinbase	1	1	10000	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	DataCash	DataCash	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Neteller	Neteller	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Pacnet	Pacnet	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	PaymentSense	PaymentSense	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Realex	Realex_Remote	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Sisow	Sisow	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:48	Skrill	Skrill	1	2	10000	0	NULL	1	0
2018-02-21 17:58:00	2019-11-19 09:47:48	BitPay	BitPay	1	1	7	0	NULL	1	0
2018-02-21 17:58:00	2019-11-19 09:47:48	Dwolla	Dwolla	1	2	6	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	AGMS	Agms	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Barclays	BarclaysEpdq\Essential	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Cardgate	Cardgate	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Checkout.com	CheckoutCom	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Creditcall	Creditcall	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Cybersource	Cybersource	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	ecoPayz	Ecopayz	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Fasapay	Fasapay	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Komoju	Komoju	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Multicards	Multicards	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Pagar.Me	Pagarme	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Paysafecard	Paysafecard	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Paytrace	Paytrace_CreditCard	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Secure Trading	SecureTrading	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	SecPay	SecPay	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	WeChat Express	WeChat_Express	1	2	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:49	WePay	WePay	1	1	3	0	NULL	0	0
2018-02-21 17:58:00	2018-02-21 17:58:00	Braintree	Braintree	1	1	3	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:49	Custom	Custom1	1	1	21	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	FirstData Payeezy	FirstData_Payeezy	1	1	10000	0	NULL	0	0
2018-02-21 17:58:00	2019-11-19 09:47:49	GoCardless	GoCardlessV2\Redirect	1	1	9	0	NULL	1	0
2018-02-21 17:58:00	2018-02-21 17:58:00	PagSeguro	PagSeguro	1	1	10000	0	NULL	0	0
2018-04-13 17:03:13	2018-04-13 17:03:13	PAYMILL	Paymill	1	1	10000	0	NULL	0	0
2018-04-28 16:55:19	2018-04-28 16:55:19	Custom	Custom	1	1	20	0	NULL	1	0
2018-04-28 18:26:32	2019-11-19 09:47:49	Custom	Custom2	1	1	22	0	NULL	1	0
2019-11-19 09:47:50	2019-11-19 09:47:50	Custom	Custom3	1	1	23	0	NULL	1	0

gateways_types


id	alias	name	
1	credit_card	Credit Card	
2	bank_transfer	Bank Transfer	
3	paypal	PayPal	
4	bitcoin	Bitcoin	
5	dwolla	Dwolla	
6	custom1	Custom	
7	alipay	Alipay	
8	sofort	Sofort	
9	sepa	SEPA	
10	gocardless	GoCardless	
11	apple_pay	Apple Pay	
12	custom2	Custom	
13	custom3	Custom

payment_types


id	name	gateway_type_id	
1	Apply Credit    NULL
2	Bank Transfer	2	
3	Cash    NULL
4	Debit	1	
5	ACH	2	
6	Visa Card	1	
7	MasterCard	1	
8	American Express	1	
9	Discover Card	1	
10	Diners Card	1	
11	EuroCard	1	
12	Nova	1	
13	Credit Card Other	1	
14	PayPal	3	
15	Google Wallet    NULL
16	Check	    NULL
17	Carte Blanche	1	
18	UnionPay	1	
19	JCB	1	
20	Laser	1	
21	Maestro	1	
22	Solo	1	
23	Switch	1	
24	iZettle	1	
25	Swish	2	
26	Venmo    NULL
27	Money Order    NULL
28	Alipay	7	
29	Sofort	8	
30	SEPA	9	
31	GoCardless	10	
32	Bitcoin	4	
33	Zelle	    NULL

Thanks in advance.

hillel · November 18, 2019, 11:03pm

Some of the gateway ids are off:

https://github.com/invoiceninja/invoiceninja/blob/master/app/Constants.php#L322

sasax · November 18, 2019, 11:17pm

Could you be a little more specific? Excuse me, I do not understand well that I have to modify. I’m sorry.

sasax · November 18, 2019, 11:44pm

Thanks for everything … it is already working … As always, an outstanding support.

62 2018-02-21 17:58:00	2019-11-19 09:47:49	Custom	Custom1	1	1	8	0	NULL	1	0
67 2018-04-28 18:26:32	2019-11-19 09:47:49	Custom	Custom2	1	1	21	0	NULL	1	0
68 2019-11-19 09:47:50	2019-11-19 09:47:50	Custom	Custom3	1	1	22	0	NULL	1	0

adz16 · June 26, 2023, 9:11pm

does anyone still use trust payments / secure trading for their merchant services?