Last modified: 2008-03-14 01:44:42 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 T15352, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 13352 - MySQL Error
MySQL Error
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
SemanticDrilldown (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2008-03-14 00:19 UTC by DaSch
Modified: 2008-03-14 01:44 UTC (History)
1 user (show)

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


Attachments

Description DaSch 2008-03-14 00:19:25 UTC
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)“.
Comment 1 DaSch 2008-03-14 00:52:35 UTC
the error ocurres with this Query

CREATE INDEX page_id_index ON semantic_drilldown_values (page_id)
Comment 2 OverlordQ 2008-03-14 01:01:42 UTC
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.
Comment 3 DaSch 2008-03-14 01:05:33 UTC
yes sure, but my Wiki Works Fine, only if calling Special:BrowseData there is this acess denied error!
Comment 4 DaSch 2008-03-14 01:39:29 UTC
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
Comment 5 DaSch 2008-03-14 01:44:42 UTC
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)

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links