Database issues

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.

Can't DROP

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.

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.