Something went wrong

divyanshutri · November 17, 2009, 5:54am

hi any one cn explain and solve the problem…

whn i enter the "localhost:3000/admin " in the url

at that time errow come …

due to this problem i m not able the login in spree…

=====================================================
We’re sorry, but something went wrong.

We’ve been notified about this issue and we’ll take a look at it
shortly.

divyanshutri · November 17, 2009, 6:31am

Hi Dev T.!!

may be connection to database is not valid/proper…

Thanks & Regards.

Yash

divyanshutri · November 17, 2009, 1:14pm

Yash Yy wrote:

Hi Dev T.!!

may be connection to database is not valid/proper…

Thanks & Regards.

Yash

thanx…

but cn u tell me how we check the what is the porblem in
database…

the prolem come

given below
-/!\ FAILSAFE /!\ Tue Nov 17 17:42:14 +0530 2009
Status: 500 Internal Server Error
no such file to load – sqlite3
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
gem_original_require' /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:inrequire’
/usr/lib64/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb:156:in
require' /usr/lib64/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb:521:innew_constants_in’
/usr/lib64/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/dependencies.rb:156:in
require' /usr/lib64/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/core_ext/kernel/requires.rb:7:inrequire_library_or_gem’
/usr/lib64/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/core_ext/kernel/reporting.rb:11:in
silence_warnings' /usr/lib64/ruby/gems/1.8/gems/activesupport-2.3.4/lib/active_support/core_ext/kernel/requires.rb:5:inrequire_library_or_gem’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/sqlite3_adapter.rb:10:in
sqlite3_connection' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:insend’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:223:in
new_connection' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:245:incheckout_new_connection’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:188:in
checkout' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:inloop’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:184:in
checkout' /usr/lib/ruby/1.8/monitor.rb:242:insynchronize’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:183:in
checkout' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:98:inconnection’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:326:in
retrieve_connection' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:123:inretrieve_connection’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_specification.rb:115:in
connection' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/query_cache.rb:9:incache’
/usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/query_cache.rb:28:in
call' /usr/lib64/ruby/gems/1.8/gems/activerecord-2.3.4/lib/active_record/connection_adapters/abstract/connection_pool.rb:361:incall’
/usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/head.rb:9:in
call' /usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/methodoverride.rb:24:incall’
/usr/lib64/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/params_parser.rb:15:in
call' /usr/lib64/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/session/cookie_store.rb:93:incall’
/usr/lib64/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/failsafe.rb:26:in
call' /usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:incall’
/usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:in
synchronize' /usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/lock.rb:11:incall’
/usr/lib64/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/dispatcher.rb:114:in
call' /usr/lib64/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/reloader.rb:34:inrun’
/usr/lib64/ruby/gems/1.8/gems/actionpack-2.3.4/lib/action_controller/dispatcher.rb:108:in
call' /usr/lib64/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/static.rb:31:incall’
/usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:46:in
call' /usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:ineach’
/usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/urlmap.rb:40:in
call' /usr/lib64/ruby/gems/1.8/gems/rails-2.3.4/lib/rails/rack/log_tailer.rb:17:incall’
/usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/content_length.rb:13:in
call' /usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb:50:inservice’
/usr/lib/ruby/1.8/webrick/httpserver.rb:104:in service' /usr/lib/ruby/1.8/webrick/httpserver.rb:65:inrun’
/usr/lib/ruby/1.8/webrick/server.rb:173:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:162:instart’
/usr/lib/ruby/1.8/webrick/server.rb:162:in start_thread' /usr/lib/ruby/1.8/webrick/server.rb:95:instart’
/usr/lib/ruby/1.8/webrick/server.rb:92:in each' /usr/lib/ruby/1.8/webrick/server.rb:92:instart’
/usr/lib/ruby/1.8/webrick/server.rb:23:in start' /usr/lib/ruby/1.8/webrick/server.rb:82:instart’
/usr/lib64/ruby/gems/1.8/gems/rack-1.0.1/lib/rack/handler/webrick.rb:14:in
run' /usr/lib64/ruby/gems/1.8/gems/rails-2.3.4/lib/commands/server.rb:111 /usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:ingem_original_require’
/usr/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:31:in
`require’
script/server:3

divyanshutri · November 17, 2009, 1:32pm

hi,

may some gem in not installed , as Aldric G. suggested, if u r
using mysql then u need to install mysql gem … i worked with
mysql only.

U can chk which adapter u r using by looking at database.yml file in ur
Application/config dir…

Thanks

Yash

divyanshutri · November 17, 2009, 1:20pm

Dev T. wrote:

the prolem come

given below
-/!\ FAILSAFE /!\ Tue Nov 17 17:42:14 +0530 2009
Status: 500 Internal Server Error
no such file to load – sqlite3

Looks like you don’t have the sqlite3 gem installed.

divyanshutri · November 18, 2009, 5:42am

Yash Yy wrote:

hi,

may some gem in not installed , as Aldric G. suggested, if u r
using mysql then u need to install mysql gem … i worked with
mysql only.

U can chk which adapter u r using by looking at database.yml file in ur
Application/config dir…

Thanks

Yash

=====================

the configuration of database.yml

wht changes to need here…

development:
adapter: mysql
database: spree_dev
username: spree
password: spree
host: localhost
production:
adapter: mysql
database: production
username: root
password: rakeshjha123
host: localhost

#development:

adapter: postgresql

database: spree_dev

username: spree

password: spree_dev

host: localhost

#development:

adapter: sqlite3

database: db/development.sqlite3

test:
adapter: mysql
database: spree_test
username: spree
password: spree
host: localhost

divyanshutri · November 18, 2009, 5:50am

Hi Dev T.
Assuming you have mysql on your machine And the next step is to
install mysql gem

sudo gem install mysql

       Then restart the server and try again

Sijo

divyanshutri · November 18, 2009, 6:40am

Hi Dev T.
Are you using windows? Just made a googling See these

http://rubyforge.org/tracker/index.php?func=detail&aid=27052&group_id=1598&atid=6231
Or
http://rdc.taobao.com/blog/qa/?p=523&cpage=2

Sijo

divyanshutri · November 18, 2009, 6:21am

Sijo k g wrote:

Hi Dev T.
Assuming you have mysql on your machine And the next step is to
install mysql gem

sudo gem install mysql
       Then restart the server and try again
Sijo

================================

Thanx…

hi after write ur given command …sudo gem install mysql

whn i write in url “localhost:3000/admin”

–>
No route matches “/admin” with {:method=>:get}
—>

so cn u tell me how cn solve the above givn problem!!!

==============================================

this output come on the screen…

===>>sudo gem install mysql

Building native extensions. This could take a while…
Successfully installed mysql-2.8.1
1 gem installed
Installing ri documentation for mysql-2.8.1…

No definition for next_result

No definition for field_name

No definition for field_table

No definition for field_def

No definition for field_type

No definition for field_length

No definition for field_max_length

No definition for field_flags

No definition for field_decimals

No definition for time_inspect

No definition for time_to_s

No definition for time_get_year

No definition for time_get_month

No definition for time_get_day

No definition for time_get_hour

No definition for time_get_minute

No definition for time_get_second

No definition for time_get_neg

No definition for time_get_second_part

No definition for time_set_year

No definition for time_set_month

No definition for time_set_day

No definition for time_set_hour

No definition for time_set_minute

No definition for time_set_second

No definition for time_set_neg

No definition for time_set_second_part

No definition for time_equal

No definition for error_errno

No definition for error_sqlstate
Installing RDoc documentation for mysql-2.8.1…

No definition for next_result

No definition for field_name

No definition for field_table

No definition for field_def

No definition for field_type

No definition for field_length

No definition for field_max_length

No definition for field_flags

No definition for field_decimals

No definition for time_inspect

No definition for time_to_s

No definition for time_get_year

No definition for time_get_month

No definition for time_get_day

No definition for time_get_hour

No definition for time_get_minute

No definition for time_get_second

No definition for time_get_neg

No definition for time_get_second_part

No definition for time_set_year

No definition for time_set_month

No definition for time_set_day

No definition for time_set_hour

No definition for time_set_minute

No definition for time_set_second

No definition for time_set_neg

No definition for time_set_second_part

No definition for time_equal

No definition for error_errno

No definition for error_sqlstate

divyanshutri · November 18, 2009, 6:46am

Dev T. wrote:

Sijo k g wrote:

Hi Dev T.
Are you using windows? Just made a googling See these

http://rubyforge.org/tracker/index.php?func=detail&aid=27052&group_id=1598&atid=6231
Or
http://rdc.taobao.com/blog/qa/?p=523&cpage=2

Sijo

Thanx Sijo,

im using fedora 10…

so cn u give some hint hw to solve problem

Routing Error

No route matches “/login/add_user” with {:method=>:get}

divyanshutri · November 18, 2009, 6:43am

Sijo k g wrote:

Hi Dev T.
Are you using windows? Just made a googling See these

http://rubyforge.org/tracker/index.php?func=detail&aid=27052&group_id=1598&atid=6231
Or
http://rdc.taobao.com/blog/qa/?p=523&cpage=2

Sijo

Thanx Sijo,

im using fedora 10…

divyanshutri · November 18, 2009, 7:05am

Hi

   Is your first problem solved?Do you get welcome page when you

point to
http://localhost:3000

 Now your  second error.You have to set routes in routes.rb. To

start with read

Sijo

divyanshutri · November 18, 2009, 8:18am

Sijo k g wrote:

Hi
   Is your first problem solved?Do you get welcome page when you 
point to
http://localhost:3000
 Now your  second error.You have to set routes in routes.rb. To 
start with read

Rails Routing from the Outside In — Ruby on Rails Guides

Sijo

ya my first prob solved…

what changes make in the routes.rb file…

ActionController::Routing::Routes.draw do |map|

Loads all extension routes in the order they are specified.

map.load_extension_routes

The priority is based upon order of creation: first created →

highest priority.

Sample of regular route:

map.connect ‘products/:id’, :controller => ‘catalog’, :action =>

‘view’

Keep in mind you can assign values other than :controller and

:action

Sample of named route:

map.purchase ‘products/:id/purchase’, :controller => ‘catalog’,

:action => ‘purchase’

This route can be invoked with purchase_url(:id => product.id)

You can have the root of your site routed by hooking up ‘’

– just remember to delete public/index.html.

map.connect ‘’, :controller => “welcome”

Allow downloading Web Service WSDL as a file with an extension

instead of a file named ‘wsdl’

#map.connect ‘:controller/service.wsdl’, :action => ‘wsdl’

map.connect ‘/locale/:new_locale’, :controller => ‘locale’, :action

=> ‘set_session_locale’

map.root :controller => “products”, :action => “index”

map.resource :user_session, :member => {:login_bar => :get}
map.resource :account, :controller => “users”
map.resources :password_resets

login mappings should appear before all others

map.login ‘/login’, :controller => ‘user_sessions’, :action => ‘new’
map.logout ‘/logout’, :controller => ‘user_sessions’, :action =>
‘destroy’
map.signup ‘/signup’, :controller => ‘users’, :action => ‘new’
map.admin ‘/admin’, :controller => ‘admin/overview’, :action =>
‘index’

map.resources :tax_categories
map.resources :countries, :has_many => :states, :only => :index
map.resources :states, :only => :index
map.resources :users
map.resources :products, :member => {:change_image => :post}
map.resources :orders, :member => {:address_info => :get}, :has_many
=> [:line_items, :creditcards, :creditcard_payments], :has_one =>
:checkout
map.resources :orders, :member => {:fatal_shipping => :get} do |order|
order.resources :shipments, :member => {:shipping_method => :get}
end
#map.resources :shipments, :member => {:shipping_method => :any}

route globbing for pretty nested taxon and product paths

map.taxons_with_product ‘/t/*taxon_path/p/:id’, :controller =>
‘products’, :action => ‘show’
map.nested_taxons ‘/t/*id’, :controller => ‘taxons’, :action => ‘show’

#moved old taxons route to after nested_taxons so nested_taxons will
be default route
#this route maybe removed in the near future (no longer used by core)
map.resources :taxons

map.namespace :admin do |admin|
admin.resources :coupons
admin.resources :zones
admin.resources :users
admin.resources :countries, :has_many => :states
admin.resources :states
admin.resources :tax_categories
admin.resources :configurations
admin.resources :products, :has_many => [:product_properties,
:images] do |product|
product.resources :variants
product.resources :option_types, :member => {:select => :get,
:remove => :get}, :collection => {:available => :get, :selected => :get}
product.resources :taxons, :member => {:select => :post, :remove
=> :post}, :collection => {:available => :post, :selected => :get}
end
admin.resources :option_types
admin.resources :properties, :collection => {:filtered => :get}
admin.resources :prototypes, :member => {:select => :post},
:collection => {:available => :get}
admin.resource :mail_settings
admin.resource :inventory_settings
admin.resources :google_analytics
admin.resources :orders, :has_many => :shipments
admin.resources :orders, :has_many => [:payments, :creditcards],
:member => {:fire => :put, :resend => :post}
admin.resources :orders do |order|
order.resources :creditcard_payments, :member => {:capture =>
:get}
end
admin.resource :general_settings
admin.resources :taxonomies do |taxonomy|
taxonomy.resources :taxons
end
admin.resources :reports, :only => [:index, :show], :collection =>
{:sales_total => :get}

admin.resources :shipments
admin.resources :shipping_methods
admin.resources :shipping_categories
admin.resources :shipping_rates
admin.resources :tax_rates
admin.resource  :tax_settings
admin.resources :calculators

end

map.connect ‘:controller/:action/:id.:format’
map.connect ‘:controller/:action/:id’

a catchall route for “static” content

map.connect ‘*path’, :controller => ‘content’, :action => ‘show’

end

divyanshutri · November 18, 2009, 8:31am

Hi

No route matches “/login/add_user” with {:method=>:get}

   You are getting this because above route is not there in the

routes.rb. Dont know about your design But asking what /login/add_user
means.If you mean signup it is already there

map.signup ‘/signup’, :controller => ‘users’, :action => ‘new’

You can reach there by signup_url or signup_path

Sijo

Something went wrong

We’ve been notified about this issue and we’ll take a look at it shortly.

adapter: postgresql

database: spree_dev

username: spree

password: spree_dev

host: localhost

adapter: sqlite3

database: db/development.sqlite3

Loads all extension routes in the order they are specified.

The priority is based upon order of creation: first created →

Sample of regular route:

map.connect ‘products/:id’, :controller => ‘catalog’, :action =>

Keep in mind you can assign values other than :controller and

Sample of named route:

map.purchase ‘products/:id/purchase’, :controller => ‘catalog’,

This route can be invoked with purchase_url(:id => product.id)

You can have the root of your site routed by hooking up ‘’

– just remember to delete public/index.html.

map.connect ‘’, :controller => “welcome”

Allow downloading Web Service WSDL as a file with an extension

instead of a file named ‘wsdl’

map.connect ‘/locale/:new_locale’, :controller => ‘locale’, :action

login mappings should appear before all others

route globbing for pretty nested taxon and product paths

a catchall route for “static” content

We’ve been notified about this issue and we’ll take a look at it
shortly.