auouymous | # 181 | 2011-11-01, 04:30 | Report

apt-get remove gstreamer0.10-plugins-good gstreamer0.10-plugins-extra

Addison | # 182 | 2011-11-01, 04:37 | Report

Thanks!

And this one?

dpkg -i gstreamer0.10-plugins-extra_0.10.6-0osso22-2_armel.deb

auouymous | # 183 | 2011-11-01, 04:40 | Report

You should never blindly type commands given by someone over the internet as they could wipe out all of your data. Read the text I typed, very carefully.

Addison | # 184 | 2011-11-01, 04:48 | Report

Sorry.

I just now caught the space removing both of them.

By the way, the one minute notifications that you helped me with rocks.

My tablet lights up immediately after you post in this thread.

Sorry. I tend to get easily excited over little things.

auouymous | # 185 | 2011-11-01, 05:22 | Report

So who knows how to repair a corrupted maemopad+ database? I got hit by the wifi drain bug last night and memos.db didn't survive the dead battery shutdown. The file size is about what it should be based on the previous backup and I can see most of the text in the file but sqlite3 only sees 2% of the memos.

Really hoping there is another way to put humpty-dumpty back together again.

Addison | # 186 | 2011-11-01, 05:24 | Report

Can I just upload that file for you from my tablet?

auouymous | # 187 | 2011-11-01, 05:27 | Report

It contains all the text I typed in maemopad+. It would be wonderful if the trojan you installed on my tablet was sending you daily updates of that file. I won't even be mad at you if you could send it back to me.

Addison | # 188 | 2011-11-01, 05:33 | Report

Can you use Vim or a Hex editor on your computer to see how much is still there?

And you probably got that trojan virus by looking at porn.

At least that's where I get all of mine.

lma | # 189 | 2011-11-01, 08:27 | Report

Never used it, but according to its garage page the db is sqlite3. Can the sqlite3(1) tool open it on the command line? (that doesn't seem to be readily available for Diablo, you'll have to run it on a PC I guess). Try something like "echo .dump | sqlite3 broken.db | sqlite3 recovered.db".

If all else fails you might at least be able to extract most of the text with strings(1)...

---

Last edited by lma; 2011-11-01 at 08:32.

auouymous | # 190 | 2011-11-02, 05:48 | Report

As mentioned in my post, sqlite3 is only able to read 2% of the file. I know how to extract the strings but sqlite splits individual memos into multiple blocks and spreads them out over the file. This makes it very difficult to find the entire contents of specific memos.

I was hoping there is a tool that understands sqlite format and could repair the bad section so I can extract more than 2%.