I think sometimes you are trying hard to resolve issue and at the end you found oops this was the problem. It happened again with me .
Everything working fine and suddenly oops “Facebook payment API not working” .
I checked my code somehow trapped the error code.Google it and found that the callback page not working properly.
so I tried to call it explicitly as I do and found it was working spent few hours wrote whole new code to make sure everything should work as is but not got any success.
Then by god grace an idea came to my mind to check actual call back page define Facebook app setting.
Dam, this was the reason actually in payment callback URL by mistake it was https while there was no certificate installed on site .
I just turned it to http and you know what miracle again. Now Facebook payment API working.
This is surely a learning lesson for me to check the basic first and if someone struggling same problem I urge you to check the callback URL first.
I puzzled lot but ultimately going for sleep with happy ending.
Sometimes it happened when this kind of issue came you did everything according to basic rules for database mail setting in SQL Server and when you try to send the mail through SQL server you got error
"Exception Type: System.NullReferenceException
Message: Object reference not set to an instance of an object.
TargetSite: Microsoft.SqlServer.Management.SqlIMail.Server.Objects.Account GetAccount(Int32)”
When you tried to resolve it you search a lot of google you did not get a proper result.
I faced this problem with SQL Server 2005 edition with SQL Server Service Pack1.
Here I am sharing how simple to resolve this. Simplest step is to Update SQL server service Pack 2 & SQL server service pack 3.
You can download SQL server service pack 2 with link http://www.microsoft.com/en-us/download/details.aspx?id=9969
and SQL server Service pack 3 with link http://www.microsoft.com/en-us/download/details.aspx?id=14752
Once you install it and after restart your SQL server mail function started Isn’t it simple.
I hope this resolve the problem of my friends who searched a lot on Google but could not get a proper solution.
Thanks & Best Regards,