Error message: 'Status Detail: 3130 : The BillingState value is too long'

[G.W.Green]

If you have american customers and when using Sage Pay, they receive the following error message: -

Status Detail: 3130 : The BillingState value is too long.


NOTE: Before doing this please make a backup of your site by clicking 'File | Snapshot | Export Site'

Go to your 'Site' folder (it will be called 'Site1' if there is no other site within the software which if you have accepted the default installation location you will find in 'Documents\SellerDeck xxxx\Sites\' where 'xxxx' is the version number.

1. Find the file 'ActinicOrder.pm'
2. Open this in a plain text editor such as 'Notepad'.
3. Press Ctrl + F and search for the following:
   
   

   if ("US" eq $sCountryCode)

4. you will see the following block of code
   
   

   if ("US" eq $sCountryCode)
   	{
   	return ($sCountryCode . "." . $sCountryRegion);
   	}

5. delete the block of code
6. After this is done press Ctrl + F and search again for the following:
   
   

   $sReturnRegion eq $ActinicOrder::UNDEFINED_REGION

   you will see the following block of code: -
   
   

    if (($sReturnRegion eq $ActinicOrder::UNDEFINED_REGION))
         {
         if ($sDefaultRegion ne '')
            {
            #
            # No match yet so use default from user if there is one
            #
            $sReturnRegion = $sDefaultRegion;
            }
         }

7. replace the above block of code with the following block of code
   
   

   	if ($sReturnRegion eq $ActinicOrder::UNDEFINED_REGION)
   		{
   		#
   		# PayPal uses the state codes for US addresses for all other countries
   		# including Canada PayPal returns a State/Province/County name
   		#
   	        if ("US" eq $sCountryCode)
   			{
   			#
   			# If country is US and we didn't find a code for the state name then
   			# treat the state name as a state code
   			#
   			if (StateRequiredForValidation('Delivery', $sCountryCode))
   				{
   				$sReturnRegion = $sCountryCode . "." . $sCountryRegion;
   				}
   			}
   
   		if (($sReturnRegion eq $ActinicOrder::UNDEFINED_REGION) &&
   			 ($sDefaultRegion ne ''))
   			{
   			#
   			# No match yet so use default from user if there is one
   			#
   			$sReturnRegion = $sDefaultRegion;
   			}
   		}

8. Once this is done press 'File | Save' and close the document
9. Upload the website ( 'Web | Refresh Website' ).