search for: depot_develop

Pg. 57 of Agile asks you to create a scaffolding by typing in ruby script/generate scaffold Product Admin Instead of generating everything, it only gives me exists app/controllers/ exists app/helpers/ exists app/views/admin exists test/functional/ dependency model exists app/models/ exists test/unit/ exists test/fixtures/ identical

I''m following the example Depot app in Agile Web Development with Rails. The scaffold fails because it is not using the correct host for the user. Here is the error that the scaffold emits: Access denied for user ''jimmy''@''%'' to database ''depot_development'' The MySql user ''jimmy'' was created with the host of ''localhost'', and the database.yml file is using ''localhost'' as the host for user ''jimmy'' on the depot_development database. I''m using MySql 5.0.19-n...

I am following the Agile Web Development with Rails pdf book, when I run the store application it gives me the "Table ''depot_development.sessions'' doesn''t exist" error message. How can I fix it? Thanks in advance. -- Posted via http://www.ruby-forum.com/.

...r during query: SHOW FIELDS FROM products Running Fedora 5, using available Red Hat modules and latest version of Rails. This problem just appeared. I had been enjoying going through the tutorial "Depot" when it started displaying this problem. With phpMyAdmin I am able to access the depot_development data base containing entries that I had used the depot application to display, enter, and edit with no problems earlier. The only application that still works is the non data base application "Hello from Rail" The dump follows. Hope someone can help. ActiveRecord::StatementIn...

Hey there I''ve got instant rails installed, and it''s phpmyadmin can find the database at the ascribed mysql port (3210) ...however, altho i have got my ''depot_development'' db in there (along with the other dbs that ship with instant rails)... the rake script from the instant rails command interface cant find ''depot_development''. Looking at trace it is ok to connect, but it says the db isn''t there. ''rake aborted! #420...

...g Mysql Query browser to issue some lines of sql to create the table making sure I use the correct datasbase of course, but this time I am wanting to use the mysql client to execute the code in the create.sql file which is in the db directory of my rails application. so i type from the prompt mysql depot_development <db/create.sql return depot_development is the the database I want to put the table into, and it was created previously by me. I get back: ERROR: 1045 <28000>: Access denied for user ''ODBC''@''localhost'' <using password: NO> mysql error messages...

...te app/models/product.rb create test/unit/product_test.rb create test/fixtures/products.yml #28000Access denied for user ''bo''@''localhost'' (using password: NO) My YML file for my development project: development: adapter: mysql database: Depot_development host: localhost username: bo password: I hope very much that someone will have met the same obstacles, having found a solution that I can adapt. Any help very much appreciated, Best regards, Bo -- Posted via http://www.ruby-forum.com/.

hi everyone. I am learning RoR and just recently purchase the agile wed dev on rails. i am still at the beginning of the book trying to create the scaffold for the depot_development database. Everytime i run the generate scaffold products admin, i recieve the "before building the scaffold, try to create a table for model products" etc... a few questions: 1. How does ruby know that Products table is located in the Depot_Development DB? What if i have the same nam...

...he migrations I get the following error. rake db:migrate (in /Users/balaparanj/work/depot) -- execute("alter table line_items \n add constraint fk_line_item_products \n foreign key (product_id) references products(id)") rake aborted! Mysql::Error: Table ''depot_development.line_items'' doesn''t exist: alter table line_items add constraint fk_line_item_products foreign key (product_id) references products(id) (See full trace by running task with --trace) Could some one please tell me how to fix this problem? TIA. http:/...

