Just a quick post on how to adjust the timezone on Heroku, comes in handy when using the log files.
$ heroku config:add TZ=Australia/Brisbane
There is a fairly detailed StackOverflow post at the following link if anyone is interested in more info:
The language options can also be found on the following wikipedia page:
Just a quick post on how to select the number of weekdays between two dates:
SELECT (TRUNC(TO_DATE ('01/08/2012', 'DD/MM/YYYY'), 'dd') + LEVEL - 1) days
CONNECT BY LEVEL <= TO_CHAR(TO_DATE('10/08/2012', 'DD/MM/YYYY') - TO_DATE('01/08/2012', 'DD/MM/YYYY'))
WHERE TO_CHAR(temp_tbl.days, 'D') >= 2
AND TO_CHAR(temp_tbl.days, 'D') <= 6
I ran into a bit of an issue in Rails Cast #142. I received the following error while testing the IPN:
WARNING: Can't verify CSRF token authenticity
Completed 500 Internal Server Error in 2ms
Simply replace the following line with the alternative below it:
protect_from_forgery :except => [:create]
skip_before_filter :verify_authenticity_token, :only => [:create]
A quick post on how to send an email with PL/SQL.
There’s a LOT of documentation available at the following link:
PROCEDURE EMAIL_ERROR_REPORT IS
/* Create vars */
v_From VARCHAR2 (80) := 'email@example.com';
v_Recipient VARCHAR2 (80) := 'firstname.lastname@example.org';--REPORT_RECEIVER;
v_Subject VARCHAR2 (80) := 'test subject';
v_Mail_Host VARCHAR2 (30) := 'smtp.test.com';
crlf VARCHAR2 (2) := CHR (13) || CHR (10);
/* Define connection */
v_Mail_Conn := UTL_SMTP.Open_Connection (v_Mail_Host, 25);
UTL_SMTP.Helo (v_Mail_Conn, v_Mail_Host);
UTL_SMTP.Mail (v_Mail_Conn, v_From);
UTL_SMTP.Rcpt (v_Mail_Conn, v_Recipient);
|| TO_CHAR (SYSDATE, 'Dy, DD Mon YYYY hh24:mi:ss')
|| 'From: '
|| 'Subject: '
|| 'To: '
|| 'some message text'
|| -- Message body
'more message text'
/* Catch exceptions */
--WHEN OTHERS THEN
Ran into the following problem, still not too sure what caused it but this seems to have fixed it:
cannot generate tempfile `/home/chris/cartsite/tmp/cache/assets/sprockets%2Fd585a06e2ee6203ccb04c8b84150d14d20120804-8682-7q77nb-9'
Just run the following:
Let me know if you come across the cause, I’d be interested to know.
This is the SDK for PayPal adaptive payments. I’ve just uploaded it to *hopefully* make it a little easier to find. Please note that it has not been updated recently and that there are a few changes to be made. The StackOverflow post below provides a few examples:
Adaptive Payments with Ruby
I’ll try to list any others as I come across them, but if you’ve got some of your own please let me know and I’ll try to keep the post up to date.
Download SDK here:
Paypal Platform SDK
Internal Server Error
undefined method `debug_rjs=' for ActionView::Base:Class
Remove the following line from your development.rb config file:
# Settings specified here will take precedence over those in config/environment.rb
# In the development environment your application's code is reloaded on
# every request. This slows down response time but is perfect for development
# since you don't have to restart the webserver when you make code changes.
config.cache_classes = false
# Log error messages when you accidentally call methods on nil.
config.whiny_nils = true
# Show full error reports and disable caching
config.consider_all_requests_local = true
#config.action_view.debug_rjs = true <---- Comment this line out (no longer supported)
config.action_controller.perform_caching = false
# Don't care if the mailer can't send
config.action_mailer.raise_delivery_errors = false
# Print deprecation notices to the Rails logger
config.active_support.deprecation = :log
# Only use best-standards-support built into browsers
config.action_dispatch.best_standards_support = :builtin
Paypal IPN History:
For some reason the IPN history button often won’t appear in the sandbox, use the following link to view it:
Just a warning for anyone else setting up payments with PayPal, the sandbox IPN is extremely flaky. It has gone down twice in the last six months for weeks at a time, with no warning or error messages. If you’re not receiving the IPN check out the forums to make sure it’s not down.