SOLVED: anybody else having sqlite issues? - Nokia 6.2 Questions & Answers

I just bought a 6.2. Ridiculously huge phone. I have trouble believing this is now considered a small phone. The huge screen is a plus while I'm stuck at home. It'll get annoying quick once we get back out into the world.
There seems to be something wrong with sqlite on the phone. F-Droid repeatedly crashes with a grab bag of sqlite errors - "file is not a database." "Loc header is corrupted." - going from memory here, because most of the time the message flashes by on the way to the "Would you like to e-mail the details to help fix the issue?" screen. Everytime OI Shopping List starts up, it thinks it's being started for the first time and goes through the "choose your preferred layout setup." Any created shopping lists are gone. The default one is empty. I can't say for sure this is the same problem, but it seems related.
Does anybody know of an app to stress-test sqlite creation on the phone? Or, even better - how to fix this?
Follow-up. Sqlite errors in Aldiko, too. Setup from first install is gone. After putting all my info back in, I attempted to download a book from the library and got "Import failed [file is not a databse (code 26 SQLITE_NOTADB)]" - one of the same errrors that F-Droid gives. Something is very wrong with this phone.

No help on the internet beyond some applications showing the same behavior, all solved years ago.
Nokia support did not find the problem, and after a soft reset and factory reset, told me to send the phone in for repair. "Two week turnaround, just go to this website, fill out your details, print out the paper, tape it to your phone and bring it to the nearest Fedex office. No cost to you!"
However, on the setup after the factory reset, there was a message about my SD card being too slow and could cause problems being used as a phone storage device. The message was not there during the original setup. It's a Samsung SDXC 1. Not that old, or slow, but removing it solved the problem. Maybe my previous phone corrupted it as a parting shot.

Related

WM6 stuck syncing and so on

Ok, I know I gotta PM mods here but I thought I'd make another topic about it since there might be more ppl out there knowing how to fix my problem. Feel free to delete it, or tell me to remove the topic and I'll pm any of you one by one, as you desire.
My Windows Mobile went crazy. Its a known bug but I just can't seem to fix it.
Already made another topic about it, since it occurs to a lot of ppl using the HTC Touch Diamond, but it might be a common Windows error, and not just to ppl using the listed device.
The symptoms:
- Access is denied error message when trying to copy files to the phone using ActiveSync.
- Access is denied error message when trying to delete any files or copy files between folders and/or the storage card on the phone.
- You do not have permission to download that type of file in Internet Explorer when trying to download any files.
- No programs show up in Remove Programs.
- Installation Unsuccessful error messages when trying to install any applications.
- ActiveSync will fail with an error message that you should start the troubleshooter.
And the solution:
Code:
- Please follow the exact steps listed below.
- Soft Reset is done with the stylus, if you press it in the little round hole that is next to the USB port of HTC touch (the other oval hole at the other side of the USB port is the microphone. Do not stick your stylus in that hole)
- Power off is done when you keep the power button (on the top) pressed and you see a message from windows, asking if you want to power off your device.
The procedure to fix and recover from this amazing bug.
1) soft reset device
2) Start / Office Mobile / Word
3) Create a new document (click on New)
4) type some text (just plain text - no formatting - it was 'plain text document') just a few characters
5) File / Save As...
6) I have selected type 'Plain Text'
7) It asked me whether I want to save it at 'Word document instead' - I clicked No.
8) I have powered off the device and did soft reset
9) Start file explorer, find the file (it was in My Device / My Documents), click on it - it opens Word again.
10) Add some formatting (I have selected part of text and changed font to bold)
11) Close Word - it asked whether to save it in Word format - this time I said Yes
12) Power-off the device and press soft reset again
Now you can find this anywhere on the map, with a lil bit of google skills, however .. its just not working for me. I did the exact things listed, and even changed some small parts of it during the 10 times I tried. And yet my problems aren't solved. I'm wondering, quite desperately, if theres anyone out there that might actual know what could have caused it or fixes it. I'm sooo not looking into a format/reinstall.
Thanks in advance
is active sync giving you an error code (a number)
Thank you for your fast response. Sync isn't giving an error code or number. Baiscally what the error messages tells me is, free translated:
"Synchronization cannot be completed successfully. Reconnect your device and try again. If the problem persists, see the Microsoft ActiveSync troubleshooter in Microsoft ActiveSync help on your desktop computer"
but in Dutch. All it leaves me to do is press OK and start a sync checkup, which doesn't find anything but the usual Outlook "problem" (I don't have it installed, nor do I wan't to sync email with it).
joel got an idea ?
Waited half a day, plox joel, if you got any idea help me out. I'm afraid I gotta hard-reset, but I wanna avoid it. Any help is welcome ...
No clue?
I'd like to bump this once more, since theres been some interest in it but now it's just forgotten
honestly, the best way to solve these types of problems is a hard reset.
the time you spend in here / searching in google / trying stuff is much longer than what you'd spend hard reseting and installing stuff.
i also suggest you get a system backup app so you won't have to reinstall and copy and sync every time you need to hard reset.
I know thats the easy solution, and I will hard reset my device, but only ONCE I got my photos contacts and texts off it. Especially the photo's are quite important to me.

