Update failed, bug in voting_api.install

My update failed too. Received this error

The following queries were executed
votingapi module
Update #6101
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content_vtype
ALTER TABLE {votingapi_vote} ADD INDEX content_uid_2 (content_type, uid)

That diff as a patch.

Cheers,

Miles

Checked into the dev release. thanks!

I won't be releasing a new version for this just yet, as it's a relatively minor issue in the last update, but this will be rolled into the 2.1 version when it comes out.

Got the same error:

Drupal database update

user warning: Table 'winhlp.w_w_votingapi_vote' doesn't exist
query: ALTER TABLE w_w_votingapi_vote DROP INDEX content in /srv/www/vhosts/winhlp.com/httpdocs/includes/database.mysql-common.inc on line 448.

user warning: Table 'winhlp.w_w_votingapi_vote' doesn't exist
query: ALTER TABLE w_w_votingapi_vote DROP INDEX content_vtype in /srv/www/vhosts/winhlp.com/httpdocs/includes/database.mysql-common.inc on line 448.

Updates were attempted. [...]

The following queries were executed
votingapi module
Update #6101
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content
Failed: ALTER TABLE {{votingapi_vote}} DROP INDEX content_vtype
ALTER TABLE {votingapi_vote} ADD INDEX content_uid_2 (content_type, uid)

I corrected the two SQL statements and ran them manually.

I guess I'm not the only one who did that. Will you be able to drop the two indices in the next version without showing an error if the indices have already been dropped?

I guess I'm not the only one who did that. Will you be able to drop the two indices in the next version without showing an error if the indices have already been dropped?

Yes, there should be no problem with that.

I'm getting this in v2.3 (Drupal 6.14). It looks like the fix above isn't for 2.3, in looking at the .install file the lines appear corrected.

error: "The update process was aborted prematurely while running update #6101 in votingapi.module."

Turning to Active. Trying to update modules and keep getting this error.

v2.3 (Drupal 6.14)

Help is greatly appreciated.

Dan

Drupal 6 is no longer supported. Closing old issues to clean up the issue queue.

Please reopen and update this issue if this is still an issue in the D7 or D8 version.