Opened 14 years ago

Closed 13 years ago

#8 closed defect (fixed)

Check we have needed permissions before destroying any data on upgrade

Reported by: Dominic Hargreaves Owned by: Dominic Hargreaves
Priority: major Milestone: 0.70
Component: wiki-toolkit Version: svn
Keywords: Cc:

Description

We need DROP,CREATE,INDEX in order to upgrade the db schema, but we can get as far as dropping all the data and then not being able to create the indexes. due to a missing INDEX privilege. We then bail out and lose all the data. Check that we have all needed privileges before doing anything during the upgrade.

Change History (3)

comment:1 Changed 14 years ago by nick

How do you (in standard SQL) check to see if you do have the permissions?

(I suppose we could try and create a dummy table, then add an index on it, then drop it, but it doesn't seem that clean to me)

comment:2 Changed 14 years ago by anonymous

Milestone: 0.70

comment:3 Changed 13 years ago by Dominic Hargreaves

Resolution: fixed
Status: newclosed

(In [319]) Check that we can do all we need to when upgrading MySQL database (closes #8)

Note: See TracTickets for help on using tickets.