Hello, there is a small bug which cause failure of module's update :

in voting_api.install, line 293, replace :


  db_drop_index($ret, '{votingapi_vote}', 'content');
  db_drop_index($ret, '{votingapi_vote}', 'content_vtype');

by :


  db_drop_index($ret, 'votingapi_vote', 'content');
  db_drop_index($ret, 'votingapi_vote', 'content_vtype');

CommentFileSizeAuthor
#2 votingapi-501720-1.patch614 bytesmilesgillham
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

mcload’s picture

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)

milesgillham’s picture

FileSize
614 bytes

That diff as a patch.

Cheers,

Miles

eaton’s picture

Status: Active » Fixed

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.

hgmichna’s picture

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?

eaton’s picture

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.

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

AgentD’s picture

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."

AgentD’s picture

Status: Closed (fixed) » Active

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

v2.3 (Drupal 6.14)

Help is greatly appreciated.

Dan

  • eaton committed e186216 on 8.x-3.x
    #501720 - typo in update function prevented two indexes from being...
legolasbo’s picture

Issue summary: View changes
Status: Active » Closed (won't fix)

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.