...12/01/ ruby_rails_lighttpd_mysql_tiger and it seemed to work fine. But when I try to create the first table, I get the following error, and I have no idea what this means. Any help would be greatly appreciated! Thanks (My database.yml file looks like this: development: adapter: mysql database: depot_development host: localhost username: root password: <MYSQLROOTPASSWORD> ===================== error: mycomputer:~/Rails/depot dvollmar$ ruby script/generate scaffold Product Admin /usr/lib/ruby/1.8/yaml.rb:119:in `load'': parse error on line 11, col 11: ` username: root'' (Ar...

Hi to all, I am trying to use "ruby script/generate scaffold product". I always get the message "uninitialized constant CHARACTER_SET". I have a products table in a Firebird database called depot_development.fdb. Here is my config file : > common: &common > adapter: firebird > host: localhost > username: SYSDBA > password: masterkey > charset: WIN1252 > > development: > database: depot_development > <<: *common > > production: &...

...= now() /app/models/product.rb:21:in `salable_items'' app/controllers/store_controller.rb:4:in `index'' script/server:48 When I connect with the admin controller, I see the following in the mysql connection logs that I set up: 060227 21:22:09 2 Connect root@localhost on depot_development 2 Query SELECT * FROM products 2 Query SHOW FIELDS FROM products When I connect with the store controller, I see: 060227 21:23:02 3 Connect root@localhost on depot_development 3 Query SELECT * FROM p...

...ls2_my_depot/depot 13 $ bash mac maco /pt/books/rails2_my_depot/depot 13 $ [ os x 10.4 ] bash mac maco /pt/books/rails2_my_depot/depot 19 $ bash mac maco /pt/books/rails2_my_depot/depot 19 $ bash mac maco /pt/books/rails2_my_depot/depot 19 $ bash mac maco /pt/books/rails2_my_depot/depot 19 $ psql depot_development Welcome to psql 8.1.4, the PostgreSQL interactive terminal. bash mac maco /pt/books/rails2_my_depot/depot 12 $ bash mac maco /pt/books/rails2_my_depot/depot 12 $ bash mac maco /pt/books/rails2_my_depot/depot 12 $ bash mac maco /pt/books/rails2_my_depot/depot 12 $ bash mac maco /pt/books/rails...

I needed to format numbers with commas to make it more human readable. Here''s how I did it. def commify(number) c = { :value => "", :length => 0 } r = number.to_s.reverse.split("").inject(c) do |t, e| iv, il = t[:value], t[:length] iv += '','' if il % 3 == 0 && il != 0 { :value => iv + e, :length =>

Hi, I''m new to Ruby, Rails and MySQL... Before Dropping my database, I went back to a previous Grant problem. On page 54, there are three create database commands...these all worked fine for me. I then tried the following Grant command: Grant all on depot_development.* to ''dave''@''localhost''; I got back the following error message: Error 1133 (42000): can''t find any matching row in the user table Just for the heck of it, I ran the following query: Select host,user,password from mysql.user And sure enuf ''...

I have tried everything in my power to get this program up and running and it is not working for me. I have installed RoR on my Windows XP machine. I have Instant Rails and Ruby on Rails and I am using Instant Rails to connect the mySQL database to Ruby on Rails. It is not working. Everything works fine except when I create a scaffold it gives me an error in mySQL. The error reads, ">

Hi, An absolute newbie to RoR, I''m currently going through a few of the excellent tutorials that are available on the subject. One of these includes running a script for creating a mySQL table. In the command prompt (XP), I try mysql depot_development <db/create.sql but get the following error: ''mysql'' is not recognized as an internal or external command, operable program or batch file. Any ideas as to what goes wrong? Br and thx in advance, /Bo -- Posted via http://www.ruby-forum.com/.

...t destroy products (I can only creat and update them). When I try to delete a product --> http://localhost:3001/admin/destroy/3 I get this error message: ActiveRecord::StatementInvalid in Admin#destroy Mysql::Error: #23000Cannot delete or update a parent row: a foreign key constraint fails (`depot_development/line_items`, CONSTRAINT `fk_items_product` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`)): DELETE FROM products WHERE id = 3 Can someone explain me what''s going wrong? I''m not a MySQL expert... Before I started to use Rails, I didn'...

...t step. I''m getting the following error: "Before updating scaffolding from new DB schema, try creating a table for your model (Product)" when I try to run "ruby script/generate scaffold Product Admin. I have a table called "products" created in MySQL database depot_development and so it''s not a name mismatch problem. I google''d a around and found that people who ran into this problem eventually "fixed" it by not using a MySQL password. So I removed my MySQL user password and the scaffold command worked. Is there a correct way to fix...

...ction_adapters/abstract/connection_specification.rb:73:in `establish_connection'': development database is not configured (ActiveRecord::AdapterNotSpecified) I am using the following database.yml file (passwords replaced with *): development: adapter: mysql host: localhost database: depot_development username: root password: ******** test: adapter: mysql host: localhost database: depot_test username: root password: **** production: adapter: mysql host: localhost database: depot_production username: root password: ***** Please help!!! Thanks