Ticket #337 (closed Bug: duplicate)

Opened 3 months ago

Last modified 1 month ago

Create INDEX in the table CREATE sql instead of a different query

Reported by: matt Assigned to:
Priority: major Milestone: DigitalVibes
Component: Core Version:
Keywords: Cc:

Description (Last modified by matt)

Some web hosting services forget to give permission for ADD INDEX for the mysql users of their customers. Piwik creates the INDEX in a separate query at the moment, but this is not necessary. We could create the index in the CREATE TABLE statements.

In case we have to create the index afterwards (during the update process), we should catch this error and display a friendly error message (Please ask your web host to give you CREATE INDEX permission// or here is how to do it yourself)

Change History

09/07/08 16:10:31 changed by matt

  • description changed.

10/10/08 15:20:28 changed by matt

  • milestone changed from Stable release to DigitalVibes.

10/10/08 18:54:24 changed by matt

  • status changed from new to closed.
  • resolution set to duplicate.

dup of #30