Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Setting Up Payment Sense Gateway - Asks Me To Edit Db With This - Help Rate Topic   - - - - -

 

Posted 14 October 2019 - 06:30 AM #1

Hi guys.

 

Setting up Payment Sense as a gateway for one of my customers websites

It says I need to edit the database.  

 

This is from the file they send
 

Copy below this line into your sql cscart database.
-----------------------------------------------------------------------------------------------------------
 
 
REPLACE INTO cscart_payment_processors (processor_id, processor, processor_script, processor_template, admin_template, callback, type) 
values ('1000', 'PaymentSense', 'paymentsense_hosted.php', 'views/orders/components/payments/cc_outside.tpl', 'paymentsense_hosted.tpl', 'N', 'P');
 
------------------------------------------------------------------------------------------------------------
 
I don't mess with databases much and don't really know where to start.  I don't even have -cscart_payment_processors - in my DB.  Is that because no payment processors are setup yet?
 
Thanks


 
  • soft-solid
  • Junior Member
  • Members
  • Join Date: 19-Apr 10
  • 897 posts

Posted 14 October 2019 - 02:19 PM #2

Hello

You should have these 3 tables absolutely.

 

cscart_payments

cscart_payment_descriptions

cscart_payment_processors

 

Best regards

Robert


Team of SoftSolid
cs-cart.pl

 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 19782 posts

Posted 15 October 2019 - 05:26 AM #3

- create test.sql file and put mentioned SQL query to the file

- go to Administration -> Backup/Restore page

- click on the Gear -> Upload file

- upload the file and restore it


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    CS-Cart RU                         24500 руб.
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      CS-Cart RU + UniTheme    36000 руб.