https://bugzilla.wikimedia.org/show_bug.cgi?id=45400
Web browser: ---
Bug ID: 45400
Summary: MySQL doesn't support IF EXISTS in DROP INDEX
Product: MediaWiki extensions
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: EducationProgram
Assignee: [email protected]
Reporter: [email protected]
CC: [email protected],
[email protected]
Classification: Unclassified
Mobile Platform: ---
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)"
--
You are receiving this mail because:
You are on the CC list for the bug.
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
