Update failed, bug in voting_api.install
sinasquax - June 25, 2009 - 07:51
| Project: | Voting API |
| Version: | 6.x-2.0 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Description
Hello, there is a small bug which cause failure of module's update :
in voting_api.install, line 293, replace :
<?php
db_drop_index($ret, '{votingapi_vote}', 'content');
db_drop_index($ret, '{votingapi_vote}', 'content_vtype');
?>by :
<?php
db_drop_index($ret, 'votingapi_vote', 'content');
db_drop_index($ret, 'votingapi_vote', 'content_vtype');
?>
#1
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)
#2
That diff as a patch.
Cheers,
Miles
#3
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.
#4
Got the same error:
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?
#5
Yes, there should be no problem with that.
#6
Automatically closed -- issue fixed for 2 weeks with no activity.
#7
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."
#8
Turning to Active. Trying to update modules and keep getting this error.
v2.3 (Drupal 6.14)
Help is greatly appreciated.
Dan