Ticket #8 (closed defect: fixed)

Opened 6 years ago

Last modified 6 years ago

Check we have needed permissions before destroying any data on upgrade

Reported by: dom Owned by: dom
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

Changed 6 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)

Changed 6 years ago by anonymous

  • milestone set to 0.70

Changed 6 years ago by dom

  • status changed from new to closed
  • resolution set to fixed

(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.