The update function tries to execute the following two queries:
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content_vtype
As reported in the update log, the queries fail.
The update function tries to execute the following two queries:
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content_vtype
As reported in the update log, the queries fail.
Comments
Comment #1
hass commentedI cannot confirm the FAIL with mysql 5.0, but the bug.
Comment #2
eaton commentedFixed in the dev snapshot. Thanks!
Comment #3
int commentedComment #4
dddave commentedis the same issue I guess?
Anything I need to do about it? Can it be ignored, or what?
Comment #5
hass commentedYeah, this is all the same... I have no table prefix and this may be the reason why I haven't seen the fails.
You both need to run the ALTER operations manually as eaton haven't added an update hook to DEV, yet.
Comment #6
dddave commentedHmm? "run ALTER operations manually" would be done how? I have to admit that I have no clue about it.
Or should I wait for the next dev?
Thanks in advance for any guidance on this.
Comment #7
hass commented@dddave: Execute this on your mysql server
Comment #8
dddave commentedI guess this means entering it into the field that opens when I click on the sql tab in phpmyadmin?
Can I do them both in one shot or one after the other?
Thanks for the handholding. This is the first time I am doing something like this and off course I didn't back up the database (as I normally do) or checked the issue queue in advance (as I normally do). This bites my now.
I would have tried it on my local install but the update ran without problems there.
Comment #9
hass commented@eaton: Please add an update hook... :-)
Comment #10
eaton commentedAn additional update hook has been added that re-does the work of the 6101 update, but without the typo.
Please note that the broken update doesn't hurt anything -- your site will continue to work fine, and all data will still be stored properly. The update in question was just creating a couple of specific indexes so that sites with large numbers of votes could retrieve them faster.
Comment #11
dddave commentedThanks!