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

bzimport added a subscriber: Unknown Object (MLST).
bzimport set Reference to bz13352.
bzimport created this task.Via LegacyMar 14 2008, 12:19 AM
bzimport added a comment.Via ConduitMar 14 2008, 12:52 AM

dasch wrote:

the error ocurres with this Query

CREATE INDEX page_id_index ON semantic_drilldown_values (page_id)

bzimport added a comment.Via ConduitMar 14 2008, 1:01 AM

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.

bzimport added a comment.Via ConduitMar 14 2008, 1:05 AM

dasch wrote:

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

bzimport added a comment.Via ConduitMar 14 2008, 1:39 AM

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

bzimport added a comment.Via ConduitMar 14 2008, 1:44 AM

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)

Add Comment