Last modified: 2008-07-06 18:51:13 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 14543 - SQL Error on Type Namespace
SQL Error on Type Namespace
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
All All
: High critical (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2008-06-14 21:29 UTC by DaSch
Modified: 2008-07-06 18:51 UTC (History)
2 users (show)

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


Description DaSch 2008-06-14 21:29:17 UTC
When entering a page from the Type Namespace I get this MySQL Error

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

    (SQL-Abfrage versteckt)

aus der Funktion „SMW::getSpecialSubjects“. MySQL meldete den Fehler „1054: Unknown column 'subject_title' in 'order clause' (localhost)“
Comment 1 DaSch 2008-06-14 21:32:48 UTC
sry, I've forgotten to say, I use 1.2f-SVN
Comment 2 DaSch 2008-06-16 12:15:42 UTC
SMW::getSpecialSubjects	localhost	1054	Unknown column 'subject_title' in 'order clause' (localhost)	 SELECT  DISTINCT subject_id  FROM `smw_specialprops`  WHERE property_id='1' AND value_string='_dat'  ORDER BY subject_title LIMIT 201  

this is the SQL that fails
Comment 3 DaSch 2008-06-18 20:06:25 UTC
This is somehow strange, even the standard typs can not be viewed

and even types that does not exist can not be viewed
Comment 4 DaSch 2008-06-23 22:41:56 UTC
need any further information?
Comment 5 DaSch 2008-06-25 13:24:33 UTC
the error only ocures when trying to view a Typ, when going directly to the edit page it work, editing and saving also works the changes are saved right
Comment 6 Joshua C. Lerner 2008-06-29 17:14:03 UTC
Commenting out the following in SMW_SQLStore.php, line 412 seems to help: ,'subject_title'
Comment 7 Markus Krötzsch 2008-07-06 18:51:13 UTC
This was due to some change in DB layout and has been fixed now (in all SMW storage implementations).

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