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:
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
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).