similar to: MySQL Help?

Hi- I am trying to use AJAX calls to login and logout of my Rails app so that the form renders in the side bar when you are not logged in, and your "profile" renders if you are. It all works, but when you logout, and try and log back in, you get "ActionController::InvalidAuthenticityToken", in the development.log. What does this mean, I can''t figure out how to fix

Hi, I can run the code some days ago . But cant run now.  Problem 1: Output is ok ensembl = useDataset("hsapiens_gene_ensembl",mart=ensembl) utr5 = getSequence(chromosome=3, start=185514033, end=185535839, type="entrezgene",seqType="5utr", mart=ensembl)  Output :                                                                                                5utr

Using: # rsync --version rsync version 3.0.7 protocol version 30 Copyright (C) 1996-2009 by Andrew Tridgell, Wayne Davison, and others. Web site: http://rsync.samba.org/ Capabilities: 64-bit files, 64-bit inums, 32-bit timestamps, 64-bit long ints, socketpairs, hardlinks, symlinks, IPv6, batchfiles, inplace, append, ACLs, xattrs, iconv, symtimes rsync comes with ABSOLUTELY NO

If I have a form similar to the one below, and ''start'' is a "string" field in my Database. Is there a way to take all of the date/time params and put them into ''start'' without too much hacking? I would like this to be as clean as possible. <p><label for="start_time">Start Time</label><br/> <%=

Hi- Is it possible to use search parameters with will_paginate? For example, something like this: @var = Model.paginate :per_page => 20, :page => params[:page], :order => ''my_date DESC'', :conditions =>["my_date >= ? AND my_date <=?",@start,@end] I am getting some errors with this, but will this generally work?

I have a huge mysql.log file full of errors. I'd like to sort it by the most common line, and work from there. I did go through the manpage for sort, and googled a bit, but I found nothing relevant. Here is an example of the output: [root@ log]# tail mysqld.log 110925 11:05:35 [ERROR] /usr/libexec/mysqld: Incorrect key file for table './ox_data_summary_ad_hourly.MYI'; try to repair it

Hello group, I'm having a very hard time rsyncing efficiently a MySQL database which contains very large binary blobs. (Actually, it's the database of Mantis bug tracker [http://www.mantisbt.org/], with file attachments stored directly in the table rows. I know it's a bad idea from many other reasons, but let's say it was given to me as such.) First, I was dumping the

Hi'' Rails riders. I having upgraded everything and upgraded to Rails 2.2.2 I now wanted to install the MySQL gem as I am getting the following error when trying to load up the app. no such file to load -- mysql Normally running gem install mysql works with no problems but, now I get the following: >gem install mysql gem install mysql Successfully installed mysql-2.7.3-x86-mswin32 1

I am trying to speed up some DB operations and perhaps have gone overboard with indexes. Does MySQL usually use only one index per query and simply match keys on the results of the indexed first part? For example: DELETE FROM tokens WHERE 6813946236211560448 <= fnv AND fnv < 6818449835838930944 AND updated_at<''2010-06-20 14:08:55'' AND occurrences=0; If I understand

Dear R-Group: Recently, I ran into a problem. I was using a function called "I.1", which evaluates the first-order modified Bessel function of the first kind, in the package "CircStats". This function is not vectorized, since it uses a couple of "if" conditions. However, when I called this function with a vector argument, I got no error/warning messages in

I am trying to switch from sqllite3 to mysql on Ruby on Rails. Whenever I try to install the mysql gem, i get an error: *** extconf.rb failed *** Could not create Makefile due to some reason, probably lack of necessary libraries and/or headers. Check the mkmf.log file for more details. You may need configuration options. I cd''d into my usr/local/bin directory and saw i have several

Hi there! I am PHP developer and trying to learn ROR. Currently I am building my first Rails website (OS X Snow Leopard, TextMate) and decided to switch from sqlite to mysql. After many-many hours of searching the internet I managed to install mysql gem. Now I get this error when I try to run rake migrations: rake aborted! Mysql::Error: query: not connected: CREATE TABLE `schema_migrations`

Hi, I am trying paginate (will_paginate) users posts. It is counting and showing the page links correctly, but still showing all the posts on one page. @entries = @user.entries.paginate :per_page => 5, :page => params[:page], :order => ''created_at DESC'' If I change it to @entries = Entry.paginate :per_page => 5 ........ It is fine, but I would like to show only

I am running into problems with MySQL and lookups. The table has character set utf8, but: mysql> select id, token from tokens where token = ''esta''; +-------+-------+ | id | token | +-------+-------+ | 83417 | está | +-------+-------+ 1 row in set (0.00 sec) How do I configure things so MySQL doesn''t ignore accents? TIA, Jeffrey

Hi- I''d like to load a PDF file into a page, in my controller: send_file "/path to/my.pdf", :disposition => "inline" However, instead of rendering inline, it asks to download the file. How can I display the contents without downloading? Thanks! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the

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 All, I am a real neophyte with Rails and am struggling with something. I hope you can point me in the right direction. I have a model of an object that class Thing< ActiveRecord::Base attr_accessor :locator_id has_one :otherthing has_one :differentthing end I can create and delete these things until the cows come home. However, trying to change the data and save/update I get a

Hey all- Re-installed OSX yesterday and with it, Ruby and Rails Now when I try to run db:migrate I get the error message: "!!! The bundled mysql.rb driver has been removed from Rails 2.2. Please install the mysql gem and try again: gem install mysql. Rake aborted! no such file to load -- mysql" So, I try sudo gem install mysql -- --with-mysql-dir=/usr/local/mysql And get:

Hi, Found a simple example breaking on moving to 2.2 from 2.0. This example illustrates the usage of nested :include finder options. class Book < ActiveRecord::Base has_many :distributors end class Distributor < ActiveRecord::Base belongs_to :book has_many :agents end class Agent < ActiveRecord::Base belongs_to :distributor has_many :shops end class Shop <

I am using image_tag to load an image that I''ve saved to the database (using attachment_fu if you''re curious but that''s probably not relevant here): VIEW <%= image_tag ''/photo/get_image/5'' %> CONTROLLER def get_image @photo=Photo.find(params[:id]) send_data(DbFile.find(@photo.db_file_id).data, :type =>