Hello there,
My task is to update an already existing website, an app created using Ruby on Rails. I've created a copy of the original database and modified it, adding some tables. I then set the new database as the database for the app and scaffolded the new tables. After tweaking a few files, and the RHTML code for the site, I get a NoMethodError:
undefined method `stb_id' for #<RemoteSite:0x46b9f00>
Extracted source (around line #332):
329: <option value=""> </option> 330: <% @stbs.each do |stb| %> 331: <option value="<%= stb.id %>" 332: <%= ' selected' if stb.id == @remote_site.stb_id %>> 333: <%= stb.name %> 334: </option> 335: <% end %>
RAILS_ROOT: C:/ruby/rails_apps/alpha/config/..
Now you won't find stb_id anywhere in the controllers, models, or helpers. So the error should be a no brainer right? The "method" doesn't exist. But here's some of the original, working code:
<!-- VOD PLATFORM --> <tr> <td class="category">VOD Platform:</td> <td class="option"> <select name="remote_site[vodsystem_id]"> <% @vodsystems.each do |vodsystem| %> <option value="<%= vodsystem.id %>" <%= ' selected' if vodsystem.id == @remote_site.vodsystem_id %>> <%= vodsystem.fullname %> </option> <% end %> </select> </td> </tr>
Notice vodsystem_id. This doesn't exist either! As a matter of fact, I've copied the above code and replaced vodsystem with stb:
<!-- STB Type --> <tr> <td class="category">STB Type:</td> <td class="option"> <select name="remote_site[stb_id]"> <option value=""> </option> <% @stbs.each do |stb| %> <option value="<%= stb.id %>" <%= ' selected' if stb.id == @remote_site.stb_id %>> <%= stb.name %> </option> <% end %> </select> </td> </tr>
And there are numerous blocks like this. For the life of me, I can't find the list of (tablename)_id methods so I can add my own for the tables I've created. I've done some queries in the database, and my tables are there, and they're filled. Each table has an 'id' column and a 'name' column as well.
There are a few things I find odd with the app. First, all of the controller and helper ruby files only contain the class name, and end. There is only one controller file that has any code in it at all, which makes sense because it generates the website:
class RemoteSiteController < ApplicationController scaffold :RemoteSite
def list
@remote_sites = RemoteSite.find(:all, :order => 'name asc, ip asc' ) @client = @params["client"] @clients = Client.find(:all, :order => 'name asc') @region = @params["region"] @vodsystem = @params["vodsystem"] @bmssystem = @params["bmssystem"] @regions = Region.find_all @quicklinks = Quicklink.find(:all, :order => 'name asc' ) @special_sites = SpecialSite.find(:all, :order => 'site_type asc, client_id asc' )
end
def index redirect_to(:action => "list") end
def edit @users = User.find(:all, :order => 'name asc' ) @remote_site = RemoteSite.find(@params["id"]) @clients = Client.find_all @vodsystems = Vodsystem.find(:all, :order => 'name asc' ) @bmssystems = Bmssystem.find(:all, :order => 'name asc' ) @oiversions = Oiversion.find_all @oi_statuses = OiStatus.find_all @idgversions = Idgversion.find_all @idg_statuses = IdgStatus.find_all @regions = Region.find_all @models = Model.find_all @rackmounts = Rackmount.find_all @processors = Processor.find_all @num_processors = NumProcessor.find_all @raid_configs = RaidConfig.find_all @operating_systems = OperatingSystem.find_all @application_servers = ApplicationServer.find_all @database_servers = DatabaseServer.find_all @jvm_versions = JvmVersion.find_all @license_levels = LicenseLevel.find_all @license_types = LicenseType.find_all @modifications = Modification.find(:all, :order => 'timestamp desc' ) @current_states = CurrentState.find_all @stbs = Stb.find_all
end
def new @clients = Client.find(:all, :order => 'name asc') @client = Client.find(@params["client_id"]) @vodsystems = Vodsystem.find(:all, :order => 'name asc') @oiversions = Oiversion.find(:all, :order => 'name desc') @oi_statuses = OiStatus.find(:all, :order => 'name desc') @idgversions = Idgversion.find(:all, :order => 'name desc') @idg_statuses = IdgStatus.find(:all, :order => 'name desc') @regions = Region.find(:all, :order => 'name asc') @stbs = Stb.find(:all, :order => 'name desc') end
def update
remote_site = RemoteSite.find(@params["id"])
remote_site.attributes = @params["remote_site"]
if ( remote_site.attributes["idgversion_id"] != remote_site.attributes["old_idgversion"]) new_idg_record = Modification.new new_idg_record.name = "IDG" new_idg_record.remote_site_id = remote_site.attributes["id"] new_idg_record.user_id = remote_site.attributes["user_id"] new_idg_record.from_version = remote_site.attributes["old_idgversion"] new_idg_record.to_version = remote_site.attributes["idgversion_id"] new_idg_record.timestamp = Time.now new_idg_record.save end
if ( remote_site.attributes["oiversion_id"] != remote_site.attributes["old_oiversion"]) new_oi_record = Modification.new new_oi_record.name = "Oi" new_oi_record.remote_site_id = remote_site.attributes["id"] new_oi_record.user_id = remote_site.attributes["user_id"] new_oi_record.from_version = remote_site.attributes["old_oiversion"] new_oi_record.to_version = remote_site.attributes["oiversion_id"] new_oi_record.timestamp = Time.now new_oi_record.save end
if remote_site.save redirect_to(:action => "list") else render_text "Couldn't add new item" end end
def new_link @clients = Client.find(:all, :order => 'name asc' ) end
def delete RemoteSite.find(@params['id']).destroy redirect_to :action => 'list' end end
Notice under the edit method I have added my tables, @oi_statuses, @idg_statuses, and @stbs. There are mentions of (table name)_id here too.
One final peculiarity is the naming convention. Every table in the sql was named plurally. However, all the corresponding controller, helper, and model files are singular. When I scaffolded my tables, the corresponding controller, helper, and model files were still plurally named. Its a small oddity, but it's been the cause of a few problems I've had already so its something I thought might be worth mentioning.
Any ideas on why the NoMethodError is popping up, or where to look to find these phantom methods would be greatly appreciated, thanks.