Re: Instalação do Noosfero e tabela "articles" não existente

Rodrigo Renie Braga rodrigorenie at gmail.com
Fri Nov 23 10:18:24 BRST 2012 

Olá Rafael. tudo bem?

Acredito que o problema esteja no script "./script/production" para iniciar
o serviço do noosfero. Apesar de ser o script da base de produção, ele
inicia a base de "development".

Na documentação de instação, é requisitado que seja executado
"RAILS_ENV=production rake db:schema:load", ou seja, que ele cria as
tabelas apenas na base de dados de produção (que é o que eu queria), mas
o ./script/production tenta utilizar a base de "development", que estava
vazia.

Agora eu executei "rake db:schema:load" (sem a
variável RAILS_ENV=production) e o executei o script ""./script/production
start" e agora o sistema iniciou normalmente. No entanto, os log de acesso
do sistema estão aparecendo em "log/development.log", confirmando o que eu
falei acima.

Será que isto é um bug? Ou eu executei algum procedimento errado?

Muito obrigado pela sua ajuda!



2012/11/23 Rafael Reggiani Manzo <rr.manzo em gmail.com>

> Olá Rodrigo,
>
> Você rodou esses comandos abaixo?
>
> rake db:schema:load
> rake db:migrate
>
> Abraço,
>
> Rafael.
>
> 2012/11/23 Rodrigo Renie Braga <rodrigorenie em gmail.com>:
> > Prezados, bom dia!
> >
> > Eu estou instalando o Noosfero versão 0.38.3 pela primeira vez, e segui o
> > procedimento à risca do arquivo README que vem no pacote  (estou
> instalando
> > pelo .tar.gz, não pelo pacote .deb em uma máquina com Debian 6.0).
> >
> > Todo o processo deu certo, no entanto a aplicação não sobe, o único erro
> que
> > encontrei foi no log/thin.log:
> >
> >>> Writing PID to tmp/pids/thin.pid
> >>> Using rails adapter
> >>> Exiting!
> >
> /usr/lib/ruby/1.8/active_record/connection_adapters/abstract_adapter.rb:219:in
> > `log': PGError: ERROR:  relation "articles" does not exist
> > (ActiveRecord::StatementInvalid)
> > LINE 4:              WHERE a.attrelid = '"articles"'::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 = '"articles"'::regclass
> >                AND a.attnum > 0 AND NOT a.attisdropped
> >              ORDER BY a.attnum
> > from
> >
> /usr/lib/ruby/1.8/active_record/connection_adapters/postgresql_adapter.rb:537:in
> > `query'
> > from
> >
> /usr/lib/ruby/1.8/active_record/connection_adapters/postgresql_adapter.rb:1091:in
> > `column_definitions'
> > from
> >
> /usr/lib/ruby/1.8/active_record/connection_adapters/postgresql_adapter.rb:705:in
> > `columns'
> > from /usr/lib/ruby/1.8/active_record/base.rb:1271:in `columns'
> > from /usr/lib/ruby/1.8/active_record/base.rb:1279:in `columns_hash'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:367:in
> > `type_for_field'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:355:in
> > `determine_field_name_and_options'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:320:in
> > `get_field_value'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:338:in
> > `process_fields'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:336:in
> > `each'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:336:in
> > `process_fields'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:295:in
> > `process_solr_options'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:198:in
> > `process_acts_as_solr'
> > from
> >
> /var/lib/noosfero/current/vendor/plugins/acts_as_solr_reloaded/lib/acts_as_solr/acts_methods.rb:193:in
> > `acts_as_solr'
> > from /var/lib/noosfero/current/lib/acts_as_searchable.rb:16:in
> > `acts_as_searchable'
> > from /var/lib/noosfero/current/app/models/article.rb:708
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:380:in
> > `load_without_new_constant_marking'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:380:in `load_file'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:521:in
> > `new_constants_in'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:379:in `load_file'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:259:in
> > `require_or_load'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:425:in
> > `load_missing_constant'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:80:in
> `const_missing'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:92:in
> `const_missing'
> > from /usr/lib/ruby/1.8/active_support/inflector.rb:361:in `constantize'
> > from /usr/lib/ruby/1.8/active_support/inflector.rb:360:in `each'
> > from /usr/lib/ruby/1.8/active_support/inflector.rb:360:in `constantize'
> > from
> /usr/lib/ruby/1.8/active_support/core_ext/string/inflections.rb:162:in
> > `constantize'
> > from /usr/lib/ruby/1.8/active_record/observer.rb:149:in `observe'
> > from /usr/lib/ruby/1.8/active_record/observer.rb:149:in `collect!'
> > from /usr/lib/ruby/1.8/active_record/observer.rb:149:in `observe'
> > from /var/lib/noosfero/current/app/sweepers/article_sweeper.rb:3
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:380:in
> > `load_without_new_constant_marking'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:380:in `load_file'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:521:in
> > `new_constants_in'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:379:in `load_file'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:259:in
> > `require_or_load'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:425:in
> > `load_missing_constant'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:80:in
> `const_missing'
> > from /usr/lib/ruby/1.8/active_support/dependencies.rb:92:in
> `const_missing'
> > from /usr/lib/ruby/1.8/active_support/inflector.rb:361:in `constantize'
> > from /usr/lib/ruby/1.8/active_support/inflector.rb:360:in `each'
> > from /usr/lib/ruby/1.8/active_support/inflector.rb:360:in `constantize'
> > from
> /usr/lib/ruby/1.8/active_support/core_ext/string/inflections.rb:162:in
> > `constantize'
> > from /usr/lib/ruby/1.8/active_record/observer.rb:38:in
> > `instantiate_observers'
> > from /usr/lib/ruby/1.8/active_record/observer.rb:36:in `each'
> > from /usr/lib/ruby/1.8/active_record/observer.rb:36:in
> > `instantiate_observers'
> > from /usr/lib/ruby/1.8/action_controller/dispatcher.rb:15:in
> > `define_dispatcher_callbacks'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:182:in `call'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:182:in
> `evaluate_method'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:166:in `call'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:90:in `run'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:90:in `each'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:90:in `send'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:90:in `run'
> > from /usr/lib/ruby/1.8/active_support/callbacks.rb:276:in `run_callbacks'
> > from /usr/lib/ruby/1.8/action_controller/dispatcher.rb:51:in `send'
> > from /usr/lib/ruby/1.8/action_controller/dispatcher.rb:51:in
> > `run_prepare_callbacks'
> > from
> >
> /var/lib/noosfero/current/config/../vendor/rails/railties/lib/initializer.rb:631:in
> > `prepare_dispatcher'
> > from
> >
> /var/lib/noosfero/current/config/../vendor/rails/railties/lib/initializer.rb:185:in
> > `process'
> > from
> >
> /var/lib/noosfero/current/config/../vendor/rails/railties/lib/initializer.rb:113:in
> > `send'
> > from
> >
> /var/lib/noosfero/current/config/../vendor/rails/railties/lib/initializer.rb:113:in
> > `run'
> > from /var/lib/noosfero/current/config/environment.rb:35
> > from /usr/lib/ruby/1.8/rack/adapter/rails.rb:42:in `require'
> > from /usr/lib/ruby/1.8/rack/adapter/rails.rb:42:in `load_application'
> > from /usr/lib/ruby/1.8/rack/adapter/rails.rb:23:in `initialize'
> > from /usr/lib/ruby/1.8/rack/adapter/loader.rb:36:in `new'
> > from /usr/lib/ruby/1.8/rack/adapter/loader.rb:36:in `for'
> > from /usr/lib/ruby/1.8/thin/controllers/controller.rb:163:in
> `load_adapter'
> > from /usr/lib/ruby/1.8/thin/controllers/controller.rb:67:in `start'
> > from /usr/lib/ruby/1.8/thin/runner.rb:174:in `send'
> > from /usr/lib/ruby/1.8/thin/runner.rb:174:in `run_command'
> > from /usr/lib/ruby/1.8/thin/runner.rb:140:in `run!'
> > from /usr/bin/thin:6
> >
> > Ou seja, a tabela "articles" não foi criada pelo script de criação de
> banco
> > de dados do Noosfero e aparentemente isto está afetando o start da
> > aplicação.
> >
> > Como posso resolver este problema?
> >
> > _______________________________________________
> > Noosfero-br mailing list
> > Noosfero-br em listas.softwarelivre.org
> > http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/noosfero-br
> >
> _______________________________________________
> Noosfero-br mailing list
> Noosfero-br em listas.softwarelivre.org
> http://listas.softwarelivre.org/cgi-bin/mailman/listinfo/noosfero-br
>
-------------- Pr�xima Parte ----------
Um anexo em HTML foi limpo...
URL: <http://listas.softwarelivre.org/pipermail/noosfero-br/attachments/20121123/3d133726/attachment.html>

More information about the Noosfero-br mailing list