In this article
ALTER command denied
If you see an error message like this
ALTER command denied to user 'USERNAME'@'DBHOST' for table 'nextend2_section_storage' ALTER TABLE `nextend2_section_storage` DROP INDEX `application`
that means the database user doesn't have the right to run the ALTER queries. ALTER queries are is a commonly used MySQL codes, so it should be allowed to run them. You should contact your server host and ask them to check the database user's permission, and make sure that it has the right to alter tables.
If you see these messages following each other:
Can't DROP INDEX 'application'... Duplicate key name 'application'...
there will be something wrong with your database. You can see how contradictory they are: First you are getting "Can't DROP INDEX `application` check that it exists", like if "application" wouldn't exists, then "Duplicate key name 'application'", so it does exists after all. This means, that either our ALTER or DROP database actions couldn't happen due to a misconfiguration/error on the server. You should contact your server host and ask them to fix this for you.
Duplicate key name
You might see a similar error to the previous one:
Duplicate key name 'application' for query ALTER TABLE `nextend2_section_storage` ADD INDEX `application`
without the "Can't DROP" message. The error in this case will still be the same, as the way our code runs is, that it first uses this code:
ALTER TABLE `#__nextend2_section_storage` DROP INDEX `application`
to DROP (delete) 'application' and the next ALTER code will only happen afterwards. So you couldn't have a duplicate 'application', if this DROP code would have been able to run. This means, that your database user either doesn't have permission to do ALTER or DROP database actions due to a misconfiguration/error on the server. You should contact your server host and ask them to fix this for you.
If you see a similar error message:
Unknown column 'sliders2.status' in 'where clause'
your problem will be, that your database user is either not able to use DROP or ALTER database queries. Next to this error message probably you will see a "Try to repair database" button, what you should press. This will probably write out an error message with ALTER command denied or Can't DROP, to tell you exactly which permission is missing.