search for: app_develop

...o delete, nor can i even get the column_id to delete too..so weird.. humm..just ''checked'' the table in phpmyadmin, reset the server, reset mysql, dropping that coloumn_id still doesn''t work.. this is the error i get: Mysql::Error: #HY000Error on rename of ''.\app_development\#sql-644_5'' to ''.\app_development\users'' (errno: 150): ALTER TABLE users DROP `column_id` thanks Dominic -- Posted via http://www.ruby-forum.com/.

Hello folks, I''m trying to do something like: 1. db = ActiveRecord::Base.establish_connection(:adapter => "mysql", :database => "app_development", :username => "root") 2. Cmd = File.read(''commands.sql'') <--- Command.sql contains multiple valid SQL statement. I''ve tested this directly by piping it into MySQL from the command line 3. ActiveRecord::Base.connection.execute(cmd) This seems...

...4, 2006 12:41 PM To: rails@lists.rubyonrails.org Subject: [Rails] Parsing a SQL file directly into = activerecord::executemethod=20 Hello folks, I''m trying to do something like: 1. db =3D ActiveRecord::Base.establish_connection(:adapter =3D> "mysql", :database =3D> "app_development", :username =3D> "root") 2. Cmd =3D File.read(''commands.sql'') <--- Command.sql contains = multiple valid SQL statement. I''ve tested this directly by piping it into MySQL from the command line 3. ActiveRecord::Base.connection.execute(cmd) This...

...d on Linux. If you run rake db:create and see an error like this: Couldn''t create database for {"reconnect"=>false, "encoding"=>"utf8", "username"=>"root", "adapter"=>"mysql", "database"=>"app_development", "pool"=>5, "password"=>nil, "socket"=>"/var/run/mysqld/mysqld.sock"}, charset: utf8, collation: utf8_unicode_ci (if you set the charset manually, make sure you have a matching collation) or if you run rake db:migrate and see an error like...

...4, 2006 12:41 PM To: rails@lists.rubyonrails.org Subject: [Rails] Parsing a SQL file directly into = activerecord::executemethod=20 Hello folks, I''m trying to do something like: 1. db =3D ActiveRecord::Base.establish_connection(:adapter =3D> "mysql", :database =3D> "app_development", :username =3D> "root") 2. Cmd =3D File.read(''commands.sql'') <--- Command.sql contains = multiple valid SQL statement. I''ve tested this directly by piping it into MySQL from the command line 3. ActiveRecord::Base.connection.execute(cmd) This...

Hi, Creating a new Rails application with -d postgresql sets the encoding in the database.yml to unicode Creating a new Rails with -d mysql sets the encoding to utf8 Any ideas why this difference? I''ve been having problems with encoding due to localization, accents, json and what no. I thought I was using utf8 and not unicode. Would this have any impact? If this would be an issue?

...;? Here''s a sample of a DB config in the DSL: ---------------------------------- common { adapter "mysql" username "root" password "" host "example.com" port "3306" } development { << "common" database "app_development" } production { << "common" database "app_production" } test { << "common" database "app_test" } ---------------------------------- I did get this working as an instance_eval style DSL, except that the << lines had to ha...

...er: Connection >> refused (0x0000274D/10061) (PG::Error) >> Is the server running on host "localhost" (127.0.0.1) and accepting >> TCP/IP connections on port 5432? I even couldn''t open Rails start page (Welcome aboard, I mean) without database and app_development table in it being created! I had to explicitly create them before. How to turn off this behavior of PG? I don''t want to start PG server every time I just need to run some rails|rake task. This totally not the same as MySQL. I didn''t need MySQL server running to call rake|rail...

I am using WAMP(windows, Apache, mySQL and PHP) for my web development. So I have already MySQL and Apache working. Could any one tell me how to install Ruby on Rails on this environment? Can I just put ror in the root directory, www? A newbie needs your help. :-) -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because

Hi, I have what might be a silly question but is there any way to put some of the database configuration information into a separate file? For instance, in config/database.yml I have: developer_database: &developer_database adapter: mysql username: me password: something host: 127.0.0.1 development: <<: *developer_database database: foobar_development test: <<: