similar to: ActiveRecord tests

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

I''m resending this with additional information, as I''ve had no response. I''ve been trying to use the fixture_references plugin, and I seem to be getting lots of: 1) Error: test_truth(DeviceTest): ActiveRecord::StatementInvalid: Mysql::Error: #HY000Field ''description_id'' doesn ''t have a default value: INSERT INTO devices (`id`) VALUES (2)

In an effort to not be a vamp. (Thanks Amy) Here is the error message = I''m getting. Mysql::Error: #42000You have an error in your SQL syntax; check the = manual that corresponds to your MySQL server version for the right = syntax to use near ''=A1=C9=A8[=A9=B4#Globals = (ActiveRecord::StatementInvalid) SET @rightnow =3D current_timestamp; It appears that Active Record is

Hi, I''m totally new to Ruby and Rails and I''m trying to set up a prototype web site. Unfortunately, I''m having problems with ActiveRecord using multiple threads. What I want to do is fairly simple. I have a Controller that receives and saves data from the web in the DB, but once that''s done I want to process this data in another thread and then save the

I have this problem as well... After so many hours of inactivity, I get "statement invalid" and if I restart Apache or WEBrick, everything works fine again. What steps can I take to fix this? I don''t want to have to restart the server! -Brian -----Original Message----- From: rails-bounces-1W37MKcQCpIf0INCOvqR/iCwEArCW2h5@public.gmane.org

Hi, I''m having a bit of a problem with a rails app and I wonder if anyone can help. It seems to run fine for a while, but if it''s left running too long (left running as a fastcgi or webrick process that is) it starts failing with an "ActiveRecord::StatementInvalid" error (i''ve included the full error from the log file below). I''m seeing this on both

It doesn''t like SET commands, or #Comments, etc. Looks like no way = around this without using forgoing active record. I don''t really want = to do that at this point. --------------------------- Brian Corrigan --------------------------- -----Original Message----- From: rails-bounces@lists.rubyonrails.org = [mailto:rails-bounces@lists.rubyonrails.org] On Behalf Of Brian

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

I''m struggling with activerecord and mysql blobs (uploading files)... blobs over 400K-ish cause the below exception... ActiveRecord::StatementInvalid in File#upload Mysql::Error: Lost connection to MySQL server during query: I''ve tried blob, mediumblob, and longblob... I''m using windows xp for development - and have not installed the mysql gem... simlar google

any suggestions on why I am gaining this error. ActiveRecord::StatementInvalid in ProjectsController#create 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 '' , , , , )'' at line 1: INSERT INTO projects (`name`, `date_created`, `quote_id`, `client_id`, `description`, `user_id`)

Hi There, I''m gettings the following errors while accessing my application. Can someone please tell what is the possible cause and can it be resolved. " ActiveRecord::StatementInvalid in Site#showalladdress Showing site/showalladdress.rhtml where line #3 raised: Mysql::Error: #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version

My production environment is actually Oracle, in which case if I say: set_table_name "v_table" It will treat it as a readonly table. However, doing the same under MySQL throws an ActiveRecord::StatementInvalid error, saying that the table db.view doesn''t exist. Is there a way to get around this? I am using MySQL to test some new code I am working on, and wouldn''t

I have an error I don''t know how to debug. I am adding the login suport in Depot (the example in the RoR book) and LoginController#add_user throws ActiveRecord::StatementInvalid in an innocent /login/add_user GET request. The trace goes down to a call to SQLiteAdapter#table_structure, and the source code suggests what''s happening is that "PRAGMA

Hello. I''m trying to do the video tutorial "how to build a blog engine in 15 minutes with ruby on rails" from the main rubyonrails website, and I''m getting an error when I try to use scaffold :post after editing my config file for the mysql database. Here is the exact error I''m getting: ActiveRecord::StatementInvalid in BlogController#index

Hello all, I know that this issue has come up before, but I read all the previous posts regarding thread safety and haven''t come up with a solution. I''m spawning lots of threads in a backgroundrb worker that each do things with activerecord models. I get the connection lost to mysql server exception about 90% of the time, with my process working by sheer luck the other 10%.

I intentionally deleted the attribute author from the table comments. When I used functional testing, I got the following message ActiveRecord::StatementInvalid: PGError: ERROR: column "author" of relation "comments" does not exist What should I need to do in order to avoid this error message!!! -- You received this message because you are subscribed to the Google Groups

Hi, I''m writing some scripts on the command line using ActiveRecord, and some interesting (read: confusing) things are happening with the way exceptions are caught and re-raised. In AbstractAdapter.log (connection_adapters/abstract_adapter.rb:144), Exception is rescued and reraised as an ActiveRecord::StatementInvalid exception. While in most cases I''m sure this is fine,

Hi I would like to write my first application with Active Record: this is my database table: id PRIMAREY KEY auto_increment german_name varchar(50) english_name varchar(50) | wingspan this is my code: ======================= #!/usr/local/bin/ruby -w require ''rubygems'' require_gem ''activerecord'', ">= 1.10.1"

Howdy, I have a model I called ''content_series''. I created it and noticed that Rails called it ''Sery'', so I added ''series'' to the uncountable thing in the config, like this: Inflector.inflections do |inflect| # inflect.plural /^(ox)$/i, ''\1en'' # inflect.singular /^(ox)en/i, ''\1'' #

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'',