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

Rodrigo Renie Braga rodrigorenie at gmail.com
Fri Nov 23 10:42:01 BRST 2012


Olá.

Descobri o problema, estava no arquivo conf/thin.conf, estava apontando
para a base de development... Mas obrigado pela ajuda!

Att,


2012/11/23 Rodrigo Renie Braga <rodrigorenie em gmail.com>

> 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/d6bd789a/attachment-0001.html>


More information about the Noosfero-br mailing list