spree/spree — Issue #1100: Error on checkout when hosting on Heroku
Author: abepetrillo
Created: 2012-02-05 20:23:54+00:00
State: open

ActiveRecord::StatementInvalid (PGError: ERROR: relation "pending_promotions" does not exist

The above happens after adding a product to the cart then proceeding the checkout on a somewhat fresh install.

Modifications include

Theme,
Paypal Gateway in test mode is active,
AWS-S3,
spree_heroku gem installed

Haven't found any others having this issue, but here is the heroku logs (I use mysql for development).

```bash
2012-02-05T20:17:43+00:00 app[web.1]: Started GET "/checkout" for 109.76.17.241 at 2012-02-05 12:17:43 -0800
2012-02-05T20:17:43+00:00 app[web.1]:
2012-02-05T20:17:43+00:00 app[web.1]: ActiveRecord::StatementInvalid (PGError: ERROR: relation "pending_promotions" does not exist
2012-02-05T20:17:43+00:00 app[web.1]: : SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
2012-02-05T20:17:43+00:00 app[web.1]: FROM pg_attribute a LEFT JOIN pg_attrdef d
2012-02-05T20:17:43+00:00 app[web.1]: ON a.attrelid = d.adrelid AND a.attnum = d.adnum
2012-02-05T20:17:43+00:00 app[web.1]: WHERE a.attrelid = '"pending_promotions"'::regclass
2012-02-05T20:17:43+00:00 app[web.1]: AND a.attnum > 0 AND NOT a.attisdropped
2012-02-05T20:17:43+00:00 app[web.1]: ORDER BY a.attnum
2012-02-05T20:17:43+00:00 app[web.1]: ):
```