Page MenuHomePhabricator

rename_upc_index.sql doesn't work for MySQL
Closed, ResolvedPublic

Description

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


Version: master
Severity: normal

Details

Reference
bz45400

Event Timeline

bzimport raised the priority of this task from to Needs Triage.Nov 22 2014, 1:25 AM
bzimport set Reference to bz45400.
bzimport added a subscriber: Unknown Object (MLST).

It needs to be:

DROP INDEX /*i*/ep_users_per_course ON /*_*/mw_ep_users_per_course;

  • This bug has been marked as a duplicate of bug 45365 ***