similar to: Issue updating database from csv file

Hi Today I got an alert mail from my watcher script, telling me that there was no Mongrel running, and that it started one (so the site was down for a few seconds.) This is the first time I got this error (AFAICS), but I''d like to resolve and prevent it for the future. From mongrel.log: ** Starting Mongrel listening at 0.0.0.0:foo ** Starting Rails with production environment... **

Hi, After playing while with ActiveRecord, I''m surprised it isn''t easier to insert data into a table whose primary key is not auto-incremented by the database server. The following code... --------------------------------------- -- MySQL database "test" --------------------------------------- CREATE TABLE gardens ( code integer NOT NULL, name

Hi there, I''m using the wonderful file_column and have struck an issue that someone might have seen before. My images already sit on the server. So, instead of passing a multipart message I''m sending a file object. Something like... f = File.new("public/gallery_images/builder.png") p = Product.find_first p.image = f p.save On the save I recieve an error which

I was wondering if anyone here has seen a similar error to this... >From mongrel.log /usr/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/active_record/ transactions.rb:85:in `transaction'': Transaction aborted (ActiveRecord::Transactions::TransactionError) from /usr/lib/ruby/gems/1.8/gems/mongrel-1.0.1/lib/mongrel/ configurator.rb:293:in `call'' from

Hi, I am trying to save a Mechanize object in database (using a Rails Model). But the save operation throws a TypeError Considering that "agent" is an instance of a Rails Model and "user" is defined as a "text" type in the Model. irb(main):039:0> agent.user = WWW::Mechanize.new #<WWW::Mechanize:0xb71295f0 @follow_meta_refresh=false, @key=nil,

Hello, Once or twice a day I''m losing connection to MySQL and this error is generated: Mysql::Error: Lost connection to MySQL server during query: INSERT INTO pictures (`content_type`, `name`, `size`, `thumbnail`, `updated_at`, `pictureable_type`, `description`, `pictureable_id`, `filename`, `height`, `user_id`, `parent_id`, `created_at`, `width`) VALUES(''image/jpeg'',

Hello Everybody, I picked up on the buzz about RoR and wanted to see what the fuss is about. So far i am very impressed but have hit a bit of a wall with a little play app i am writting. I want to iterate through a CSV file of my bank transactions and see just how much money i spend on beer and pies every month. I have successfully setup a database with a single table called transactions

Hi, I''m switching the database of a rails 3 app I have developed from postgres to mysql so that I can avail of amazon''s rds. Before I make the change I have been running my test code using mysql on my dev machine with the mysql2 adaptor . My test code is throwing up some errors that I haven''t quite been able to get to the bottom of yet. Basically I have a model that is

I have 2 models SmsAddress & OutboundSmsAtom SmsAddress { has_many :other_objects, :dependency => :nullify } OutboundSmsAtom { #note this object also "belongs_to" other objects if that matters belongs_to :this_object } Whenever I try to destroy an object of type ThisObject, which at the time has 0 "children" OtherObjects I get the following type of

I am having this crazy problem where it ONLY shows up in testing. This is my test code <code> def test_should_destroy task1 = Task.new(:description => "tmp", :done => false, :user => User.find_by_login(''admin'')) assert task1.save assert task1.destroy end </code> This is my task model

Hi, I am having a problem connecting to a remote mysql db and I can''t figure out what the problem is. When I try to connect I get the error: getaddrinfo: no address associated with hostname. I have looked all over for clues as to what that means but I haven''t been able to find anything that helps. I have no problems connecting to the database with php and with the mysql query

Hello All, I''ve run into a snag. (I apologize in advance. I''m not very good at system administration.) I''m building an app that allows users to upload files. Up until now I have been storing the files on the file system, but tonight I decided to change the app so the files are stored in the database as a longblob. I thought everything was working great, until I

I had this problem all of a sudden, just changed some puppet classes in my modules, but no particular stuff or no error in the catalog creation. Env : Puppet master version 3.2.0-rc1 Centos kernel 2.6.32-279.11.1.el6.x86_64 ruby 1.8.7 (2011-06-30 patchlevel 352) [x86_64-linux] Info: Caching catalog for jbossvdbmaster.prod.italy.cloudlabcsi.eu Debug: Searched for resources in 0.01 seconds Debug:

Hello, I am exploring the "Testing" part of Rails, but It seems some things work differently than I thought it would. Consider the following model: class Client < ActiveRecord::Base has_one :project def after_create Project.new(:name => self.name, :is_client => true, :client_id => self.id).save end def after_update

Hi, Ruby 1.8.4 Rails 1.1.4 Windows XP Pro I''m hitting an issue with migrations that I suspect relates to pluralization. Here''s the migration: class Hardware < ActiveRecord::Migration def self.up create_table :hardware do |h| h.column :vendor, :string, :limit => 32 h.column :model, :string, :limit => 32 end

hello can anybody help me with this bug, (this sometimes occur sometimes passes) 1) ActiveRecord::StatementInvalid in ''MailReader on Simple Tasks should not accept duplicate email'' Mysql::Error: MySQL server has gone away: ROLLBACK TO SAVEPOINT active_record_1 /home/poldz/.gem/ruby/1.8/gems/activerecord-2.3.5/lib/active_record/connection_adapters/abstract_adapter.rb:219:in

Pessoal, estou precisando de ajuda... Estou usando o rails 2.3.2. Quando tento fazer qualquer update (método save em um registro existente), recebo o erro abaixo: ArgumentError in RequisicaosController#enviar_rede wrong number of arguments (3 for 1) c:/ruby/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/ base.rb:2875:in `attributes_with_quotes''

Man I am frustrated. 4 hours working on this and i can''t find an answer. Here it goes. I had some simple date select fields on a form. Then I wanted to add some additional datetime fields on a form with a nice widget so I installed the dhtml_calendar plugin. Now my migrations and forms don''t work on insert stating that the argument is out of range. Here is line #62 in the

I am trying to debug this mockup, it runs fine from the shell, but when I run it from within emacs with rubydb, I get an exception. I''ve tried this in the past, running a test from within emacs and it failed. I think it has something to do with the environment. I''m not sure how I should invoke the interpreter to give ActiveRecord access to what it needs. Currently I just call it

Here''s the trace, NoMethodError: undefined method `accept'' for nil:NilClass from /Users/blaine/.rvm/gems/ruby-1.9.2-p290/gems/activerecord-3.2.3/lib/active_record/connection_adapters/abstract/database_statements.rb:7:in `to_sql'' from