Replaced SIM Card -- Now Can't Log In!

I really hope someone can help me with this, because I'm going crazy.
This will require a little history, so bear with me. A couple of weeks ago, I lost my Fuze. Last week, I bought a cheap (prepaid) AT&T GoPhone and called AT&T to have my number transferred to it. I used that phone successfully for several days, until this morning, when my lost phone showed up!
I was ecstatic, thinking that now I'd finally be able to sleep again p), but my excitement changed to disappointment after spending 30 or 40 minutes on the phone with AT&T, explaining my situation over and over to get them to understand what I needed, then following their instructions, and finding that my phone wouldn't work.
They informed me that my old SIM card had been disabled and was therefore useless, and suggested that I put the card from my GoPhone in my Fuze. I did so, but when I then turned the phone on, I got this message:
*****
Owner: Keith Russell
(xxx) xxx-xxxx
Enter your password and tap "Unlock". You can also enter an emergency phone number.
*****
My phone has been passworded in the past, but not recently, because I was trying to resolve some problems and was doing a lot of soft resets and didn't want to have to deal with the logon security. On the other hand, I'm pretty sure the message I was seeing was one I had never seen before. Nevertheless, I tried all the passwords I could think of that I had used on the phone in the past, but none of them worked. Every time, I got this message:
The password you typed is incorrect.
I called AT&T again, and this time spent over an hour on the phone with an AT&T rep and later, an HTC rep. We tried several default passwords, which also didn't work, and the HTC rep finally had me do a hard reset.
I installed my registered version of Sprite Backup 6.5 and restored my most recent good backup. The restore was successful and the application did a soft reset when it was done. Things seemed to be working fine and I spent a couple of hours cleaning up duplicate or large notes to free up memory. I also emptied the recycle bin in Resco Explorer. I then did a soft reset, thinking that might help with the cleanup.
Believe it or not, when the soft reset completed, I got the unlock prompt again!
So I'm stuck. I'm hesitant to do yet another hard reset and restore, because I expect that the same thing would happen again, eventually. I'm also not very excited about calling AT&T Support, because they didn't seem to know any more than I did about this problem.
I have no idea where this unlock prompt is coming from: whether it's hardware, firmware, OS, or application specific. I do have Pocket Secure installed and it's possible that that's what causing it; I just don't know.
Can anyone tell me what's causing this and how I can get around it?
Thanks very, very much for any suggestions you can provide.
u cant do a full restore with sprite as what ever it has that makes the prompt will come back, do custom dont add anything but your contacts and messages.

Unable to Boot error, but device works!

