My wife recently got a new phone number and the old one ceased to function. Now, whenever she sends me an SMS, they are not grouped to the same conversation as the previous messages. Furthermore, if I delete the old phone number from her phonebook entry, the old messages are visible only with the old phone number.

Is there any way to merge these conversations together, or somehow make the N900 to understand that I don't care what number the SMS came from, just that they came from one specific contact?

I probably could do sqlite3 el-v1.db and say UPDATE Events set uid=newnumber where uid=oldnumber (or something like that), but is there a more elegant solution or app?

Thanks.

Yes, you can update the database as you suggest. You would also want to merge the group cache as well, as this is what is used to show the latest event. you may even be able to get away with editing the group_id of the old events.

Personally, in this situation I leave the old number on the contact and add the new one. Yes they appear twice in the conversations...but usually it gets pushed off the bottom fairly quickly as more people communicate with me. the only downside is that the N900 doesn't show which is the "default" number. Something I plan on fixing if I ever get around to replacing that UI.