I was following this set of instructions from the “Cookie overflow?”
Your sessions (by default in cookie) needs to be moved to Active record
store or memcache store to fix this issue.
For Databased sessions:
config.action_controller.session_store = :active_record_store
You need to create the session table as below
I added the config line to environment.rb; is that the approriate place?
When I ran the migration, I got
An error has occurred, this and all later migrations canceled:
SQLite3::SQLException: table “artists” already exists: [etc]
So I removed the existing, populated database (to a safe place, since I
do not want to have to create it again unless necessary) and ran the
rake db:migrate again…clearly there is something I don’t understand
because most sane people would want to preserve the contents of an
existing db when they modify it.
Now I have a problem, because of course the new (empty) database has an
extra table in it. Before I go and write a ruby script to create a
database containing my old records + the new table as it appears in
schema.rb, is there not a simpler, more sensible way to do this?
If I do have to remake the db manually, can anyone answer a questions
for me regarding the session table: Does it also use a column “id” as
the INTEGER PRIMARY KEY? I suppose it won’t matter if it doesn’t and I
put one in anyway…