Last modified: 2013-02-26 23:06:57 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 T47365, 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 45365 - rename_upc_index.sql has syntax error
rename_upc_index.sql has syntax error
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
EducationProgram (Other open bugs)
master
All All
: Unprioritized normal (vote)
: ---
Assigned To: Jeroen De Dauw
:
: 45400 (view as bug list)
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2013-02-25 17:56 UTC by Antoine "hashar" Musso (WMF)
Modified: 2013-02-26 23:06 UTC (History)
3 users (show)

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

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

Description Antoine "hashar" Musso (WMF) 2013-02-25 17:56:25 UTC 
catched on the beta cluster:


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( /data/project/apache/common-local/php-master/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 MySQL server version for the right syntax to use near 'IF EXISTS ep_users_per_course' at line 1 (10.4.0.53)"
Comment 1 Sam Reed (reedy) 2013-02-26 07:12:55 UTC 
*** Bug 45400 has been marked as a duplicate of this bug. ***
Comment 2 Jeroen De Dauw 2013-02-26 16:51:46 UTC 
https://gerrit.wikimedia.org/r/#/c/50912/
Comment 3 Antoine "hashar" Musso (WMF) 2013-02-26 22:59:11 UTC 
follow up in https://gerrit.wikimedia.org/r/51052
Comment 4 Antoine "hashar" Musso (WMF) 2013-02-26 23:06:57 UTC 
That fixed it up. Thank you Jeroen for the quick fix!
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