Common Problems

First of all, when you face any problems with our module, the best place to look for help first its this page or the FAQ page. 

If you don't find the answer on either places, you have two paths, if you are a PRO customer just drop us a line and if you are a CE customer, head to the forums and create a new topic describing your issue.
What information should my email/forum topic should include?
Please be as more specific as possible, attach log files, screenshots, steps to replicate the issue anything relevante to help us solve your problem quickly.

-----------------------------------------------------------------------------------------------------------------------------------------

FORM integration redirecting to Home Page

See this post, it will help you for sure http://ebizmarts.com/forums/topics/view/6454

-----------------------------------------------------------------------------------------------------------------------------------------

4006 INVALID: The TxType requested is not supported on this account.

The TxType field (also called PaymentType in very old protocols) should contain the type of transaction you wish to perform. Values such as PAYMENT, DEFERRED, REFUND etc. as outlined in Sage Pay protocols. 
If any other value is passed within this field, the Sage Pay system will not be able to identify how to process the transaction.
The easiest and fastest way to solve this is calling Sage Pay support team, inform them your vendorname and if you can let them know the txtype you are trying to use, this information can be found on the log files.

PAYPAL: If you are getting this when using PayPal via Sage Pay, you need to call Sage Pay and ask the Service Desk team to enable 'Complete' option at the database level.

-----------------------------------------------------------------------------------------------------------------------------------------

4020 - Information received from an Invalid IP address

One of the most common Sage Pay errors we are asked to solve is the 4020 one.

Actually, this error has nothing to do with the Sage Pay Suite extension, it means that the IP address where the Magento store runs has not been added to the "My Sage Pay" account being used. Most if the times it's pretty easy to solve, just log into your "My Sage Pay" account then go to "Settings -> Valid IPs" and enter your server's IP address.

If you are unsure what your server's IP address is or Sage Pay is still refusing your IP address you can follow a few easy steps in order to get the exact IP address Sage Pay is being contacted from:

1- Get yourself a free Sage Pay Simulator account here.  (or enter our simulator vendorname which is ebizmartssp)
2- Go to your Magento Admin site, then goto System->Configuration->Sales ->Sage Pay->Sage Pay Suite [Global] and set "Vendor" to your Simulator vendor 
3- Then set the Sage Pay Suite extension to "Simulator" Mode, you can do this either in "Sage Pay Suite [SERVER Integration]" or "Sage Pay Suite [DIRECT Integration]" section 
4- Save settings and the refresh cache 
5- Try a new order, you'll still get the 4020 error, but this time Sage Pay will echo back the IP address

If you still experience issues you'll have to email Sage Pay support, include your vendor name, and a screenshot of the alert box showing the 4020 error and the IP address returned by Sage Pay.

-----------------------------------------------------------------------------------------------------------------------------------------

5006 - Unable to redirect to Vendor's web site. The Vendor failed to provide a RedirectionURL.

This is a wildcard error message, it could mean a lot of things but here is a few common issues that might lead to this.
- A firewall is not letting Sage Pay POST information to Magento
- The site is in maintenance mode and restricted only to some ip addresses or any kind of restriction
- Site is protected with username and password not letting people viewing it unles they enter the correct information. On this one it can be bypassed if you only filter GET requests, more information here.
- An error in Magento is happening when the POST data reaches our controller, before or after.
- SSL 3.0 is enabled, Sage Pay does not reach servers that are using SSL 3.0.

-----------------------------------------------------------------------------------------------------------------------------------------

Payment has failed, please reload checkout page and try again. Your card has not been charged.

If you are using the Magento default checkout, this error is usually related to adding minified jquery files during checkout. Try removing those from your checkout layout XML.

If you are not using the Magento default checkout check here for possible compatibility issues.

-----------------------------------------------------------------------------------------------------------------------------------------

Use SID in Frontend set to No

Our integrations require the setting "Use SID in frontend" to be Yes otherwise callbacks may fail and the module won't work properly. This setting can be found under System Configuration General Web
This is the correct configuration

-----------------------------------------------------------------------------------------------------------------------------------------

When clicking on Place Order throws a 500 error or it dies

Something is broken behind the scenes, open up index.php and uncomment
ini_set('display_errors', 1);
also, add this line
Mage::setIsDeveloperMode(true);
Try again and the error should show, either on alert box or using a XHR inspector such as Firebug

-----------------------------------------------------------------------------------------------------------------------------------------

The module could not create the necessary tables on setup

This can happen without any clear reason, it happens in very little occasions but when it does tables have to be created manually by running MySQL queries. You should run the attached file named "queries.sql" on your database, make a backup before you do. Keep in mind that if you are using table prefixes you have to add the prefix on every CREATE TABLE statement on the attached file.

-----------------------------------------------------------------------------------------------------------------------------------------

Error 4028 : The related transaction cannot be found.

If this happens when you try to REPEAT a payment, it is because the original payment is no longer an active transaction as it was cancelled by the vendor. The gateway can only allow Repeat payments made against successful complete transactions.

-----------------------------------------------------------------------------------------------------------------------------------------

"Page NOT found" appears behind SERVER iframe in IE10

This problem is caused by an IE10 BUG for which you can find details here.

-----------------------------------------------------------------------------------------------------------------------------------------

SERVER iframe not showing

If you are using Twitter Bootstrap the problem is probably caused because the "modal" css settings in the bootstrap.css file are overriding our settings.
If you are not using bootstrap modals then you can remove all the "modal" settings in the bootstrap.css file to fix this.

-----------------------------------------------------------------------------------------------------------------------------------------


Google Universal Analytics reporting incorrect referral URL

To avoid getting SagePay internal URLs on your GA referrals you'll need to add their domains to the exclusion list as follows:


-----------------------------------------------------------------------------------------------------------------------------------------

Clearing TEST orders
If you clear Magento's orders for some reason, you should also delete -backup first- related data from these tables:
  1. sagepaysuite_action
  2. sagepaysuite_paypaltransaction
  3. sagepayreporting_fraud
  4. sagepaysuite_tokencard
  5. sagepaysuite_transaction

Subpages (1): 3rd Party modules
ċ
queries.sql
(7k)
Pablo Benitez,
Sep 4, 2012, 8:33 AM
Comments