Difference between revisions of "ResetFileIndexer"

From WebOS Internals
Jump to navigation Jump to search
m (sqlite3 pipe didn't work for me; updated instruction)
 
(One intermediate revision by one other user not shown)
Line 6: Line 6:
  
 
Irritating.
 
Irritating.
 +
 +
(I am: jettero on irc://irc.freenode.net/webos-internals )
  
 
== HOWTO: Reset the File Indexer ==
 
== HOWTO: Reset the File Indexer ==
Line 14: Line 16:
 
# stop fileindexer
 
# stop fileindexer
 
# rsync -vaP mediadb.db3 mediadb.oops.db3
 
# rsync -vaP mediadb.db3 mediadb.oops.db3
# delete from com_palm_media_image | sqlite3 mediadb.db3
+
# sqlite3 mediadb.db3 "delete from com_palm_media_image"
 
# start fileindexer
 
# start fileindexer
  
 
That's it.  Fixed.
 
That's it.  Fixed.

Latest revision as of 18:28, 7 October 2009

What Happened

I recently had a situation where several missing pictures were turning up in my "Photos" app. They were images I had previously deleted, but somehow turned up again days after an update after a reboot. I may never know why and I doubt it'll happen again.

Deleting them in the usual way failed because they weren't actually there, and showing the image would show a silver box in place of the image.

Irritating.

(I am: jettero on irc://irc.freenode.net/webos-internals )

HOWTO: Reset the File Indexer

It's really trivially easy to fix this. However, if this breaks your phone, do not blame me, I don't have any idea what I'm doing.

  1. cd /var/luna/data
  2. stop fileindexer
  3. rsync -vaP mediadb.db3 mediadb.oops.db3
  4. sqlite3 mediadb.db3 "delete from com_palm_media_image"
  5. start fileindexer

That's it. Fixed.