Last modified: 2008-07-06 18:51:13 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)“
sry, I've forgotten to say, I use 1.2f-SVN
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
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
need any further information?
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
Commenting out the following in SMW_SQLStore.php, line 412 seems to help: ,'subject_title'
This was due to some change in DB layout and has been fixed now (in all SMW storage implementations).