similar to: invalidate DB schema cache on production

Hi all, I''m new to Rails, I know this is a classic error, but I cannot resolve it anyhow :( This is my system config: Windows XP SP2 Ruby 1.8.2 -> installed using windows installer version Rails 1.0.0 MySql 4.1.10 I followed the instruction on rubyonrails.org, exactly step by step. But the error occur everytime I tried to generate scaffold or generate model. I tried to googling

I searched the archives and found a thread about it, but I didn''t understand: are prepared statement used by ActiveRecord on those databases that could handle them (Postgresql, Mysql, Oracle etc)? In case they are not used, are they planned? Is there a roadmap about Rails I can find somewhere?

Doing some reading up on fragment cache before implmenting it and had a few questions: 1.) I read that page and action caching have issues or don''t work at all with query strings (more so with page caching). Does fragment caching work with query strings? i.e something like example.com/foo/bar?page=2 2.) If the above is true and I have an authentication system built into my app, if 2

Is it possible to take advantage of http caching/proxy caching with dynamic pages? i.e. pages with section/part that can change over time but certain part of the page remain the same. I would rather not keep re-rendering the static part but insure the dynamic part are rendered with fresh data. I am using memcached mostly as an object store that I can minimize db hits but I still am rendering a

Hello All, I used rails caching to cache the model as in model language.rb file def self.cached_languages return Rails.cache.fetch(''languages'') { Language.all } end Now I want to add/delete some new language to database. So when the table "languages" changes it should reflect in view. For that I want to invalidate the cache. please tell me How i do that?

I can''t seem to get the fragment cache to use :file_store. I''d really appreciate it if someone could point me in the right direction. Rails 1.1 final, FreeBSD Observe: In environment.rb AND production.rb (for good measure, DRY be damned): ActionController::Base.fragment_cache_store = :file_store, "/www/apps/localfeeds/directory/tmp/fragmentcache/" At the console

Hi, I''m going through the Depot tutorial in the book "Agile Web Development with Rails" and I can''t even get past the very first step. I''m getting the following error: "Before updating scaffolding from new DB schema, try creating a table for your model (Product)" when I try to run "ruby script/generate scaffold Product Admin. I have a table

Hi I''ve discovered the following error messages in my db/schema.rb: # Could not dump table "pg_ts_dict" because of following StandardError # Unknown type ''regprocedure'' for column ''dict_init'' # Could not dump table "pg_ts_parser" because of following StandardError # Unknown type ''regprocedure'' for column

I''ve got a bunch of table creations in the schema.rb file and all is well. However, I have to manually go and create the db first. Is there a way (something like a create_database method) to get this to work? (execute "create database ..." didn''t seem to cut it either.) _______________________ Brad Eck Sr. Software Engineer Pelco 3500 Pelco Way Clovis, CA 93612

Hello. I''m working the "proper way" with creating the initial db schema via migrations and db/schema.rb. However, I have a bit of a special need, and need to know if anyone knows the solution to this; I need a sequence that is common to several tables - a "data id" that gives a sort of unique object number to every row in every table. Some associated tables (a

I am struggling here a bit.... can someone please clarify? When installing puppetdb from source, how do I create the tables/schema? I have created puppetdb as instructed in the install docs but, how/when does the schema and tables get created. Thanks! -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email

Hey there, I''ve adjusted some of my many to many join tables recently to use a composite primary key based on the id''s in the two columns - instead of using a surrogate key. I just did a db:schema:dump, and it looks something like this: create_table "class_members", :id => false, :force => true do |t| t.integer "user_id", :default => 0,

Hello, I''ve extracted from the Sportbook (formerly Wettpool)[1] the football fixtures for easy reuse. The open sports database[2] also includes a little command line tool (Ruby gem), that is, sportdb and a sample web admin tool[3] in Ruby on Rails. Events in the sport.db include - the Champions League 2012/13, - Euro 2012, - World Cup Quali and others. Add yours.

I ran into a "chicken before the egg" problem where a gem was expecting the tables to be present when loaded which was fine until you try and build the db from scratch using db:setup. When it hits db:schema:load the environment loads and the gem errors out as the tables aren''t present. I made a custom task that connected to ActiveRecord and then loads the schema file. Using

I have tables with double as their field''s datatype. When I ran db:schema:dump, Rails changed all of these double to float. I would like to know why, and if there is anyway I could preserve the datatype. Thanks a lot, Chris --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk"

I am thinking that I have found a bug in Rails migrations. My app is using UUIDtools to generate guids for primary keys. To do this I pass :id=>false and then create my own id column as shown below. Next I leverage "execute" to create an index. It seems to work fine. The table in MySql is perfect. However the ID column and primary key on the ID column are not in the schema.rb file I

Hi, I posted this before, but didn''t get an answer, so I''m trying again. I''ve recently decided to use OpenID to let users log in to my site instead of old fashioned account creation. They''ll be able to add a small amount of personal details (about three things) to their account, and post messages in the site BB. I have an openid_users table which stores the

Hi, What is the normal mechanism for creating the tables in the (a) test and (b) production databases. For example the following didn''t work for creating the production tables: a) change environment.rb to include "ENV[''RAILS_ENV''] ||= ''production''" b) run "rake db:migrate" However this seemed to still work against DEV not

Hello ! Can you please share your experiences with ZFS deployment for Oracle databases for production usage ? Why did you choose to deploy the database on ZFS ? What features of ZFS are you using ? What tuning was done during ZFS setup ? How big are the databases ? Thank you, Jay

I have a separate DB for one model in my application and in development mode the connection is working properly, in production however it isn''t. production: adapter: mysql host: myhost username: root password: database: production_db users_production: adapter: mysql host: myhost username: root password: database: other_db The model that connects to the other