similar to: rails db indexing and through association

on previous apps i hadn''t really worried much about adding foreign key indexes on my tables just because they''ve been fairly small and i didn''t really think i needed them. well, i''m working on something now that has the potential to have a lot more data, and a lot more foreign keys. so i have 3 tables... users, projects, and tasks.. should i be using add_index

Hi, I am trying to spec helper methods in a Rails project, but it seems the specs fail with the error: You might have expected an instance of Array. The error occurred while evaluating nil.<< if the restful routes helper are used either in spec files, or the helper file. What can I be doing wrong? Or how can I fix this. Thanks! -- Surendra Singhi http://ssinghi.kreeti.com,

Hello, I am using rails 1.0 and I have following questions. Please help me. [1] How can I do logging in the rails models? I checked the wiki but didn''t find anything which I explained how to do logging in models. [2] Say I have a certain model, when I declare a function in the model, and try to use that function from a view or a unit test, I get an error. For views the error occurs

Hi I''m new to Rails. This is my first application and I''m trying to set up a schema I''ve hand-crafted as a migration. Does anybody know why this... # deposit_types create_table :deposit_types do |table| table.column :type_code, :string, :limit => 20, :null => false table.column :description, :string, :limit => 50, :null => false

The upgrade to Rails 1.1 hurt my ability to run tests because it generated the following MySQL error: Mysql::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''key ON config (key)'' at line 1: CREATE UNIQUE INDEX key ON config (key) I have a table called `config` with a column

Hello, Earlier in my rails application, I was using the convention of writing the following to refer to templates and/or views in the view folder. "./blah/blah" But in the Edge rail, it doesn''t work and the page doesn''t shows any output there is no error in the development log as well. But changing the above to "/blah/blah" seems to fix things. Was I

Hello, I need to put an AJAX, form such that it is inside a table, and spans across few rows. But, what I am noticing is that, while submitting the form, the data in the fields is not submitted. If I move the form outside the table or inside a cell, things work OK, but not when the form is inside the table and spans few rows. This problem is only with AJAX forms, regular forms work perfect. I

Hello, I am pleased to announce the availability of the plugin acts_as_classifier which allows using the ''classifier'' gem in a Rails application. This plugin can be downloaded from http://opensvn.csie.org/sksinghi/acts_as_classifiable/ This plugin is useful in scenarios where you want to distinguish between spam or non-spam comments, Or maybe you want to track the

Hello, How do I prevent previously submitted form data from being reinserted into the database when the user presses the browser''s Refresh button? On Aughey''s advice in #irc I tried using `redirect_to'' a new `:action'' but this approach doesn''t seems to work. Any idea what might be wrong or how to tackle this problem? Thanks for your help. P.S.- I

Hello, When I am trying to run rake migration tasks, I get the error as shown below. I am using ruby 1.8.4 and edge rails. What am I missing or doing wrong? C:\rails\temp1>rake db:migrate (in C:/rails/temp1) rake aborted! no such file to load -- rails_version Thanks for your help. -- Surendra Singhi http://ssinghi.kreeti.com, http://www.kreeti.com Read my blog at:

Hello, I have created a ticket for an enhancement of the autocompleter to show the options immediately when the field gets focus. Right now at least one character must be typed for autocomplete to kick in. http://dev.rubyonrails.org/ticket/5435 I have also made some code changes directly in the script Event.observe(this.element, "blur", this.onBlur.bindAsEventListener(this));

Is anybody hosting with GoDaddy.com? I''m about to set up a hosted account for my RoR app and see that they''re now offering RoR hosting. I''d really appreciate hearing from anybody who''s tried them for RoR. Any congrats / complaints / etc. you had / are having would be really appreciated! Thanks, Bill -------------- next part -------------- An HTML attachment

Hello, When I am writing rails migrations, quite often I make mistake in them which causes the migration tasks to stop halfway with error. This causes lots of problem, because it results in half of the things in migrations changed and other half not. Also, as the schema number is changed, so things cannot be rolled back. Is there any way to make the entire migration action atomic, i.e.,

As I, like many people, are coming to ruby in the rails era, I''m curious about how Ruby Web Dev was done prior to rails. Any veterans want to share their insights? -------------- next part -------------- An HTML attachment was scrubbed... URL: http://wrath.rubyonrails.org/pipermail/rails/attachments/20060518/20cde24d/attachment.html

Hello, I am using RJS and Edge Rails and I was wondering if the page object should be available in helpers also. For example if I have a helper function def update_flash_messages page.replace_html ''flash_messages'', (show_flash_messages :textilize => true) page.visual_effect ''flash_messages'', :appear end and then in my RJS files I call

Hi, For one of our apps we switched to unicorn from mongrel. The unicorn server use to run behind an apache with timeout of 300sec, as sometime the customer may do a large file upload. After we made the switch we started getting lots of Unicorn::ClientShutdown occurred in photos#flash_upload bytes_read=2762663 (pr some other number) We were not able to recreate it in our tests, but support was

After creating a table in a create table migration, I''m then attempting to populate a couple of rows of data in the table using the create method. The first row gets inserted into the database, but any further calls generate a select against the database, but no insert. Am I doing something wrong, or is it inappropriate to create more than a single row of data in a table using

The AWDwR book has the following: add_index :categories_products, [:product_id, :category_id] add_index :categories_products, :category_id The first, composite index actually serves two purposes: it creates an index which can be searched on both foreign key columns, and with most databases it also creates an index that enables fast lookup by the product id. The second index then completes

Hello, We''re using Rails on an Oracle database. If we define an index like the following, we end up with problems during the "db:schema:dump" rake target. add_index "emcolumn", ["upper(name)"], :name => "ind_emcolumn_uname" The created schema.rb file contains: add_index "emcolumn", ["sys_nc00013$"], :name =>

Hello, While sending email notifications from ThoughtNotifier, I am getting weird exceptions, which sometimes occur on the production machine, but I haven''t been able to reproduce on my development machine. There should be no error while rendering `thought_notifier/share_notification.rhtml'' template, but if for some reason it is rendering