Menu

Commit [r8079]  Maximize  Restore  History

0.12dev: Renamed the `key` column of the `cache` table to `id` for MySQL compatibility, and changed the type of the `generation` column to `int`.

'''For people who have already upgraded their database to version 22, this requires manual intervention on the database.'''

You can either remove the `cache` table and re-create it by hand:
{{{
DROP TABLE cache;
CREATE TABLE cache ( id text PRIMARY KEY, generation int );
}}}
(for SQLite; or the equivalent for your database)

Or you can downgrade the database version, drop the `cache` table, and upgrade again:
{{{
UPDATE system SET value=21 WHERE name='database_version';
DROP TABLE cache;

trac-admin $TRAC_ENV upgrade
}}}

Closes #8197.

rblank 2009-04-08

changed /trunk/trac/cache.py
changed /trunk/trac/db_default.py
changed /trunk/trac/upgrades/db22.py
/trunk/trac/cache.py Diff Switch to side-by-side view
Loading...
/trunk/trac/db_default.py Diff Switch to side-by-side view
Loading...
/trunk/trac/upgrades/db22.py Diff Switch to side-by-side view
Loading...