similar to: Table Unknown - SCHEMA_INFO

I am trying to validate an integer field called quantity. I don''t know how to chack if it has gone beyond or below the maximum or minimum value allowed by the Firebird RDBMS. I tired adding this code to the validate method in the model: if (quantity > -2147483648) and (quantity < 2147483648) errors.add("quantity", "is out of range (must be between

The Action Controler List worked, but if i add one new record, i''m view the message bellow " FireRuby::FireRubyException: Error preparing a SQL statement. Dynamic SQL Error SQL error code = -842 Precision must be from 1 to 18 Wrong numeric type SQL Code = -842 Firebird Code = 335544569 : SELECT CAST(0 AS DECIMAL(0,0)) FROM RDB$DATABASE " I''m apreciate any

Rubyonrails application which was working fine with rails 1.1.6, fireruby and firebird 1.5.3 does not work with rails 1.2.1. The error is reproduced below. Could not get over this problem. Any help coming through? Thanks in advance. ActiveRecord::StatementInvalid in TimekeeperadminController#authenticate FireRuby::FireRubyException: Error preparing a SQL statement. Dynamic SQL Error SQL error

I am trying to generate some scaffolding using "ruby script/generate scaffold order order". It always fails with the message "uninitialized constant CHARACTER_SET". I have an orders table in a Firebird databse called TARPRILOGISTICS.GDB. The database is in a folder named "database" in my rails app root folder. I tried FireRuby 0.4 and 0.4.1. My config file looks

I have the rails recipes book and i was going through the migrations recipe. Everything seemed to work except for the last part in trying to do a rake migrate with a migration file version 1 and the schema_info version set to 0. Without the force attribute, the rake migration fails, as expected. So the recipe says to run this: ruby script/runner

All, I have two migration files, file 1 and file 2. For reasons that I don''t want to go into unless I must, I want to only run file 2 on my production database (file 1 contains a bunch of table creation stuff for already existing tables). I figured if I created a schema_info table and set the version in it to 1, then I could just run rake db:migrate RAILS_ENV=production and just

I didn''t mention in the subject that I''m using Firebird because I''m hoping non-Firebird developers will read this since there only seem to be about four people using Rails with Firebird. First what works for me - WinXP/Rails/Apache/FireRuby works great. I''ve also got WinXP/ Rails/Apache/FastCGI working well. When I mix FastCGI and FireRuby I blow up with

Hi Guys I am pretty new to Ruby. One of our client is using Firebird as his backend database. I have to create a script which will connect to his database, fetch some data and update few tables in MS-SQL database. Now problem is: i have installed FireRuby, got databaes, changed my database.yml file. I am trying to display all the users in Members table. but i am getting following error:

I saw that the Firebird adapter was merged to the trunk last night... thanks Jeremy! Since I last submitted the fb patch (11/1), I''ve been working on several improvements, including: 1) I reorganized the code to match the newer conventions used in the other adapters (mostly just changed the order and grouping of methods, and added some "section header" comments). 2) An updated,

Hi to all, I am trying to use "ruby script/generate scaffold product". I always get the message "uninitialized constant CHARACTER_SET". I have a products table in a Firebird database called depot_development.fdb. Here is my config file : > common: &common > adapter: firebird > host: localhost > username: SYSDBA > password: masterkey >

(I know ''version'' is the only field, but in case this changed one day my question will still apply) ;) I had to drop all my tables to re-run my migrations from version 1. When I executed ''rake db:migrate'' everything ran successfully. Which puts my database ''state'' at migration 007_xxx. Now when I add a migration (008_xxx) and re-run

Is anyone using migrations with a SQL Server database who might be able to lend me a hand? I''ve used migrations with MySql in the past and haven''t run into any issues so forgive When I run rake migrate nothing is actually getting updated in my database. I created a migration using ./script/generate migration AddFooTable and updated the migration to look as follows: class

Hello! I''m new to Ruby and Rails, but have been reading along here, and searched the archives and didn''t see anything addressing some concerns I have with using Rails and Firebird. I prefer Firebird when it is available, and I''m very pleased to see that others have gotten it working with Ruby. I have been trying to use it with Rails, with mixed success.

Hi All, Is anyone successfully using ROR 2.x with Firebird 2.x in a production environment? The support seems to have dwindled. I would greatly appreciate any installation guidelines, comments or tips. What is somewhat confusing is what is required to for ROR to play nicely with firebird. I have come across fireruby, fb_adapter, fb-0.5.9...there does not seem to be cohesive install /

Posting to merb list in case it is a merb problem. (?!??) The error still happens with sequel 0.2.1. ---------- Forwarded message ---------- From: Kevin Williams <kevwil at gmail.com> Date: Sep 23, 2007 10:26 AM Subject: error with schema_info when doing multiple migrations To: sequel-talk at googlegroups.com I tried to post an issue to the project site but it kept giving me 500 server

Hi to all ... I''m an italian people. I''m developing a proget using Ruby on Rails, with Firebird 2.0 as data base. Actually I''m using this version of GEM: RUBY: 1.8.2 RAILS: 1.1.2 ACTIVE-RECORD: 1.14.2 FIRERUBY: 0.4.1 RUBY-GEMS: 0.8.10 Now I need to upgrade to RUBY: 1.8.4, because I need to use Rmagick for generate bar code. I installed Ruby 1.8.4 but now my

Hello, I get this error trying to load some data from DB. I''m using Rails 1.2.2 on Fedora Core 6 and Sybase adapter. This worked fine when application run under Rails 1.1.6 but now I''m migrating to 1.2.2 and have some problems. At browser I got: SQL Command for table_structure for tplib_bckps failed Message: schema_info not found. Specify owner.objectname or use sp_help to

Hi, When doing a ''rake migrate'', schema_info is not updated (it does not contain any row). Migration is done properly the first time, but fails the second time I run it, since there is no info in schema_info. I am running rails 1.1.2, using script/generate migration to generate the migration file. Any help? Thank you. Jean-Etienne http://www.novAgora.hu -- Posted via

Hi, my company uses only 1 database for all the developments, so it is a big problem for using migrations in Rails because of the schema_info table. How can I solve this problem? Is there a way to change the schema_info table name? Thanks. Nicolas. -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are

On a rails app that I''m developing I converted a regular old .sql file into a rails migration. Since I generated the migration in my development environment, it created the schema_info table for me. However, when I updated my production environment and tried running rake migrate it complained that schema_info doesn''t exist. Is there a rake task for getting around this yet, or