Last modified: 2008-07-06 18:51:13 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 T16543, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 14543 - SQL Error on Type Namespace
SQL Error on Type Namespace
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
Semantic MediaWiki (Other open bugs)
unspecified
All All
: High critical (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  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: ---


Attachments

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

http://www.wecowi.com/view/Datentyp:Zahl

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.


Navigation
Links