https://bugzilla.wikimedia.org/show_bug.cgi?id=43694

--- Comment #10 from Andreas Plank <[email protected]> ---
Created attachment 11634
  --> https://bugzilla.wikimedia.org/attachment.cgi?id=11634&action=edit
table structure of account_credentials account_requests (MW 1.18) before MW
1.20.2-upgrade

(In reply to comment #9)
> Database returned error "1091: Can't DROP 'acr_deleted_reg'; check that
> column/key exists (localhost)" one.

I work on the same data base: the index 'acr_deleted_reg' does not exist in our
DB to be dropped. I don't know what the patch-account_credentials.sql is
intended to DROP for what ConfirmAccount-Version by the SQL:
---
ALTER TABLE /*$wgDBprefix*/account_requests
  ADD acr_type tinyint(255) unsigned NOT NULL default 0,
  DROP INDEX acr_deleted_reg,
  ADD INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration);
---

So I attach our table structure we had to upgrade. I did this manually and now
the upgrade (php ./maintenance/update.php --quick --conf ./LocalSettings.php)
works, but this manual repair is not a general solution

Andreas

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to