Thread:Semantic-mediawiki.org:Community portal/SMWSQLStore2 / 3 after upgrade to SMW 1.8

Hello,

After upgrading to SMW 1.8 (with Mediawiki 1.19.1), I have an issue with SMWSQLStore setup.

I ran both the database upgrade and then refresh ("Start Updating Data" from SMWAdmin page). I believe this should be sufficient to migrate from SMWSQLStore2 to SMWSQLStore3--"Start updating Data" took about 2 days, so I thought it was performing the migration.

However, once I remove the "$smwgDefaultStore = 'SMWSQLStore2';" from my localsettings.php, when I try to save any page, I get the following error: Somebody tried to use spaces in a cache title! (Assigned to) Backtrace:
 * 1) 0 /.../extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_Sql3SmwIds.php(302): SMWSql3SmwIds->setCache('Assigned to', 102, , , 0, '')
 * 2) 1 /.../extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_Sql3SmwIds.php(225): SMWSql3SmwIds->getDatabaseIdAndSort('Assigned to', 102, , , '', true, false)
 * 3) 2 /.../extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_Sql3SmwIds.php(327): SMWSql3SmwIds->getSMWPageIDandSort('Assigned to', 102, , , '', true, false)
 * 4) 3 /.../extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3_Readers.php(166): SMWSql3SmwIds->getSMWPageID('Assigned to', 102, , , true)
 * 5) 4 /.../extensions/SemanticMediaWiki/includes/storage/SQLStore/SMW_SQLStore3.php(298): SMWSQLStore3Readers->getPropertyValues(Object(SMWDIWikiPage), Object(SMWDIProperty), NULL)
 * 6) 5 /.../extensions/SemanticMediaWiki/includes/dataitems/SMW_DI_Property.php(203): SMWSQLStore3->getPropertyValues(Object(SMWDIWikiPage), Object(SMWDIProperty))
 * 7) 6 /.../extensions/SemanticMediaWiki/includes/storage/SMW_PrintRequest.php(155): SMWDIProperty->findPropertyTypeID
 * 8) 7 /.../extensions/SemanticMaps/includes/SM_GeoCoordsHooks.php(46): SMWPrintRequest->getTypeID
 * 9) 8 [internal function]: SMGeoCoordsHooks::addGeoCoordsDefaultFormat(false, Array, Array)
 * 10) 9 /.../includes/Hooks.php(216): call_user_func_array('SMGeoCoordsHook...', Array)
 * 11) 10 /.../includes/GlobalFunctions.php(3847): Hooks::run('SMWResultFormat', Array)
 * 12) 11 /.../extensions/SemanticMediaWiki/includes/params/SMW_ParamFormat.php(101): wfRunHooks('SMWResultFormat', Array)
 * 13) 12 /.../extensions/SemanticMediaWiki/includes/params/SMW_ParamFormat.php(48): SMWParamFormat->getDefaultFormat
 * 14) 13 /.../extensions/SemanticMediaWiki/includes/params/SMW_ParamFormat.php(140): SMWParamFormat->getValidFormatName('auto')
 * 15) 14 /.../extensions/Validator/includes/definitions/ParamDefinition.php(719): SMWParamFormat->formatValue('auto', Object(Param), Array, Array)
 * 16) 15 /.../extensions/Validator/includes/Param.php(213): ParamDefinition->format(Object(Param), Array, Array)
 * 17) 16 /.../extensions/Validator/includes/Validator.php(341): Param->format(Array, Array, Object(ValidatorOptions))
 * 18) 17 /.../extensions/Validator/includes/Validator.php(281): Validator->doParamProcessing
 * 19) 18 /.../extensions/SemanticMediaWiki/includes/SMW_QueryProcessor.php(59): Validator->validateParameters
 * 20) 19 /.../extensions/SemanticTasks/SemanticTasks.classes.php(356): SMWQueryProcessor::getProcessedParams(Array, Array)
 * 21) 20 /.../extensions/SemanticTasks/SemanticTasks.classes.php(135): SemanticTasksMailer::getQueryResults('Main Page[[...', Array, false)
 * 22) 21 /.../extensions/SemanticTasks/SemanticTasks.classes.php(31): SemanticTasksMailer::getAssignees('Assigned to', 'Main Page', Object(User))
 * 23) 22 [internal function]: SemanticTasksMailer::findOldValues(Object(WikiPage), Object(User), PLEASE NOTE ...', '', 0, NULL, NULL, 98, Object(Status))
 * 24) 23 /.../includes/Hooks.php(216): call_user_func_array('SemanticTasksMa...', Array)
 * 25) 24 /.../includes/GlobalFunctions.php(3847): Hooks::run('ArticleSave', Array)
 * 26) 25 /.../includes/WikiPage.php(1263): wfRunHooks('ArticleSave', Array)
 * 27) 26 [internal function]: WikiPage->doEdit(PLEASE NOTE ...', '', 98)
 * 28) 27 /.../includes/Article.php(1783): call_user_func_array(Array, Array)
 * 29) 28 /.../includes/EditPage.php(1435): Article->__call('doEdit', Array)
 * 30) 29 /.../includes/EditPage.php(1435): Article->doEdit(PLEASE NOTE ...', '', 98)
 * 31) 30 /.../includes/EditPage.php(960): EditPage->internalAttemptSave(Array, false)
 * 32) 31 /.../includes/EditPage.php(357): EditPage->attemptSave
 * 33) 32 /.../includes/actions/EditAction.php(51): EditPage->edit
 * 34) 33 /.../includes/actions/EditAction.php(71): EditAction->show
 * 35) 34 /.../includes/Wiki.php(484): SubmitAction->show
 * 36) 35 /.../includes/Wiki.php(278): MediaWiki->performAction(Object(Article))
 * 37) 36 /.../includes/Wiki.php(593): MediaWiki->performRequest
 * 38) 37 /.../includes/Wiki.php(503): MediaWiki->main
 * 39) 38 /.../index.php(58): MediaWiki->run
 * 40) 39 {main}