# DB tables inexistant online but there in console

**URL:** <https://www.ruby-forum.com/t/db-tables-inexistant-online-but-there-in-console/152548>\
**Category:** Deployment\
**Created:** [November 5, 2008, 3:13am UTC](https://www.ruby-forum.com/t/db-tables-inexistant-online-but-there-in-console/152548 "2008-11-05T03:13:47Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![thithi32](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/b782af/32.png) [@thithi32](https://www.ruby-forum.com/u/thithi32)\
**Post date:** [November 5, 2008, 3:13am UTC](https://www.ruby-forum.com/t/db-tables-inexistant-online-but-there-in-console/152548/1 "2008-11-05T03:13:47Z")

</div>

Hi,

I’m quite close achiving my first Cap Deploy … but something strange  
is  
happening:

- I did the “cap deploy” of the deploy.rb following:  
set :application, “league”  
set :repository,  
“[http://ksXXXXX.kimsufi.com/svn/titi/#{application}/trunk/](http://ksXXXXX.kimsufi.com/svn/titi/#%7Bapplication%7D/trunk/)”

set :deploy\_to, “/var/www/#{application}”

set :user, ‘root’

set :deploy\_via, :export

namespace :deploy do  
desc “Restart the server”  
task :restart do  
run “cd #{release\_path} && RAILS\_ENV=production mongrel\_rails stop  
-P log/mongrel\_9191.pid”  
run “cd #{release\_path} && RAILS\_ENV=production mongrel\_rails start  
-d -p 9191 -P log/mongrel\_9191.pid”  
end  
end

role :app, “[ksXXXXX.kimsufi.com](http://ksXXXXX.kimsufi.com)”  
role :web, “[ksXXXXX.kimsufi.com](http://ksXXXXX.kimsufi.com)”  
role :db, “[ksXXXXX.kimsufi.com](http://ksXXXXX.kimsufi.com)”, :primary =\> true

- I had to do first: rake RAILS\_ENV=production db:schema:load and import  
my db.dump in production.sqlite3

- I tried in the console ‘app.get(“/”)’ gives me 200.

- BUT!!! When I access from the browser, it gives me a 500 error and on  
the production.log it says that one table doesn’t exist. When I access a  
page that doesn’t need db access (for example login), it works fine …

What am I missing???

Thank you for your help,

Thithi32