Last modified: 2008-03-14 01:44:42 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
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