Last modified: 2013-02-26 07:12:55 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T47400, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 45400 - rename_upc_index.sql doesn't work for MySQL
rename_upc_index.sql doesn't work for MySQL
Status: RESOLVED DUPLICATE of bug 45365
Product: MediaWiki extensions
Classification: Unclassified
EducationProgram (Other open bugs)
master
All All
: Unprioritized normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2013-02-25 23:48 UTC by Sam Reed (reedy)
Modified: 2013-02-26 07:12 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Sam Reed (reedy) 2013-02-25 23:48:34 UTC 
https://dev.mysql.com/doc/refman/5.0/en/drop-index.html

Renaming index ep_users_per_course into ep_upc_user_courseid_role to table ep_users_per_course ...A database query syntax error has occurred.
The last attempted database query was:
"DROP INDEX IF EXISTS ep_users_per_course
"
from within function "DatabaseBase::sourceFile( /var/www/wiki/mediawiki/extensions/EducationProgram/sql/rename_upc_index.sql )".
Database returned error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'IF EXISTS ep_users_per_course' at line 1 (192.168.0.212)"
Comment 1 Sam Reed (reedy) 2013-02-25 23:51:05 UTC 
It needs to be:

DROP INDEX /*i*/ep_users_per_course ON /*_*/mw_ep_users_per_course;
Comment 2 Sam Reed (reedy) 2013-02-26 07:12:55 UTC 

*** This bug has been marked as a duplicate of bug 45365 ***
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links