Skip to content

Instantly share code, notes, and snippets.

@tilthouse

tilthouse/Error

Created August 23, 2011 15:55
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tilthouse/1165568 to your computer and use it in GitHub Desktop.
Save tilthouse/1165568 to your computer and use it in GitHub Desktop.
Download ZIP
Attempt at new Spree 0.60.1 install
Raw
Error
ActiveRecord::StatementInvalid in ProductsController#index
PGError: ERROR: relation "pages" does not exist
LINE 4: WHERE a.attrelid = '"pages"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"pages"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Raw
Full output from root_url request
Started GET "/" for 127.0.0.1 at 2011-08-23 08:57:11 -0700
SQL (0.3ms) SHOW client_min_messages
SQL (0.2ms) SET client_min_messages TO 'panic'
SQL (0.2ms) SET standard_conforming_strings = on
SQL (0.2ms) SET client_min_messages TO 'notice'
SQL (73.0ms) SET time zone 'UTC'
SQL (0.2ms) SHOW TIME ZONE
SQL (2.5ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.4ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
PK and serial sequence (4.8ms) SELECT attr.attname, seq.relname
FROM pg_class seq,
pg_attribute attr,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relkind = 'S'
AND attr.attrelid = dep.refobjid
AND attr.attnum = dep.refobjsubid
AND attr.attrelid = cons.conrelid
AND attr.attnum = cons.conkey[1]
AND cons.contype = 'p'
AND dep.refobjid = '"products_promotion_rules"'::regclass
PK and custom sequence (2.0ms) SELECT attr.attname,
CASE
WHEN split_part(def.adsrc, '''', 2) ~ '.' THEN
substr(split_part(def.adsrc, '''', 2),
strpos(split_part(def.adsrc, '''', 2), '.')+1)
ELSE split_part(def.adsrc, '''', 2)
END
FROM pg_class t
JOIN pg_attribute attr ON (t.oid = attrelid)
JOIN pg_attrdef def ON (adrelid = attrelid AND adnum = attnum)
JOIN pg_constraint cons ON (conrelid = adrelid AND adnum = conkey[1])
WHERE t.oid = '"products_promotion_rules"'::regclass
AND cons.contype = 'p'
AND def.adsrc ~* 'nextval'
SQL (0.5ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.5ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.3ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
SQL (0.4ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'calculators'
PK and serial sequence (22.5ms) SELECT attr.attname, seq.relname
FROM pg_class seq,
pg_attribute attr,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relkind = 'S'
AND attr.attrelid = dep.refobjid
AND attr.attnum = dep.refobjsubid
AND attr.attrelid = cons.conrelid
AND attr.attnum = cons.conkey[1]
AND cons.contype = 'p'
AND dep.refobjid = '"assemblies_parts"'::regclass
PGError: ERROR: relation "assemblies_parts" does not exist
LINE 14: AND dep.refobjid = '"assemblies_parts"'::re...
^
: SELECT attr.attname, seq.relname
FROM pg_class seq,
pg_attribute attr,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relkind = 'S'
AND attr.attrelid = dep.refobjid
AND attr.attnum = dep.refobjsubid
AND attr.attrelid = cons.conrelid
AND attr.attnum = cons.conkey[1]
AND cons.contype = 'p'
AND dep.refobjid = '"assemblies_parts"'::regclass
PK and serial sequence (0.7ms) SELECT attr.attname, seq.relname
FROM pg_class seq,
pg_attribute attr,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relkind = 'S'
AND attr.attrelid = dep.refobjid
AND attr.attnum = dep.refobjsubid
AND attr.attrelid = cons.conrelid
AND attr.attnum = cons.conkey[1]
AND cons.contype = 'p'
AND dep.refobjid = '"assemblies_parts"'::regclass
PGError: ERROR: relation "assemblies_parts" does not exist
LINE 14: AND dep.refobjid = '"assemblies_parts"'::re...
^
: SELECT attr.attname, seq.relname
FROM pg_class seq,
pg_attribute attr,
pg_depend dep,
pg_namespace name,
pg_constraint cons
WHERE seq.oid = dep.objid
AND seq.relkind = 'S'
AND attr.attrelid = dep.refobjid
AND attr.attnum = dep.refobjsubid
AND attr.attrelid = cons.conrelid
AND attr.attnum = cons.conkey[1]
AND cons.contype = 'p'
AND dep.refobjid = '"assemblies_parts"'::regclass
Processing by ProductsController#index as HTML
SQL (1.4ms) SELECT tablename
FROM pg_tables
WHERE schemaname = ANY (current_schemas(false))
SQL (1.2ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"configurations"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"configurations"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
AppConfiguration Load (1.2ms) SELECT "configurations".* FROM "configurations" WHERE "configurations"."type" = 'AppConfiguration' AND "configurations"."name" = 'Default configuration' LIMIT 1
SQL (0.7ms) SELECT COUNT(*)
FROM pg_tables
WHERE tablename = 'pages'
SQL (0.5ms) SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"pages"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
PGError: ERROR: relation "pages" does not exist
LINE 4: WHERE a.attrelid = '"pages"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"pages"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Completed 500 Internal Server Error in 1872ms
ActiveRecord::StatementInvalid (PGError: ERROR: relation "pages" does not exist
LINE 4: WHERE a.attrelid = '"pages"'::regclass
^
: SELECT a.attname, format_type(a.atttypid, a.atttypmod), d.adsrc, a.attnotnull
FROM pg_attribute a LEFT JOIN pg_attrdef d
ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE a.attrelid = '"pages"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
):
Rendered /Users/boster/.rvm/gems/ruby-1.9.2-p290@fopaws-store/gems/actionpack-3.0.9/lib/action_dispatch/middleware/templates/rescues/_trace.erb (1.4ms)
Rendered /Users/boster/.rvm/gems/ruby-1.9.2-p290@fopaws-store/gems/actionpack-3.0.9/lib/action_dispatch/middleware/templates/rescues/_request_and_response.erb (2.8ms)
Rendered /Users/boster/.rvm/gems/ruby-1.9.2-p290@fopaws-store/gems/actionpack-3.0.9/lib/action_dispatch/middleware/templates/rescues/diagnostics.erb within rescues/layout (10.7ms)
Raw
Gemfile
source 'http://rubygems.org'
gem 'rails', '3.0.9'
gem 'pg'
gem 'ruby-debug19', :require => 'ruby-debug'
gem 'rmagick'
gem 'spree', '~> 0.60.1'
gem 'spree_static_content', :git => 'git://github.com/spree/spree_static_content.git', :branch => 'v0.60.2 '
gem 'spree_product_assembly', :git => 'git://github.com/spree/spree-product-assembly.git', :branch => '0-60-stable'
gem 'spree_editor', :git => "git://github.com/romul/spree_editor.git"
# Dev/Test gems
group :development, :test do
gem 'webrat'
gem 'cucumber-rails'
gem 'rspec-rails'
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment