ansaurus

Question

Answer 1

+1 A:

What shows up in the error log after you access the page that gives that error?

Also, what is the column type for your session information in MySQL? TEXT?

------------- EDIT BELOW ----------------

Ok, as far as I've been able to determine, this error generally means that the size of the content that you are shoving in the session is too large for the MySQL column. The most common solution cited seems to point towards a solution of changing the column from TEXT to LONGTEXT.

Try running something like this in MySQL and see if it gives you any improvement:

ALTER TABLE sessions CHANGE COLUMN data data LONGTEXT

The obvious solution is to not store the CSV data in the session as that's probably not the best place to put it, but I don't know your reasons behind what you're doing, so maybe you have no other options.

Give that a try and let me know if it worked.

Eric Ryan Harrison 2009-12-18 15:02:35

i have added the error log!!yes, the type of column data is text

Nitin Garg 2009-12-18 15:37:08

working :) thanx

Nitin Garg 2009-12-28 12:35:00

Answer 2

A:

Also make sure to either base64 encode it or store it in a binary data type (such as BLOB), otherwise it will probably cause errors.

neel 2010-04-02 11:40:05

Answer 3

+1 A:

Instead of the manual ALTER TABLE you could also do a migration with a limit, like this:

class FixSessionStore < ActiveRecord::Migration
  def self.up
    change_column :sessions, :data, :text, :limit => 4.megabytes
  end

  def self.down
  end
end

This will turn the column into a MEDIUMTEXT and also show up correctly in your schema.rb.

DarkDust 2010-08-09 10:38:13

ansaurus

tags:

views:

answers:

marshal data too short!!!

related questions