similar to: Get info from Mysql tables

Hi, am having troubles with Slovene characters in rails. If I set <meta http-equiv="Content-type" content="text/html; charset=utf-8" /> I am not getting Slovene characters in Views (I mean RHTML). However everithyng is fine with data that comes from data base. if I set : <meta http-equiv="Content-type" content="text/html;

I''m using the acts_as_taggable plug-in (actually, the one on steroids - http://www.agilewebdevelopment.com/plugins/acts_as_taggable_on_steroids). It seems to work OK in the tests I''ve written, but when I query the DB to see how the tags are stored, I see that the tables tags & taggable are empty. Yet, the query from w/in the tests seem to return correct results. Is there a

Any thoughts on how to avoid this problem? Already tried: 1. Setting the charset and collation in migration 001 - no effect: def self.up db_name = ActiveRecord::Base::connection.current_database() execute "ALTER DATABASE #{db_name} CHARACTER SET utf8 COLLATE utf8_bin" end 2. Setting the charset and collation on each table individually - no effect:

I extracted metadata from my image files and stored them in a mysql table using the default .yml configuration. The meta data includes a lot of "Copyright (c) Kip 2007 blah blah blah" (only with the real symbol \251). When I display the information from my app in a browser I got the "square" replacing the symbol. SInce the headers all looked fine if figured it was the

I''m running OS/X 10.5 Leopard. Although I have MySQL installed the rails command creates a database.yml file that defaults to SQLite. How do I get it to default to MySQL instead? TIA --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to

Hey Folks, I''m just getting up and running, using DarwinPorts and encountered a MySQL error when trying to install. Would appreciate any insight any of you might be able to offer to resolve this. I''m trying to install the MySQL Native Bindings for a performance boost on the MySQL adaptor. The specific tutorial I''m following is as follows:

I have a "data warehouse" application I''ve been writing and I would like to solicit some assistance with how to design it. Basically, I harvest data from a lot of sources and dump them into my database. For background on what I''m doing, this "data warehouse" takes HR/Personnel/Company/Organizational data and associates that with User Account and Group data

Hi, Just running a simple unit test and trying to save an object gives me this error. test_validations(FriendTest): NoMethodError: undefined method `each'' for #<Mysql:0x38f60d0> c:/ruby/lib/ruby/gems/1.8/gems/activerecord-1.14.4/lib/active_record/connection_adapters/mysql_a dapter.rb:292:in `columns'' .... .... Rails 1.1.6 mysql 5 mysql gem 2.71 After I

this is the versions i have installed: Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Mark Johnson>ruby -v ruby 1.8.6 (2007-03-13 patchlevel 0) [i386-mswin32] C:\Documents and Settings\Mark Johnson>rails -v Rails 1.2.6 C:\Documents and Settings\Mark Johnson>mysql -v ERROR 1045 (28000): Access denied for user

Hi, I''ve got an app that talks to two databases on a given MySQL server. When I run in development mode, pointing to the MySQL server running on localhost (127.0.0.1), I am able to access both databases without any problem. The relevant yaml looks like this: (names have been changed to protect the innocent) development: adapter: mysql database: dev username: username password:

In my app, for three models: foo,bar and baz, the database connection is made to a different database and hence in model code: class Foo < ActiveRecord::Base establish_connection :diff_database end class Bar < ActiveRecord::Base establish_connection :diff_database end class Baz < ActiveRecord::Base establish_connection :diff_database end Now, the problem is, if is use the above

I just installed acts_as_authenticated into an app and one of its unit tests is failing. The cause is that another unit test''s changes to the AAA fixtures aren''t being rolled back. I''m confused, since I have transactional fixtures turned on and MySQL InnoDB engine being used. Details: - MySQL 5.0.24. InnoDB is the default engine, all tables in the test db are using the

Hi I''m a noob to RoR. I have everything setup but can''t figure out to get the list display as I would like. I''m sure this is very simple stuff. I just haven''t figured it out yet :( I hope someone can point me in the right direction :) I have a mysql table "websites". In it I have the following columns - Name, Url, Banner, Description I created

Hi, Im using locomotive and running SQLight. Im confused about making tables with sqlight. Im following the depot example from ''agile web development with rails''. When trying to make the table ''products'' is there a difference when using SQLight rather than MySQL? Here is the DDL for MySQL, how do I make this table with SQLight? - drop table if exists

I got my first taste today of dealing with the default values in MySQL. It seems that Rails loads the default values for fields based on the database (seems reasonable, specify in one place and let if flow through). The problem is that if I say NOT NULL and do not specify a default value, MySQL inserts a default value anyway. See http://dev.mysql.com/doc/refman/5.0/en/data-type-defaults.html

Has anyone else had problems with the mysql native gem when using MySQL 5.0.41. It appears that this version of MySQL has moved some depended library files. I rolled back to MySQL 5.0.37 and all seems to be working now. But, just wanted to know if anyone else has experienced this issue. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed

So, man, character encoding is confusing. Worse, I''m talking to a vendor-supplied database (read-only) that I did not add the data too. At least this vendor-supplied database is MySQL. So this database has some accented charactars in it. For instance, something as simple as a lowercase o with an acute accent, for example. At first, this character was not being displayed correctly in my

I just did an unwanted mysql upgrade and am now unable to start the mysql service. After doing some searching the common solution is to just create a symlink ln -s /var/run/mysqld/mysqld.sock /tmp/mysql.sock The issue for me is I don''t have the file I am trying to symlink to (/var/run/mysqld/mysqld.sock) If I try to start mysql manually (mysql start) I get the error: # mysql start

We are currntly running mongrel v 1.1.4 mongrel_cluster 1.0.5 mysql gem 2.7.5 (built from source) rails 2.0.2 ruby 1.8.6 mysql version 4.1 this is run on a remote server. We are consistently getting "ActiveRecord::StatementInvalid (Mysql::Error: MySQL server has gone away: SELECT * FROM...." errors. When i then try and stop mongrel some (various) of the mongrels are in error state

I''m a newbie trying to follow the ONLamp RoR tutorial at http:// www.onlamp.com/pub/a/onlamp/2005/01/20/rails.html?page=1 Originally, I forgot to install the MySQL driver. It took a while to get a driver installed using gem, but eventually I got mysql-2.7 driver installed after downloading some ruby dev headers and mysql client library. Now, when I try and point the browser to