similar to: Unknown column 'id' in 'field list

I don't find how to do what I need to do in Dalgaard or 'R Cookbook', so I'm asking here. I have a data frame with water chemistry data and I want to start exploring these data. There are three factors (site, date, chemical) associated with each measurement. The data frame looks like this: > summary(chemdata) site_id.sample_date.param.quant

Getting the basic stuff to work is trivially simple. I can connect, and, for example, get everything in any given table. What I have yet to find is how to deal with parameterized queries or how to do a simple insert (but not of a value known at the time the script is written - I ultimately want to put my script into a scheduled task, so the analysis can be repeated on updated data either daily

Hi everyone, For one of our projects we have a need to deploy and maintain a demo. As a result I''ve attempted to setup a set of rake tasks for the job. My goal is have one rake task called "deploy_demo" which purges the database, migrates to the current schema, and loads the db from a set of fixture files in a specified location. I''ve written two new tasks the perform

The build failed. CHANGES ------- Revision 8649 committed by gbuesing on 2008-01-16 20:07:10 Introducing DateTime #utc, #utc? and #utc_offset, for duck-typing compatibility with Time. Closes #10002 M /trunk/activesupport/CHANGELOG M /trunk/activesupport/lib/active_support/core_ext/date_time/calculations.rb M /trunk/activesupport/test/core_ext/date_time_ext_test.rb TEST FAILURES AND

Hi (I''m resubmitting this because First question: This is the rails dev list, correct? I''d like to submit a patch and am following the steps on this page: http://dev.rubyonrails.org/ Here''s what I did (using mysql 5.0.15-nt): created 2 databases: activerecord_unittest activerecord_unittest2 created 1 user: rails (giving all priveleges to both databases) ran

Hi, [This is a repost, I can?t find where went my previous post, ] I wanted to create subdirectories in the fixtures directory in order to be able to manage many different initial states for my system (or to sort fixtures / corresponding model subpackages). I came up with the idea of writing: Test::Unit::TestCase.fixture_path = RAILS_ROOT + "/test/fixtures/selling"

On an average I get this error twice or thrice a week. After I rebuild the index Event.rebuild_index it works fine. I''m a bit puzzled by this behavior. Why does this happen? I am using AAF. End-of-File Error occured at <except.c>:79 in xraise Error occured in store.c:216 - is_refill current pos = 301, file length = 301 /usr/local/lib/ruby/site_ruby/1.8/ferret/index.rb:517:in

Hi, I get this when searching or adding a new record. I am using today''s version of trunk and gem ferret 0.10.0 any ideas? thanks! EOFError in DvbesController#new End-of-File Error occured at <except.c>:103 in xpop_context Error occured in store.c:197 - is_refill current pos = 0, file length = 182 RAILS_ROOT: script/../config/.. Application Trace | Framework Trace | Full

Hi, I have an application running on Apache SCGI (Win XP). Once I run it in production mode (scgi_ctrl config -S -e production ) I''m getting stack trace instead of HTTP status 500 (Application Error) and the error is logged production.log. The application works fine without SCGI. Your help is highly appreciated.... Thanx /* production.log */ # Logfile created on Thu Jan 04 16:35:43

I am reading the agile web development with rails book, and starting to create the depot. I am getting the below error after setting up the "ruby script/generate scaffold Product Admin" does anyone know what the problem is? NameError in AdminController#index uninitialized constant Mysql RAILS_ROOT: ./script/../config/../ Application Trace | Framework Trace | Full Trace

We spent a big chunk of yesterday hunting down a strange bug in one of our rails apps and created a test project to try out different theories on what was going on. The result so far is a very small test case app that perfectly reproduces the problem. The question is, is there anything *wrong* with what we''re doing here, or is it a problem with ActiveRecord? We''re on rails

Hi all, Windows XP Oracle 10g client OCI8 0.1.16 Ruby 1.8.5 Rails 1.1.6 I''m hitting weird behavior with the Oracle adapter and a find_by_sql call on a multi-table join. The SQL looks like this: SELECT DISTINCT e1.ip_address, loc.street, loc.city, loc.state FROM schema.net_element ne, schema.equipment e1, schema.equipment e2, schema.building b, schema.cust_loc cl, schema.location

Hello, In a model I have: has_many :things, :finder_sql => '' select * from other_things '' + '' where id = #{id} '' When I do MyClass.find(:all, :include => :things) I get a weird error: from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/abstract_adapter.rb:120:in

Hi, When I try to run a controller that connects to my project''s sqlite database, I get the following exception: SQLite3::CantOpenException in PostController#index could not open database config/database.yml correctly points to my database, like so: development: adapter: sqlite3 database: db/dev.db I''ve had Rails projects working with sqlite3 before (recently), but

Hi, I trieed umpteen times to connect ruby on rails to MSSQL server using the standard procedures and I always get the samw error. As I was previously working with MYSQL I faced no problem .Now at a time critical situation I need a solution for this........... Open OLE error code:800A0E7A in ADODB.Connection Provider cannot be found. It may not be properly installed. HRESULT error

Hi all, Any help with this would be appreciated. I''m using instant rails, updated to 2.2.2, on Windows XP. I''ve created my DB and scaffolded a few things and put some fixtures into place, and when I run the tests I get many errors that look like this: --------------------------------- 1) Error: test_the_truth(EntityTest): NoMethodError: undefined method `key?'' for

Hi. Whenever I use activerecord I get this error NameError: uninitialized constant Mysql. I installed the mysql 2.7 gem and I''m on Rails 1.1.6 / Ruby 1.8.4. The gem was built successfully using ''gem install -- --with-mysql-config=/usr/local/mysql/bin/mysql_config''. Here''s a sample trace of the error in ''script/console'': >> User.find 1

Any idea what would cause this? >> icps = Icp.find(:all) ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported file format: SELECT * FROM icps from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor d/connection_adapters/abstract_adapter.rb:120:in `log'' from c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_recor

I recently updated Rails to the latests version, and one of my existing apps broke. More speficially, it can''t find the method "updated?" when it is attempting to call it on one of my models. The stack trace follows: NoMethodError undefined method `updated?'' for #<MyModel:0xc91d50>

I am just starting out learning RoR. I am trying to follow along with the Depot project in "Agile Web Development With Rails ed2" and get the error "You have a nil object when you didn''t expect it! You might have expected an instance of Array. The error occured while evaluating nil.[]" I ran --trace and get the following, but I am not sure what it means. Can