Page MenuHomePhabricator

MySQL Error
Closed, ResolvedPublic

Description

Author: dasch

Description:
The Symantic Drilldown does not work in any way, I've tried nearly everything, but I'm always getting an MySQL Error (http://www.wecowi.net/view/Spezial:BrowseData) can not figure out where this comes from, but it must be a heavy Problem when there is no useable Error produced

Fehler in der Datenbank
Es gab einen Syntaxfehler in der Datenbankabfrage. Die letzte Datenbankabfrage lautete:

(SQL-Abfrage versteckt)

aus der Funktion „“. MySQL meldete den Fehler „1044: Access denied for user 'web406'@'localhost' to database 'usr_web406_1' (localhost)“.


Version: unspecified
Severity: normal

Details

Reference
bz13352

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:07 PM
bzimport set Reference to bz13352.
bzimport added a subscriber: Unknown Object (MLST).

dasch wrote:

the error ocurres with this Query

CREATE INDEX page_id_index ON semantic_drilldown_values (page_id)

overlordq wrote:

No useable error produced? I'd personally call:

"Access denied"

perfectly informative. Means your config has a wrong username or password.

Somebody feel free to correct/close this if I'm wrong/right/or something.

dasch wrote:

yes sure, but my Wiki Works Fine, only if calling Special:BrowseData there is this acess denied error!

dasch wrote:

it must be something about the CREATE INDEX, when looking through the hole MediaWiki Code an the Code of many extensions there is no other place this CREATE INDEX is used, maybe there is a alternative for CREATE INDEX

dasch wrote:

simple workaround
change
CREATE INDEX page_id_index ON semantic_drilldown_values (page_id)
to
ALTER TABLE semantic_drilldown_values ADD INDEX page_id_index (page_id)