Installing from master into rails 3.2 all seems to go OK but error on home page

[tim]

The error is Error 404 :: Page with url "" doesn't exist.

I have ran the db:seed rake task.

Cheers.

[Flurin Egger]

Hi Tim,

Did you publish the homepage?

Cheers,
Flurin

[Tim Uckun]

>
> Did you publish the homepage?
>

I was able to log into /skyline but it turns out the migrations didn't
run right. They failed at this point.

Setup public paths
== Clear current rightsets

== Creating roles
- Skyline::Role {:system=>true, :name=>"super"}
rake aborted!
unknown attribute: system

Tasks: TOP => skyline:db:seed
(See full trace by running task with --trace)

full trace ..

bingatron@bingatron-beta:~/skyline/production/current$ rake
skyline:db:seed --trace
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/skyline/version.rb:7:
warning: already initialized constant MAJOR
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/skyline/version.rb:8:
warning: already initialized constant MINOR
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/skyline/version.rb:9:
warning: already initialized constant TINY
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/skyline/version.rb:10:
warning: already initialized constant BUILD
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/skyline/version.rb:34:
warning: already initialized constant STRING
** Invoke skyline:db:seed (first_time)
** Invoke environment (first_time)
** Execute environment
Setup public paths
** Execute skyline:db:seed
== Clear current rightsets

== Creating roles
- Skyline::Role {:system=>true, :name=>"super"}
rake aborted!
unknown attribute: system
/home/bingatron/shared/bundle/ruby/1.8/gems/activerecord-3.2.2/lib/active_record/attribute_assignment.rb:88:in
`assign_attributes'
/home/bingatron/shared/bundle/ruby/1.8/gems/activerecord-3.2.2/lib/active_record/attribute_assignment.rb:78:in
`each'
/home/bingatron/shared/bundle/ruby/1.8/gems/activerecord-3.2.2/lib/active_record/attribute_assignment.rb:78:in
`assign_attributes'
/home/bingatron/shared/bundle/ruby/1.8/gems/seed-fu-2.2.0/lib/seed-fu/seeder.rb:67:in
`seed_record'
/home/bingatron/shared/bundle/ruby/1.8/gems/seed-fu-2.2.0/lib/seed-fu/seeder.rb:36:in
`seed'
/home/bingatron/shared/bundle/ruby/1.8/gems/seed-fu-2.2.0/lib/seed-fu/seeder.rb:36:in
`map'
/home/bingatron/shared/bundle/ruby/1.8/gems/seed-fu-2.2.0/lib/seed-fu/seeder.rb:36:in
`seed'
/home/bingatron/shared/bundle/ruby/1.8/gems/activerecord-3.2.2/lib/active_record/connection_adapters/abstract/database_statements.rb:192:in
`transaction'
/home/bingatron/shared/bundle/ruby/1.8/gems/activerecord-3.2.2/lib/active_record/transactions.rb:208:in
`transaction'
/home/bingatron/shared/bundle/ruby/1.8/gems/seed-fu-2.2.0/lib/seed-fu/seeder.rb:35:in
`seed'
/home/bingatron/shared/bundle/ruby/1.8/gems/seed-fu-2.2.0/lib/seed-fu/active_record_extension.rb:32:in
`seed'
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/../db/fixtures/roles_and_rights.rb:41
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/../db/fixtures/roles_and_rights.rb:10:in
`stfu'
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/../db/fixtures/roles_and_rights.rb:40
/home/bingatron/shared/bundle/ruby/1.8/gems/activesupport-3.2.2/lib/active_support/dependencies.rb:245:in
`load'
/home/bingatron/shared/bundle/ruby/1.8/gems/activesupport-3.2.2/lib/active_support/dependencies.rb:245:in
`load'
/home/bingatron/shared/bundle/ruby/1.8/gems/activesupport-3.2.2/lib/active_support/dependencies.rb:236:in
`load_dependency'
/home/bingatron/shared/bundle/ruby/1.8/gems/activesupport-3.2.2/lib/active_support/dependencies.rb:245:in
`load'
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/tasks/database.rake:64
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/tasks/database.rake:63:in
`each'
/home/bingatron/shared/bundle/ruby/1.8/bundler/gems/skyline-41829c0f3991/lib/tasks/database.rake:63
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `call'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:205:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:200:in `execute'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:158:in
`invoke_with_call_chain'
/usr/local/lib/ruby/1.8/monitor.rb:242:in `synchronize'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:151:in
`invoke_with_call_chain'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/task.rb:144:in `invoke'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:116:in
`invoke_task'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in
`top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in
`each'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:94:in
`top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:88:in
`top_level'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:66:in
`run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:133:in
`standard_exception_handling'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/lib/rake/application.rb:63:in
`run'
/usr/local/lib/ruby/gems/1.8/gems/rake-0.9.2.2/bin/rake:33
/usr/local/bin/rake:19:in `load'
/usr/local/bin/rake:19
Tasks: TOP => skyline:db:seed

[Flurin Egger]

Hi Tim,

What kind of database are you running?

Did you run rake skyline:db:migrate?

Flurin

[Tim Uckun]

On Tue, Mar 20, 2012 at 9:32 PM, Flurin Egger <flu...@digitpaint.nl> wrote:
> Hi Tim,
>
> What kind of database are you running?
>
> Did you run rake skyline:db:migrate

db:migrate fails with postgres. One error I saw was the use of
"mediumtext" as a type which postgres doesn't support. I switched to
sqlite and everything seemed to run fine.

Going on with the install right now.

[Flurin Egger]

Hi Tim,

Ah, we didn't do any tests on postgres but if you can help us work out the quirks that would be great. I don't think that postgres should require a lot of changes.

Cheers,
Flurin

[Tim Uckun]

I didn't look at all your tables but specifying "text" as a field
should do the trick for postgres. Postgres even prefers text over
varchar.

The only issue you may have with postgres is that queries are case
sensitive. That might trip you up.

[Flurin Egger]

Hmm, de mediumtext is necessary for mysql (as regular text is only 16kb). But maybe there is a rails database agnostic way to fix that?

There shouldn't be that many raw queries in Skyline and most of them are lowercase so I don't forsee any problems.

[Tim Uckun]

On Tue, Mar 20, 2012 at 10:02 PM, Flurin Egger <flu...@digitpaint.nl> wrote:
> Hmm, de mediumtext is necessary for mysql (as regular text is only 16kb). But maybe there is a rails database agnostic way to fix that?
>
> There shouldn't be that many raw queries in Skyline and most of them are lowercase so I don't forsee any problems.

When you specify the migration as "text" in rails it chooses text in
postgres but I am not sure what it would choose on mysql. As for the
lower case it doesn't matter if you do raw queries or not. For example

Skyline::User.find_by_email('timu...@gmail.com') would not find me if
my email in the database was TimU...@gmail.com. With postgres you'd
have to be careful to store all the emails as lower case and then
search find_by_email params[:email].downcase or do something postgres
specific like build a lower case index on a mixed case field.

BTW you might want to consider adding an admin user and start page
into your seeds. It would make the installation process go faster.

Anyway I did get the CMS up and will play around with it some.

Cheers.