CiviCRM Community Forums (archive)

Does " been all over our configuration pages" include going to administer>system settings>payment processors, selecting the paypal processor and checking that the button url is indeed the US url you want?

can you try your contribution in a different browser as an anonymous user

alternatively, clear any and all your cookies associated with paypal and see if that works

in general, when people ask questions, its to ensure things have happened rather than imply anything else

lobo

Have you tried a test using a different PC/laptop?  I wonder whether the operating system locale on your machine is set to the UK.

What happens when you logon (manually) to your production Paypal website, using the "Merchant Account Email" address that's in your payment processor settings?  Do you go to the US site?

Success!  And on the off chance that others find themselves in this situation, I have outlined below the steps necessary to resolve it.  Not sure just what went south, but I finally bit the bullet and did a full uninstall/reinstall of CiviCRM.  I attempted just about every other partial recovery I could think of to avoid a full uninstall/reinstall, they did not work, so save yourself the time! The steps below are basically the same steps to follow when moving CiviCRM from one hosting provider to another, so if you have done that, then you already know what to do!  Anyone who hasn't, read on ...

1. MOST IMPORTANT: Backup full site and db.
2. Using phpMyAdmin, export only CiviCRM tables excluding:
        civicrm_acl_cache
        civicrm_acl_contact_cache
        civicrm_cache
        civicrm_domain
        civicrm_group_contact_cache
    Making sure to check the "Disable foreign key checks" option and Under Object Creation Options
    check the "Add DROP TABLE / VIEW / PROCEDURE / FUNCTION / EVENT statement"option.
3. Uninstall CiviCRM.
4. IMPORTANT: Delete all CiviCRM db tables via phpMyAdmin. Just uninstalling and reinstalling will not work, tried it!
5. Reinstall CiviCRM.
6. Using phpMyAdmin, import the db export file created in step 2.
7. Using phpMyAdmin, issue the following SQL commands (these are probably unnecessary since you have a fresh install, but you never know!):
         CiviCRM db:
            truncate civicrm_uf_match;
            update civicrm_domain set config_backend = null;
         Joomla db:
            truncate com_session;
8. In /media/civicrm, delete the folder "templates_c". A new one will be created when CiviCRM is run.
 
9. Navigate to the CiviCRM Configuration Checklist and review the setting to make sure that they are correct.
 
10. If you have custom data profiles set up in your civiCRM, they may be present but for some unknown reason not be active. Go to your Administer >> Customize >> Custom Data and select "View and Edit Custom Fields". Select "Edit Field" for any one of the custom fields in the group and save it without making any changes. This will make civiCRM aware of the custom data fields and everything should be back on track.

11. If you have CMS user Profiles that relate to the civiCRM contacts, you will want to run "Synchronize Users to Contacts". It can be found at Administer >> Manage >> Synchronize Users to Contacts 

11. Reconfigure Captcha (if using).

12. I am sure others have more complex setups that we do, so you may have other elements that need to be addressed.  This is just what worked for us.

So, there you go!  Once all that was done, we were back in business.  If anyone has any ideas as to what we did that caused it all to go crazy, I would love to know so we don't EVER do it again!

Thanks to everyone who offered assistance.

Patrece