similar to: Problems migrating from Postgres to MySQL

I have been attempting to use migrations as a build a poll app. I have created the initial file: ----------------- class CreateTablePollsAndPollOptions < ActiveRecord::Migration def self.up create_table polls do |table| table.column ''question'', :string table.column ''user_id'', :integer table.column ''start_time'',

Hi all... Please help me solve the issue. While trying to create a connection with MS SQL database in RubyOnRails, I''m getting a ‘Deprecated ..’ error. (I referenced a doc posted in net for the same.) System details: OS: Windows Xp Ruby version: 1.8.6 Rails: 2.1.2 Gems: 1.3.1 RadRails: 0.7.2

Hello, I have Oracle XE installed. I have a table USERS. When I try to generate a scaffold it gives me this error. I tried also with Mysql and it worked. E:\radrails\projects\MPS>ruby script\generate scaffold user exists app/controllers/ exists app/helpers/ create app/views/user exists test/functional/ dependency model exists app/models/ exists

All of a sudden, I''m getting this error: 1) Error: test_index(AccountControllerTest): RuntimeError: The number of parameters does not match the number of substitutions. /home/joe/projects/tanga/trunk/config/../vendor/rails/actionpack/lib/action_controller/assertions.rb:92:in `assert_redirected_to''

My app runs fine on webrick, but I get a ActiveRecord::ConnectionNotEstablished when I try to run it on lighttpd. Here''s the app''s lighttpd config: $HTTP["host"] =~ "(www\.)?mysite\.com" { server.document-root = "/home/pergesuteore/public/" server.error-handler-404 = "/dispatch.fcgi" fastcgi.server = ( ".fcgi" => (

Hi everybody, May be somebody has a clue, why I get these errors below, while trying to migrate. Any help is very appreciated! Greetinx Rafael I was trying to experiment a litte bit with redMine (www.redmine.org). But I can only install it locally. On a system with already a mongrel_cluster running, I get strange errors, already while trying to start the migration rake db:migrate

Hi, A newbie in the RoR world, I''m already more or less stuck when generating the scaffold for my first tutorial project ... When I try to generate scaffold code for my version of the ''depot'' application from the ''Agile rails ...'' book, I receive the following error: #28000Access denied for user ''bo''@''localhost''

Hello, I''m a newbie to rails and I am trying to do the Demo in the November Issue of Linux Journal. Things go fine go fine until I try to connect to my Postgres database (ver 8.1). At this point I get the following error message ---- RoR error and trace back ---- PGError in Admin#index could not connect to server: Permission denied Is the server running on host "localhost"

To all fellow Dreamhosters out there... Sometimes my app mysteriously loses its connection to the database, resulting in a big ugly "Application Error (Rails)" page. Usually refreshing the page makes it go away, but not today. :-( In production.log I see this: MysqlError (Lost connection to MySQL server during query): Any idea why this happens? It''s rather intermittent

I''m writing a simple app that doesn''t need to use a database. I added :active_record to the config.frameworks -= line in environment.rb file. This lets me run ./script/generate fine without complaining about no connection. However if I try to run a functional test, it complains about no connection being established. Well...I don''t want a connection to be established.

I''m getting the following error unexpectedly for my rails app. I just exported the databae from dreamhost and imported it on textdrive for my rails app. Mysql::Error: MySQL client ran out of memory: SELECT COUNT(*) FROM comments WHERE (comments.listing_id = 2666) /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.13.2/lib/active_record/connection_adapters/abstract_adapter.rb:88:in

Just starting to learn rails. All is going well, until I tried to hook up a database. "undefined method `model'' for ZingerController:Class" is the message I get from the server. I imagine I''ve left something out that is keeping me from connecting to the database, but I''m not exactly sure what. Your help is appreciated. bests, -rsr- session dump:

I have some jobs running through cron jobs and runner that suddenly starts failing. This is how it looks: from /usr/local/lib/ruby/gems/1.8/gems/rails-2.1.2/lib/commands/runner.rb:47 from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `gem_original_require'' from /usr/local/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in `require'' from

Hello All, If I run my unit tests individually using Ruby, they all work correctly. However, if I try to run them using "rake test_units", I get a bunch of error messages. The error messages appear to be caused by rake not loading any of the fixtures into the test database. I am using PostgreSQL on Windows. Does anyone have any suggestions? Many thanks, Bruce. -- Posted via

Hi -- I''ve been having problems connecting to a SQL Server database that I thought might be related to the fact I was upgrading Rails to 2.0. However, I also was moving the project to my shiny new macbook. Anyway, after jumping through a few hoops (instaling DBI, etc.), I finally get to my latest error message: <error> DBI::InterfaceError: Could not load driver (no such file to

Hello everyone, In my controller, I put the following code: render :text => "Hello World!" It popped up with this error: " MissingSourceFile in BlogController#index no such file to load -- sqlite3 RAILS_ROOT: C:/InstantRails/rails_apps/scblog Application Trace | Framework Trace | Full Trace c:/ruby/lib/ruby/site_ruby/1.8/rubygems/custom_require.rb:27:in

I''m getting ready to go to the Rails Studio in Pasadena next week. As part of the prep for that event, I was instructed by the Pragmatic guys to download and install a new Rails 1.0/Ruby 1.8.4 configuration to my OS X 10.4.4 box. I did that three or four days ago. Ever since then, I cannot run a rake migrate command successfully anywhere in my Rails world. (Mind you,

This is the first time I am Running ruby on rails. When running the "blog" application I got the message "We''re sorry, but something went wrong. We''ve been notified about this issue and we''ll take a look at it shortly." Then I checked the CODE\blog\log\development.log and got this:

can anyone help with this??? /!\ FAILSAFE /!\ Thu Apr 08 16:58:27 -0700 2010 Status: 500 Internal Server Error unknown error C:/Ruby/lib/ruby/1.8/dl/import.rb:29:in `initialize'' C:/Ruby/lib/ruby/1.8/dl/import.rb:29:in `dlopen'' C:/Ruby/lib/ruby/1.8/dl/import.rb:29:in `dlload'' C:/Ruby/lib/ruby/1.8/dl/import.rb:27:in `each''

Hi, I am getting this error when i execute rake db:create:all /opt/gitorious/vendor/rails/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb:569: [BUG] unknown type 0x22 (0xc given) any clues ? -Manish -- Posted via http://www.ruby-forum.com/.