Property talk:Pledge

Database failure with property type 'record'

If this property is defined as [[has type::record]] and [[has fields::string; text]], then setting <wiki>xxx; yyy</wiki> results in the following error:

A database error has occurred
Query: INSERT INTO smw_ids (smw_id,smw_title,smw_namespace,smw_iw) VALUES ('732','','726',':smw')
Function: SMW::makeSMWBnodeID
Error: 1 ERROR: null value in column "smw_sortkey" violates not-null constraint

Backtrace:

#0 /var/www/localhost/htdocs/mediawiki/includes/db/Database.php(538): DatabasePostgres->reportQueryError('ERROR: null va...', 1, 'INSERT INTO smw...', 'SMW::makeSMWBno...', '')
#1 /var/www/localhost/htdocs/mediawiki/includes/db/DatabasePostgres.php(850): DatabaseBase->query('INSERT INTO smw...', 'SMW::makeSMWBno...', '')
#2 /var/www/localhost/htdocs/mediawiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(2172): DatabasePostgres->insert('smw_ids', Array, 'SMW::makeSMWBno...')
#3 /var/www/localhost/htdocs/mediawiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(855): SMWSQLStore2->makeSMWBnodeID('726')
#4 /var/www/localhost/htdocs/mediawiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(885): SMWSQLStore2->prepareDBUpdates(Array, Object(SMWSemanticData), '726')
#5 /var/www/localhost/htdocs/mediawiki/extensions/SemanticMediaWiki/includes/storage/SMW_SQLStore2.php(783): SMWSQLStore2->prepareDBUpdates(Array, Object(SMWSemanticData), '726')
#6 /var/www/localhost/htdocs/mediawiki/extensions/SemanticMediaWiki/includes/SMW_ParseData.php(252): SMWSQLStore2->updateData(Object(SMWSemanticData))

etc

SMW 1.5.5, MW 1.16.1, PostgreSQL 8.4.5. ~Mike-ZeleaCom^talk 23:34, 2 May 2011 (EDT)

• It also occurs with [[has fields::Page; String]]. ~Mike-ZeleaCom^talk 19:54, 14 July 2011 (EDT)