adva-cms2
tonymi
instructions.
christopher floess
I've updated the readme. Here's the part that I think is relevant to you
(or at least the part that I added :)
Get adva-cms2:
$ git clone git://github.com/svenfuchs/adva-cms2
$ cd adva-cms2
$ bundle install
Generate a new app and run it:
$ thor adva:app /home/user/path/to/app
$ cd /home/user/path/to/app
$ bundle install
$ rails s
Now in your browser navigate to http://localhost:3000. Fill out the
fields in the resulting page and click 'Create Site'. After this you
can log in to your new site with the credentials 'ad...@admin.org' and
password 'admin!'.
I hope that helps.
-- Chris
tonymi
Did run into the following problems during installation:
1) thor adva:app /home/user/path/to/app
This command even though I gave it an absolute path created the app
relative to the adva-cms2 directory. ( My OS is ubuntu)
2) The 'bundle install' command for the app:
This failed. I had to edit the Gemfile for it to work.
adva_cms = repository('/absolute-path-to-adva-cms2', :source
=> :local)
Also, is there an easy way to create the app against a different
database other than sqlite?
On Nov 22, 7:41 am, christopher floess <skepti...@gmail.com> wrote:
> Hi,
>
> I've updated the readme. Here's the part that I think is relevant to you
> (or at least the part that I added :)
>
> Get adva-cms2:
> $ git clone git://github.com/svenfuchs/adva-cms2
> $ cd adva-cms2
> $ bundle install
>
> Generate a new app and run it:
> $ thor adva:app /home/user/path/to/app
> $ cd /home/user/path/to/app
> $ bundle install
> $ rails s
>
christopher floess
On 11/23/2010 09:05 PM, tonymi wrote:
> Thanks Chris. Was able to install and run the application.
>
> Did run into the following problems during installation:
> 1) thor adva:app /home/user/path/to/app
> This command even though I gave it an absolute path created the app
> relative to the adva-cms2 directory. ( My OS is ubuntu)
You're right. It doesn't look like a huge issue, but a warning might
about absolute paths might be nice. On the other hand, you can also run
$ REGENERATE_APP=1 rake
This will generate /tmp/adva-cms2-test, which you can then copy where
ever you like and rename it as you like.
> 2) The 'bundle install' command for the app:
> This failed. I had to edit the Gemfile for it to work.
> adva_cms = repository('/absolute-path-to-adva-cms2', :source
> => :local)
It might be worth updating the README as a heads-up, but it's actually
in there to ensure that the adva engines are installed based on your
local changes to them.
But if you're not developing them (which might not be advisable at atm),
then you can probably comment this line out all together, since the gems
are published. Just make sure you make all the lines that look like this:
adva_cms.gem 'adva-core'
adva_cms.gem 'adva-blog'
adva_cms.gem 'adva-cache'
adva_cms.gem 'adva-categories'
adva_cms.gem 'adva-static'
adva_cms.gem 'adva-user'
adva_cms.gem 'adva-markup'
look like this:
gem 'adva-core'
gem 'adva-blog'
gem 'adva-cache'
gem 'adva-categories'
gem 'adva-static'
gem 'adva-user'
gem 'adva-markup'
> Also, is there an easy way to create the app against a different
> database other than sqlite?
mmm, in that case you would need to run the migrations again after
updating config/database.yml. The thor tasks don't have the ability to
specify a database yet.
Cheers,
Chris
Cynthia Kiser
Also, is there an easy way to create the app against a differentmmm, in that case you would need to run the migrations again after updating config/database.yml. The thor tasks don't have the ability to specify a database yet.database other than sqlite?
So your code actually runs against sqlite3? I installed and generated a new app but when I fired it up for the first time, it bailed out at the initial site instance creation step complaining that it didn't know about GROUP_CONCAT
SQLite3::SQLException: no such function: GROUP_CONCAT: UPDATE "sections"
SET level = (SELECT COUNT("l"."id") FROM "sections" "l"
WHERE "l"."lft" < "sections"."lft" AND "l"."rgt" > "sections"."rgt"
AND ("l"."site_id" = 1)),path = (SELECT GROUP_CONCAT(slug, '/')
FROM "sections" "l" WHERE "l"."lft" <= "sections"."lft" AND "l"."rgt" >= "sections"."rgt"
AND ("l"."site_id" = 1)) WHERE ("sections"."site_id" = 1)
More complete error: https://gist.github.com/759555
Since Google told me GROUP_CONCAT exists in MySQL, I thought that might help. So I changed my database.yml file and ran rake db:migrate and rake db:seed by hand. That changed the error - but at the same step:
Mysql2::Error: You can't specify target table 'sections' for update in FROM clause: UPDATE `sections`
SET level = (SELECT COUNT(`l`.`id`) FROM `sections` `l`
WHERE `l`.`lft` < `sections`.`lft` AND `l`.`rgt` > `sections`.`rgt`
AND (`l`.`site_id` = 1)),path = (SELECT GROUP_CONCAT(`slug`, '/') FROM `sections` `l`
WHERE `l`.`lft` <= `sections`.`lft` AND `l`.`rgt` >= `sections`.`rgt` AND (`l`.`site_id` = 1))
WHERE (`sections`.`site_id` = 1)
SQL (11.4ms) ROLLBACK
Completed in 684ms
ActiveRecord::StatementInvalid (Mysql2::Error: You can't specify target table 'sections' for update in FROM clause:
UPDATE `sections` SET level = (SELECT COUNT(`l`.`id`) FROM `sections` `l`
WHERE `l`.`lft` < `sections`.`lft` AND `l`.`rgt` > `sections`.`rgt`
AND (`l`.`site_id` = 1)),path = (SELECT GROUP_CONCAT(`slug`, '/')
FROM `sections` `l` WHERE `l`.`lft` <= `sections`.`lft` AND `l`.`rgt` >= `sections`.`rgt`
AND (`l`.`site_id` = 1)) WHERE (`sections`.`site_id` = 1)):
Versions info:
OS: CentOS 5
Sqlite: installed from CentOS rpm sqlite-3.3.6-5
Sqlite ruby gem: sqlite3-ruby (1.2.5)
Ruby: ruby 1.8.7 (2010-08-16 patchlevel 302) [i686-linux]
--
Cynthia Kiser
cynthi...@gmail.com
PS Could you also update your install docs to say that adva-cms2 needs Ruby 1.8.7. I initially tried to install using Ruby 1.9.2 but one of the deep dependencies - linecache - complained it didn't support 1.9.2 yet.
Installing linecache (0.43) with native extensions /home/cnk/.rvm/rubies/ruby-1.9.2-p0/lib/ruby/1.9.1/rubygems/installer.rb:483:in `rescue in block in build_extensions': ERROR: Failed to build gem native extension. (Gem::Installer::ExtensionBuildError)
/home/cnk/.rvm/rubies/ruby-1.9.2-p0/bin/ruby extconf.rb
Can't handle 1.9.x yet
*** extconf.rb failed ***
Torsten Becker
--
You received this message because you are subscribed to the Google Groups "adva-cms" group.
To post to this group, send email to adva...@googlegroups.com.
To unsubscribe from this group, send email to adva-cms+u...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/adva-cms?hl=en.
christopher floess
I run all of my tests with sqlite3. I also just generated an app, ran
'rails s' and created a site without problems.
Here are my system details:
OS: arch linux
Sqlite: 3.7.4-1
Sqlite ruby gem: 1.2.5
Ruby: 1.8.7-p302
It seems like your sqlite version is pretty old. We don't run CentOS,
but our Debian machines run Lenny and that Sqlite verison is already at
3.5.9-6, and Debian doesn't exactly have a reputation for using
cutting-edge software :)
Could you check to see if there are updates for your package available?
-- Chris
> cynthi...@gmail.com <mailto:cynthi...@gmail.com>
>
>
>
> PS Could you also update your install docs to say that adva-cms2 needs
> Ruby 1.8.7. I initially tried to install using Ruby 1.9.2 but one of
> the deep dependencies - linecache - complained it didn't support 1.9.2
> yet.
>
> Installing linecache (0.43) with native extensions
> /home/cnk/.rvm/rubies/ruby-1.9.2-p0/lib/ruby/1.9.1/rubygems/installer.rb:483:in
> `rescue in block in build_extensions': ERROR: Failed to build gem
> native extension. (Gem::Installer::ExtensionBuildError)
>
> /home/cnk/.rvm/rubies/ruby-1.9.2-p0/bin/ruby extconf.rb
> Can't handle 1.9.x yet
> *** extconf.rb failed ***
Cynthia Kiser
It seems like your sqlite version is pretty old. We don't run CentOS, but our Debian machines run Lenny and that Sqlite verison is already at 3.5.9-6, and Debian doesn't exactly have a reputation for using cutting-edge software :)
Yes I think the issue is that my sqlite is too old. There are no RH-distributed updates that are newer than what I have. If I were motivated to use sqlite, I could always compile it myself. But it is one of the few databases I don't routinely use so...
I already had a postgresql installed on the machine and was only not using it because the ruby postgres gem didn't compile when I tried it a year ago. Updates to the gem seem to have fixed that - so I get further in the site setup before it fails.
PostgreSQL: 8.3.0
Ruby gem: pg (0.10.0)
Ruby 1.8.7 (2010-08-16 patchlevel 302)
Rails 3.0.3
Still on POST "/installations"
Full request info: https://gist.github.com/760836
I am getting a feeling new hosting should be in my future - but was hoping to spend the first part of the new year playing with Adva CMS, not setting up a new VM.
Cynthia Kiser
cynthi...@gmail.com
christopher floess
thanks for your patience with this. Would you mind giving me a little
more thorough run-down of what you're doing (verbatim copy and paste of
commands is no problem!).
I've spent quite a bit of time working with someone else on the list
about their issues (
http://groups.google.com/group/adva-cms/browse_thread/thread/de80644191ba613f
), and I have no problem doing the same with you. We have a pretty
diverse array of systems on which the install instructions work, and I
would love to make sure they work on your system as well.
Here's a summary of commands I did:
1. Before the step "bundle install" in the read me under "Generate a new
app...", I edited the Gemfile to like as follows:
[chrisf@turnstile adva_app]$ cat Gemfile
require File.expand_path('../lib/bundler/repository', __FILE__)
source :rubygems
workspace '. ~/.projects ~/projects ~/Development/{projects,work}
~/.repositories'
adva_cms = repository('adva-cms2', :source => 'http://rubygems.org')
adva_cms.gem 'adva-core'
adva_cms.gem 'adva-blog'
adva_cms.gem 'adva-cache'
adva_cms.gem 'adva-categories'
adva_cms.gem 'adva-static'
adva_cms.gem 'adva-user'
adva_cms.gem 'adva-markup'
group :test do
gem 'sqlite3-ruby', '1.2.5'
gem 'cucumber', '0.9.4'
gem 'cucumber-rails', '0.3.2'
gem 'webrat', '0.7.2'
gem 'thor'
gem 'ruby-debug'
gem 'mocha'
gem 'fakefs', :require => 'fakefs/safe'
gem 'test_declarative'
gem 'database_cleaner', '0.5.2'
gem 'launchy'
gem 'factory_girl', '1.3.2'
end
gem 'pg'
[chrisf@turnstile adva_app]$
You can probably copy and paste this into your Gemfile. Next, I also
edited config/database.yml to look as follows:
[chrisf@turnstile adva_app]$ cat config/database.yml
defaults: &defaults
adapter: postgresql
encoding: utf8
username: 'chris'
password: 'p866wor3'
pool: 5
# default would be "connect via socket"
host: 127.0.0.1
port: 5432
# Minimum log levels, in increasing order:
# debug5, debug4, debug3, debug2, debug1,
# log, notice, warning, error, fatal, and panic
# The server defaults to notice.
min_messages: warning
development:
database: adva_app_development
min_messages: notice
<<: *defaults
test:
database: adva_app_test
<<: *defaults
production:
database: adva_app_production
<<: *defaults
[chrisf@turnstile adva_app]$
Of course the login specifics would be different for your setup, but
then I ran:
[chrisf@turnstile adva_app]$ rake db:drop db:create db:migrate #
db:drop, just in case it already exists
I didn't have any problems there, so I ran "rails s" and the output
you'll find at the end of this email.
There weren't any problems though. Did you follow the same steps? Here
are my system specifics again:
Linux: Arch Linux
Ruby: ruby-1.8.7-p302
Postgres adapter: pg 0.10.0
Postgres version: 9.0.2-2
I know that you're on postgres 9.3 (or similar), but I don't imagine
that to be the issue, if you can't get this set up correctly with your
Postgres version, I might be able to set up a virtual machine with
CentOS and give it another try.
I did have this set up with prior versions of Postgres (9.3 and 9.4)
though, and also had no problems.
Okay, good luck. Report back.
-- Chris
********** OUTPUT FOR 'rails s' ****************
[chrisf@turnstile adva_app]$ rails s
=> Booting WEBrick
=> Rails 3.0.3 application starting in development on http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server
[2011-01-01 14:46:34] INFO WEBrick 1.3.1
[2011-01-01 14:46:34] INFO ruby 1.8.7 (2010-08-16) [x86_64-linux]
[2011-01-01 14:46:35] INFO WEBrick::HTTPServer#start: pid=3902 port=3000
cache: [GET /admin/sites/1/pages/1] miss
Started GET "/admin/sites/1/pages/1" for 127.0.0.1 at Sat Jan 01
14:46:41 +0100 2011
SQL (0.1ms) SET client_min_messages TO 'notice'
SQL (0.4ms) SHOW client_min_messages
SQL (0.1ms) SET client_min_messages TO 'panic'
SQL (0.1ms) SET standard_conforming_strings = on
SQL (0.1ms) SET client_min_messages TO 'notice'
SQL (0.5ms) SET time zone 'UTC'
SQL (0.1ms) SHOW TIME ZONE
Processing by Admin::PagesController#show as HTML
Parameters: {"id"=>"1", "site_id"=>"1"}
SQL (2.7ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.6ms) SELECT "users".* FROM "users" WHERE ("users"."id" = 1)
LIMIT 1
Completed in 7ms
cache: [GET /user/sign_in?return_to=%2Fadmin%2Fsites%2F1%2Fpages%2F1] miss
Started GET "/user/sign_in?return_to=%2Fadmin%2Fsites%2F1%2Fpages%2F1"
for 127.0.0.1 at Sat Jan 01 14:46:41 +0100 2011
SQL (0.9ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.7ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.8ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.5ms) SELECT COUNT(*) FROM "sites"
SQL (0.6ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.6ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
Processing by User::SessionsController#new as HTML
Parameters: {"return_to"=>"/admin/sites/1/pages/1"}
SQL (0.9ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-user-0.0.5/app/views/user/sessions/new.html.rb
within layouts/user (116.3ms)
Completed 200 OK in 133ms (Views: 121.6ms | ActiveRecord: 5.0ms)
cache: [GET /] miss
Started GET "/" for 127.0.0.1 at Sat Jan 01 14:46:49 +0100 2011
SQL (1.1ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.8ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "sites"
SQL (0.6ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.2ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
cache: [GET /installations/new] miss
Started GET "/installations/new" for 127.0.0.1 at Sat Jan 01 14:46:49
+0100 2011
SQL (0.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.9ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "sites"
SQL (0.7ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.2ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
Processing by InstallationsController#new as HTML
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
SQL (0.8ms) 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 = '"accounts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
WARNING: Can't mass-assign protected attributes: type
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-core-0.0.5/app/views/installations/new.html.rb
within layouts/simple (84.0ms)
Completed 200 OK in 126ms (Views: 96.5ms | ActiveRecord: 4.2ms)
cache: [POST /installations] invalidate, pass
Started POST "/installations" for 127.0.0.1 at Sat Jan 01 14:46:56 +0100
2011
SQL (0.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.3ms) SELECT COUNT(*) FROM "sites"
SQL (1.0ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.3ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
Processing by InstallationsController#create as HTML
Parameters: {"commit"=>"Create Site",
"authenticity_token"=>"yQeQ6a+MuSgtQuHswLFZe/vkTbt51DCaqCGoQLRqNjs=",
"utf8"=>"✓", "site"=>{"name"=>"somesite",
"sections_attributes"=>{"0"=>{"name"=>"Home", "type"=>"Page"}}}}
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE ("sites"."host" =
'localhost:3000') LIMIT 1
SQL (1.0ms) 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 = '"accounts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.3ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
WARNING: Can't mass-assign protected attributes: type
SQL (0.2ms) BEGIN
Site Load (0.3ms) SELECT "sites"."id" FROM "sites" WHERE ("sites"."host"
= 'localhost:3000') LIMIT 1
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.9ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Section Load (0.8ms) SELECT "sections".* FROM "sections" WHERE
("sections"."site_id" IS NULL) AND ("sections"."slug" ILIKE 'home%')
ORDER BY lft
** has_many_polymorphs: associating Category.categorizables
SQL (1.1ms) 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 = '"categorizations"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.1ms) 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 = '"contents"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
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 = '"contents"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.0ms) 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 = '"contents"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.4ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (5.9ms) SELECT "users"."id" FROM "users" WHERE
(LOWER("users"."email") = LOWER('ad...@admin.org')) LIMIT 1
PK and serial sequence (2.6ms) 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 = '"accounts"'::regclass
SQL (0.4ms) 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 = '"accounts"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.6ms) INSERT INTO "accounts" VALUES(DEFAULT) RETURNING "id"
PK and serial sequence (2.6ms) 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 = '"users"'::regclass
SQL (0.6ms) INSERT INTO "users" ("reset_password_token",
"encrypted_password", "password_salt", "sign_in_count",
"last_sign_in_ip", "created_at", "current_sign_in_at", "remember_token",
"last_sign_in_at", "confirmation_sent_at", "email", "confirmed_at",
"updated_at", "remember_created_at", "account_id", "roles",
"confirmation_token", "current_sign_in_ip") VALUES (NULL,
'$2a$10$v4kD3D8hn1N6NTNsC9y/CublOva910zkzAYC2GwAERtWOT/An6wHq',
'$2a$10$v4kD3D8hn1N6NTNsC9y/Cu', 0, NULL, '2011-01-01 13:46:57.676676',
NULL, NULL, NULL, NULL, 'ad...@admin.org', NULL, '2011-01-01
13:46:57.676676', NULL, 1, NULL, NULL, NULL) RETURNING "id"
PK and serial sequence (2.9ms) 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 = '"sites"'::regclass
SQL (0.7ms) INSERT INTO "sites" ("created_at", "name", "host",
"account_id", "subtitle", "updated_at", "title", "timezone") VALUES
('2011-01-01 13:46:57.682521', 'somesite', 'localhost:3000', 1, '',
'2011-01-01 13:46:57.682521', 'somesite', NULL) RETURNING "id"
SQL (0.6ms) SELECT MAX("sections"."rgt") AS max_id FROM "sections" WHERE
("sections"."site_id" = 1)
PK and serial sequence (3.3ms) 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 = '"sections"'::regclass
SQL (0.7ms) INSERT INTO "sections" ("parent_id", "level", "type",
"updated_at", "rgt", "path", "lft", "created_at", "name", "site_id",
"options", "slug") VALUES (NULL, NULL, 'Page', '2011-01-01
13:46:57.691080', 2, '', 1, '2011-01-01 13:46:57.691080', 'Home', 1,
NULL, 'home') RETURNING "id"
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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.4ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
AREL (1.9ms) UPDATE "sections" SET level = (SELECT COUNT("l"."id") FROM
"sections" "l" WHERE "l"."lft" < "sections"."lft" AND "l"."rgt" >
"sections"."rgt" AND ("l"."site_id" = 1)),path = (SELECT
array_to_string(array_agg("slug"), '/') FROM "sections" "l" WHERE
"l"."lft" <= "sections"."lft" AND "l"."rgt" >= "sections"."rgt" AND
("l"."site_id" = 1)) WHERE ("sections"."site_id" = 1)
PK and serial sequence (5.0ms) 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 = '"contents"'::regclass
SQL (1.1ms) INSERT INTO "contents" ("site_id", "filter", "type",
"body_html", "title", "created_at", "section_id", "body",
"published_at", "updated_at", "slug") VALUES (1, NULL, 'Article', '',
'Home', '2011-01-01 13:46:57.709499', 1, '', NULL, '2011-01-01
13:46:57.709499', '') RETURNING "id"
SQL (1.3ms) COMMIT
SQL (0.2ms) BEGIN
AREL (0.9ms) UPDATE "users" SET "confirmed_at" = '2011-01-01
13:46:57.724372', "updated_at" = '2011-01-01 13:46:57.725586', "roles" =
NULL WHERE ("users"."id" = 1)
SQL (0.7ms) COMMIT
Redirected to http://localhost:3000/installations/1
Completed 302 Found in 580ms
cache: [GET /installations/1] miss
Started GET "/installations/1" for 127.0.0.1 at Sat Jan 01 14:46:57
+0100 2011
SQL (0.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.7ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.8ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.3ms) SELECT COUNT(*) FROM "sites"
Site Load (0.2ms) SELECT "sites".* FROM "sites" LIMIT 1
SQL (0.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Section Load (0.4ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) AND ("sections"."parent_id" IS NULL) ORDER BY
lft LIMIT 1
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" LIMIT 1
Section Load (0.4ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) ORDER BY lft
Section Load (0.3ms) SELECT "sections".* FROM "sections" WHERE
("sections"."site_id" = 1) AND ("sections"."rgt" = 0) ORDER BY lft LIMIT 1
Processing by InstallationsController#show as HTML
Parameters: {"id"=>"1"}
SQL (1.0ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.3ms) SELECT "sites".* FROM "sites" WHERE ("sites"."id" = 1)
LIMIT 1
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-core-0.0.5/app/views/installations/show.html.rb
within layouts/simple (22.6ms)
Completed 200 OK in 46ms (Views: 41.8ms | ActiveRecord: 14.7ms)
Rack::Cache::Tags::Store::ActiveRecord::Tagging Load (0.7ms) SELECT
"cache_taggings".* FROM "cache_taggings" WHERE (url =
'http://localhost:3000/installations/1' AND tag IN ('site-1'))
SQL (1.0ms) 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 = '"cache_taggings"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.1ms) BEGIN
SQL (0.9ms) 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 = '"cache_taggings"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
PK and serial sequence (3.4ms) 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 = '"cache_taggings"'::regclass
SQL (0.6ms) INSERT INTO "cache_taggings" ("tag", "url") VALUES
('site-1', 'http://localhost:3000/installations/1') RETURNING "id"
SQL (0.8ms) COMMIT
cache: [GET /admin/sites/1] miss
Started GET "/admin/sites/1" for 127.0.0.1 at Sat Jan 01 14:46:59 +0100 2011
SQL (1.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.0ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Processing by Admin::SitesController#show as HTML
Parameters: {"id"=>"1"}
Completed in 9ms
cache: [GET /user/sign_in?return_to=%2Fadmin%2Fsites%2F1] miss
Started GET "/user/sign_in?return_to=%2Fadmin%2Fsites%2F1" for 127.0.0.1
at Sat Jan 01 14:46:59 +0100 2011
SQL (0.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.3ms) SELECT COUNT(*) FROM "sites"
Site Load (0.3ms) SELECT "sites".* FROM "sites" LIMIT 1
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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Section Load (0.4ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) AND ("sections"."parent_id" IS NULL) ORDER BY
lft LIMIT 1
SQL (1.0ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" LIMIT 1
Section Load (0.5ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) ORDER BY lft
Section Load (0.5ms) SELECT "sections".* FROM "sections" WHERE
("sections"."site_id" = 1) AND ("sections"."rgt" = 0) ORDER BY lft LIMIT 1
Processing by User::SessionsController#new as HTML
Parameters: {"return_to"=>"/admin/sites/1"}
SQL (1.4ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-user-0.0.5/app/views/user/sessions/new.html.rb
within layouts/user (135.5ms)
Completed 200 OK in 163ms (Views: 145.0ms | ActiveRecord: 15.8ms)
cache: [POST /user/sign_in] invalidate, pass
Started POST "/user/sign_in" for 127.0.0.1 at Sat Jan 01 14:47:09 +0100 2011
SQL (0.9ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.0ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.9ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) SELECT COUNT(*) FROM "sites"
Site Load (0.2ms) SELECT "sites".* FROM "sites" LIMIT 1
SQL (2.1ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Section Load (0.4ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) AND ("sections"."parent_id" IS NULL) ORDER BY
lft LIMIT 1
SQL (0.6ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
CACHE (0.0ms) SELECT COUNT(*) FROM "sites"
CACHE (0.0ms) SELECT "sites".* FROM "sites" LIMIT 1
Section Load (0.4ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) ORDER BY lft
Section Load (0.3ms) SELECT "sections".* FROM "sections" WHERE
("sections"."site_id" = 1) AND ("sections"."rgt" = 0) ORDER BY lft LIMIT 1
Processing by User::SessionsController#create as HTML
Parameters: {"commit"=>"Sign in", "return_to"=>"/admin/sites/1",
"authenticity_token"=>"yQeQ6a+MuSgtQuHswLFZe/vkTbt51DCaqCGoQLRqNjs=",
"utf8"=>"✓", "user"=>{"remember_me"=>"0", "password"=>"[FILTERED]",
"email"=>"ad...@admin.org"}}
SQL (0.9ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.3ms) SELECT "users".* FROM "users" WHERE ("users"."email" =
'ad...@admin.org') LIMIT 1
SQL (0.6ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.2ms) BEGIN
AREL (0.4ms) UPDATE "users" SET "sign_in_count" = 1, "roles" = NULL,
"current_sign_in_at" = '2011-01-01 13:47:10.266486',
"current_sign_in_ip" = '127.0.0.1', "last_sign_in_at" = '2011-01-01
13:47:10.266486', "last_sign_in_ip" = '127.0.0.1', "updated_at" =
'2011-01-01 13:47:10.267311' WHERE ("users"."id" = 1)
SQL (0.7ms) COMMIT
Redirected to http://localhost:3000/admin/sites/1
Completed 302 Found in 110ms
cache: [GET /admin/sites/1] miss
Started GET "/admin/sites/1" for 127.0.0.1 at Sat Jan 01 14:47:10 +0100 2011
SQL (0.8ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (0.7ms) 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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Processing by Admin::SitesController#show as HTML
Parameters: {"id"=>"1"}
SQL (0.9ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
User Load (0.3ms) SELECT "users".* FROM "users" WHERE ("users"."id" = 1)
LIMIT 1
SQL (0.6ms) 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 = '"users"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
SQL (1.1ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.4ms) SELECT "sites".* FROM "sites" WHERE ("sites"."id" = 1)
LIMIT 1
SQL (0.9ms) 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 = '"sites"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Site Load (0.5ms) SELECT "sites".* FROM "sites"
Section Load (0.6ms) SELECT "sections".* FROM "sections" WHERE
("sections".site_id = 1) ORDER BY lft
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 = '"sections"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-core-0.0.5/app/views/layouts/admin/_top.rb
(242.5ms)
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-core-0.0.5/app/views/admin/sites/_menu.html.rb
(3.4ms)
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-core-0.0.5/app/views/layouts/admin/_header.rb
(282.5ms)
Rendered
/home/chrisf/.rvm/gems/ruby-1.8.7-p302/gems/adva-core-0.0.5/app/views/admin/sites/show.html.rb
within layouts/admin (312.3ms)
Completed 200 OK in 381ms (Views: 346.1ms | ActiveRecord: 8.1ms)
> cynthi...@gmail.com <mailto:cynthi...@gmail.com>
Cynthia Kiser
Hi Cynthia!
thanks for your patience with this. Would you mind giving me a little more thorough run-down of what you're doing (verbatim copy and paste of commands is no problem!).
I've spent quite a bit of time working with someone else on the list about their issues ( http://groups.google.com/group/adva-cms/browse_thread/thread/de80644191ba613f ), and I have no problem doing the same with you. We have a pretty diverse array of systems on which the install instructions work, and I would love to make sure they work on your system as well.
I am traveling today so don't have time for much debugging. My install and rake db:migrate all went without error. Because the errors I am seeing are all SQL errors, I am pretty sure my issues lie with the fact that RHEL 5 has such ancient databases in their rpm repository. My Postgres insall isn't the RH stock, but is still a couple of versions behind the current release. Can you please tell me what versions of postgres database and pg gem you are using? I am using:
PostgreSQL: 8.3.0
Ruby gem: pg (0.10.0)
Cynthia Kiser
cynthi...@gmail.com
christopher floess
sorry for the delayed response, I'm traveling too :)
Here are my infos:
postgresql 9.0.2-2
ruby 1.8.7 (2010-08-16 patchlevel 302) [x86_64-linux]
pg (0.10.0)
Rails 3.0.3
Good luck.
-- Chris