Greetings people!
Yesterday I got this message while booting up my TP (latest official ROM):
"The device is unable to boot because either you have turned off the device incorrectly or tried to install an application from untrusted source. Press END to reset your device or press any other button to cancel. This operation will delete all your personal data and restore the device to its factory default settings"
However apart from that message, phone works flawlessly without any noticable change in speed or stability! The only apparent problem is that it takes a while longer (about 10 seconds) to boot up because of that message. I tried a couple of backups, problem was solved at first, but returned later...
I do take daily backups, but since I hardly monitor my phone when I reset it, this problem could have been caused by an app or reg entry a while ago... and searching for the appropriate backup will be a pain in the ass.
Since there's no change in speed or stability, do you think it would be wise to keep using the phone as is, or is it possible this would cause further problems down the road?
Any other way to troubleshoot it (at least to find the program that's causing this) other than a hard reset?
Edit: couldn't wait so I reverted to a week-old backup, installed back most of my applications, and it seems to be fixed (for now)
Update! I just tried a new SD to try XDAndroid, and guess what, the error disappeared!
So there must be a program I had installed in the storage card, possibly trying to start a service or something on every reset... and failing.
Is there a way to troubleshoot this? Maybe through SKTools or anything similar? I have a ton of apps installed into storage card and it will be a pain in the back cover to try by trial-and-error.
Thank you in advance
edit: inserted my old storage card again, error did not appear, problem solved! At least for now
Still if anyone knows how to troubleshoot this, please let me know
Update: Seems this error occurs every time I use SPB backup.
Yesterday, after a scheduled backup, the error came back. To troubleshoot this, I removed the SD card, did a soft reset, the error was gone! I took another manual backup, and again, the error came back.
So there must be something happening with SPB Backup and my SD card. Probably messing with files on the SD, or the driver or whatever (no idea there, I'm a total noob when it comes to software).
Moved the issue to the SPB forum
I have this message to, but I have never used SPB Backup
Well, in my case, it was obviously something tampering with the SD card (even if not SPB backup, something else)
Have you tried rebooting your phone with the SD card taken off? I just wait till it boots normally, and then insert it back. Works for me every time.
If that still happens, that probably means whatever is causing the problem is in your main memory.
akpidis said:
Well, in my case, it was obviously something tampering with the SD card (even if not SPB backup, something else)
Have you tried rebooting your phone with the SD card taken off? I just wait till it boots normally, and then insert it back. Works for me every time.
If that still happens, that probably means whatever is causing the problem is in your main memory.
Click to expand...
Click to collapse
Well I tried that just to see what would happen and I did not get the error message. So it is something on the SD card, but booting without it is not an option for me as I have several boot-start apps that are housed on it.
Perhaps one of those apps is broken?
As far as my case goes, I kept on using it for three months after the error appeared, without noticing any lag or issues at all. The only downside was that it took me three minutes to boot up, something I got used to.
If that's no big deal for you, I'd suggest you just leave it as it is for now, and check for lagging or specific applications failing (maybe one of them will be the app that's causing the problem?). If nothing happens down the road I think it could be safe to leave it as it is.
Now, if you can't stand this, I guess the only practical solution would be a hard reset. You can always play around with removing/reinstalling those apps you mention (or even better, installing them in the phone's memory) to check if and which one is broken, but I can understand that this not only will be a huge burden, but you may come to the conclusion that no specific app is causing this and something went south in the OS.
Personally the only apps which include a boot-up service I have installed into my SD are Football Monitor and PocketWeather. I tried removing both of them them back when I first had that issue, it didn't work...
Sorry I couldn't help more :/

[Q] error with ACORE Droid Proccess

This is my first post. I am not a programer, well not for 30 years and not since my backups were on a tape, but am fairly good at fixing my own issues with the help of this site, which much of is way over my head. I have don't everything in every thread that I can find here and have some more information that might help everyone figure out this issue.
Phone is a non-rooted EVO 4G lte. Screen captures below should give you all the specifics that you need. If you need more info, please email me!
I get a break from error after I delete contact info/cache from both Contact Storage and People (contacts) apps.
I started having the problem a few days ago and the last three things I installed were:
Adobe Flash (got it from this site and have now disabled and would like to totally remove if any of you know how to do that. There is not option in the settings/apps/adobe to uninstall, just disable.
Skype which I have removed.
2012/3 Live Wall Paper, also removed
I have reset the phone, unmounted and remounted the SD card, moved programs that use contacts from SD card back to phone storage and as I said removed all contacts, disabled Smooth sync for the cloud and the JB workaround and still after all most of the contacts are resynced form Google, the error starts to appear. It doesn't lock up my phone, but occasionally crashes app that I am working in. ROYAL PAIN.
So in short, 1. How can I totally get rid of Flash?
2. Is there someway to do a repair on my contact database without rooting phone
3. There is java mentioned in the error message, I didn't think Droid used java (see how little I really know, so be nice) is there a way to update that service?
4. Other than a hard reset AGAIN, what can I do! (Or after all this would that work this time? I hate going to all that effort and still have same issues) Is there a way to force a reinstall of JB?
I realize that I know just enough to be dangerous, but can follow detailed direction to fix this. I go through way too many phone to root my current phone and take the chance that Sprint wouldn't replace it. I never have a phone last more than a year! And the last quarter of of 2012 I went through 5 phones. Galaxy Nexus didn't like me!
Thanks for the great site and in advance for taking the time to read all of this.
More Info
I have also been deactivating Facebook and that wasn't helping, but many people were saying that was an issue.
Those of us that just started having this issue think it might be a date issue. Is here anything that could do this if someone's b'day is the 29th of February?
I have one of those people and that seems like a strange issue, but heck, humans programs this stuff so I guess anything is possible! It makes sense that a value in a contact field is causing the issue, but a date that only exists every 4 years?
I have not had the error since i fixed this, BUT only about 500 of my 2,500 contacts are installed and I have yet to re enable facebook.
Thanks again!
Pat

Whatsapp backup restoring

I'm actually in a very serious problem as I have a problem with restoring my whatsapp messages please help me asap I uninstalled my whatsapp on 16th July and last I backed up it on 7th July. Now when I try to restore the messages after reinstalling it shows my google account but it doesn't show the size of backup and also it says no Internet connection please help me. Also my whatsapp images and whatsapp videos folders have disappeared. I really want to get back my chats. Hope someone will really help me as it means alot to me now
Connect to a wifi or a hotspot, or get better signal then H+
Kenora_I said:
Connect to a wifi or a hotspot, or get better signal then H+
Click to expand...
Click to collapse
I'm already using WiFi and I tried using mobile data as well both didn't help and I tried reseting network settings and all still it didn't work out
ruinaaaa said:
I'm already using WiFi and I tried using mobile data as well both didn't help and I tried reseting network settings and all still it didn't work out
Click to expand...
Click to collapse
Did you check your google account the backup.
It could be app problem, try resetting and other stuff.
Kenora_I said:
Did you check your google account the backup.
It could be app problem, try resetting and other stuff.
Click to expand...
Click to collapse
Hey yes I checked it as well in google drive it shows the backup I can't restore it locally because I deleted the whatsapp databases like or two months ago will it affect this
Try clearing the data and cache of whatsapp or reinstall it.
Kenora_I said:
Try clearing the data and cache of whatsapp or reinstall it.
Click to expand...
Click to collapse
I tried this too and tried so many things.I watched so many youtube videos and searched a lot in google as well still couldn't find any possible way to recover
Albert83BCN said:
Hi guys!
I have been facing this issue this whole week while trying to move all my chats to a new phone I just bought as with the old one the charging port was dying and I could not bear it anymore. So almost everything restored smoothly from Google Backup and it was like being in my phone again with a few wizard steps but then I Installed WhatsApp (WA) and gone through the typical activation and restoring process and. as many, I got stuck at the 24% sometimes, some others 31% and 39%, and never got past the 39%.
I Tried almost everything: restoring from Google Drive, transfer all WhatsApp directory to internal storage and trying to restore from there, etc. Going back to the old phone to create fresh backups just in case they were corrupted as many people suggests, getting every time more delay to be able to activate WhatsApp again up to 12h for both SMS and call activation... just to mess again and feel back at square one, I guess you all feel the pain.
Well, the good news is that I finally managed to restore all the chat history!!! (well, cannot be certain that 100% was restored but I do not miss anything ATM and I can go back up to 2012 chats so I guess that qualifies as "everything" hehe).
So, I'm posting here because I've been searching a lot on the forums and the reddit and for all the people that is having this issue recently, almost no body came back to report success and I know it feels really discouraging It certainly gives the impression that this issue has no fix at all, and that you should accept losing all the chat history and starting from the start again. But from all the data I've been gathering during this week, at least two or three people reported to eventually being able to restore the chat; they fell in one of these two categories: they either transferred to a different phone where the backup seemed to restore okay, and then exported and restored in the target phone with success (something like a "bridge" restore mode, most of the cases I've read did it this way) or they finally succeeded by sheer brute force by trying again and again and again.
I fall in this 2nd category. In the most recent attempt I was doing what I've been doing again and again and again with just minor variations in the workflow and finally succeeded. TL; DR; I think in reality in many cases attempts could succeed by just letting the phone restore the backup endlessly, by not giving up and assuming the restore process went wrong when it has been stuck forever at either 24, 31 or 39% and force closing..
But I know in the midst of desperation OCD kicks in and you want step-by-step success case scenario reproduction so I will tell you all the steps that I followed that I can remember that got me to finally have the backup to end successfully:
0. First of all, in the winning attempt I had already uninstalled WA from the new phone and removed totally the WA folder in the internal storage / sdcard storage. Not sure this is mandatory but just to tell this was the case.
1. Since I got WA working perfectly on the old phone at every moment, I backed up locally for the Nth f%!?&ยท( time. This left me with the latest local backup plus a few others in the databases folder as a result of keep messing up.
2. I copied the full WhatsApp directory from the internal storage of the old phone to a safe place. This could be the PC or whatever, but PC transfer via USB seems too sloppy. You maybe could do it via ADB, whatever, I went by the route of coping it to the external SD with some random explorer utility like ES File Explorer. It does not matter, the point is to be able to backup the full WhatsApp folder in order to restore it as similar as possible as the original. What we are more interested right now is in the database folder but having all images, videos etc in place will help in getting it like before the easiest way. (Disclaimer: Ok guys sorry if some steps are too obvious to XDA users which usually are highly educated in the matter, but I was thinking of sharing/linking this text on the reddit and others, so please bear with it).
3. I installed latest WA in the new phone, opened the app (I intended to not open but I somewhat forgot) and got to the welcome screen, immediately closed the app at that step.
3. I restored the full folder to the new phone internal storage, pure copy/paste style (as said, in my case via the SD since both phones have SD slot and was very convenient, but via USB, cloud, etc. can be done).
4. I went to the databases folder and only kept the msgstore.db.crypt12 file and the latest backup with a date (ie: msgstore-2019-11-21.db.crypt12), deleted the rest. Honestly I do not think this is crucial but I somewhat wanted to make it easier for WA to know which one to target, I thought about keeping only the msgstore.db.crypt12 but some random dude pointed that the one with the date was needed. I was under the assumption that file structure is identical in both but just wanted to get done with this and keep both, just in case.
5. Before opening again the WA to try to activate and restore with this full local copy, I opened the Android settings app and went to applications > whatasapp > storage, as suggested by user redweaver, thanks for the tip! by keeping looking at the storage usage of the app during the restore process we could get insight about if it was really doing something or the app was really stuck. Keep open for now. In my case, I saw also on the old phone that my data used for the app was 780+ MB, so I had an idea of what should be on the new phone by the time it finished (if it did!).
5b. I don't think this is really necessary but I did it just in case. I was planning to go to work and let the thing running as long as it would need, and I would make sure that the process would get maximum uptime and nothing would get in the way. So I went to Applications > WhatsApp > Battery usage (or something like it) and disabled the battery optimizations for this app. I also went to the developer mode settings and enabled do not lock the phone while it is charging and everything that looked like it might be relevant. Again, most likely this has nothing to do, but reproducible steps, right?
6. Now open WA and activate it as usual, but when it seems that the activation step ended and you go to the next screen, immediately put the phone in air plane mode or disable data/WiFi, whatever. The goal is that it cannot reach Google Drive to look for the online backup. Honestly maybe in the end is not the culprit of GDrive but many people states that the GD backup is broken at this time and suggests going the local route, so we will do it like this.
7. WA should tell you that looking for the backup is going too slow and to skip this step (sorry to not have exact message, I have it in Spanish, but something in these lines, BTW excuse my somewhat limited English ). The point here is to click on the link that says skip the step and when you are prompted with a popup, click also on Skip.
8. WA will display the typical restore / transfer-like screen where the process starts. At this point you have to enable again data plan / WiFi at least or exit air plane mode, don't know really but even if restoring from local it complains about not having internet connection, maybe needs it to encrypt with the key or something? don't know.
9. Now is the feared moment! Even this time, I got somewhat stuck at 31% again. I left it do its thing, and some time later, it prompted for the popup that has a progress-bar from 0 to 100 (honestly, what is the difference between both?!) which also got stuck at 31%. If you let it be, it starts going back and forth many times, I guess maybe its going chat per chat and the progress-bar represents each one? Dunno. Thing is, even in the prior attempts I got at this point and the backup did not finish successfully. But this time I was decided to let it do its thing as much time as it would take, until the end. In the process the phone might display a pop up saying that WA does not respond. I clicked a few times in the 'keep waiting' option, then I just forgot because I did not have time to mess with it and hoped that it was still working on the background, which bring us to step 10.
10. While we are contemplating the backup process, we can go to the settings app again and look how the internal data is going for the WA. In my case, after some time under the restore process, when I went there I saw WA had occupied 0.91 GB of data space. After going back and forth again between WA and settings, the usage keep growing: 0.96, 1.03, 1.10... I thought it was on the right track, and encouraged me to keep waiting. Maybe in the end the process is too slow for old databases. Note that some people speculates that having messages from very long ago might be the culprit here due to changes in the table structure and that this might be the reason breaking the restore process. And maybe it is the case, but even if it is, in my case I finally succeeded where previously I didn't and without deleting anything, so this does not seem to be a deal-breaker or I would have never succeeded. I say it because some people reported that deleting old conversations and trying again finally made them succeed. Now I suspect the true reason was simply that by making the database smaller the process finished earlier, but YMMV.
11. Cannot be totally sure, but in my case, I noticed that leaving WA on the background and clicking on the WA icon again might stop the process for true and bring a message about not being able to recover the chats, I got this previously, do not try to open the WA normally, only leave it temporally to look to the space usage in the settings to get back to it by swyping between recent apps to keep the same instance open and working, this was a key point in my success trial that did not happen during the previous ones.
12. And finally, while I kept switching between WA and the settings and when I last saw like 1.30GB of space used (almost twice the space compared to the old phone, maybe it leaves a lot of temp data) I don't know if I either messed with the app-switching or it really finished, but then I got prompted to the screen where you enter your name or nickname. And when I completed this step, I finally got to the chats screen and everything was like in the old phone! Where previously I would get to a lot of empty chat rooms with maybe 40 total messages restored according to WA. Hurray!
Notice that in my case it was still reporting 31% on the WA background screen under the progress bar popup when it finished!! so it seems that is not really mandatory to experience the 100% complete to have it work in the end, but YMMV.
OK, maybe not the most elegant "guide" out there but I wrote it in a hurry and my english sucks, I just hope it might help someone to not lose their WA chats forever.
Good luck!
Edit: I almost forgot but, for the sake of completeness. I also tried a certain script that can backup WA from the phone and retrieve the encryption key, it will also leave an unencrypted copy of the chats database that can later be viewed with a WhatsApp viewer like this. The script is called WhatsApp Key/DB Extractor, and it still works as of 2019, just look at the latest posts in the thread. Guys here on XDA most likely know about it but if not, you might give it a try. I tried it because I assumed that maybe I could circumvent the restore issues by going that route and pushing the backup via ADB, but turns out the legacy WA won't prepare the database due to the time out of sync issue, or at least the data seemed to be lost after performing the restore process, and the unencrypted database on the PC cannot be digested by WA latest versions by just putting it into the internal storage directly according to what other users commented. But, if you finally give up trying the restore process, it still could be relieving to know that you keep a local copy in the PC that can be viewed with another PC tool, at least you get a backup and the conversations are there, in a different way though. Maybe in the future there's a process that can restore them again to a different phone, and you could then merge the new chat database with the older backup with tools like Merjeapp.
Click to expand...
Click to collapse
This has the solution
Kenora_I said:
This has the solution
Click to expand...
Click to collapse
Thank you but today I read this in the afternoon. This guy has solved it through whatsapp databases but I don't have a way go backup locally as I deleted my whatsapp databases two months ago. All I can do is recovering from google drive but the thing in this guy's scenario his chat was actually being restoring but I can't even do that since it says that I have an Internet connection problem

Categories

Resources