Have a Question?

If you have any question you can ask below or enter what you are looking for!

How to repair a corrupted database file

If you're experiencing crashes while starting up the app, please do not uninstall the app, as this will delete all your data. you may try to follow the steps below to repair your database.


Tools that you need to have before you start:
1.) iTunes - download link
2.) Sqlite3 - download link
Download the command line shell for Windows or Mac depending on your OS.


1.) Make sure that you've totally close the app. You can double check this by double tapping on your Home Button, make sure that ARMS F&B is not showing up on the App Switcher.


2.) Connect your iPad to your Mac or PC


3.) Navigate to Apps > File Sharing section > ARMS F&B


4.) Select the file Setting.sqlite and then select the Save to... button. (Preferably you can save it to the same folder of your sqlite file)



5.) Do a checking on your database to see if its really corrupted.
Launch MS-Dos Command(on Windows) or Terminal(on Mac) 
Then go to your database directory, and launch SQLite: sqlite3 Setting.sqlite

You can check the database integrity by: 
pragma integrity_check;
If it returns OK, you don't need to do a repair, your database is good. You can then quit sqlite by: .quit

If you have error messages you can quit sqlite by: .quit after that go to the Next Step

6.) Export your data to a SQL File with the following command:
Windowsecho .dump | sqlite3.exe Setting.sqlite > setting.sql
Mac: echo .dump | sqlite3 Setting.sqlite > setting.sql


7.) A new file name setting.sql file will be created, open this file with Notepad(on Windows) or Text Edit(on Mac) or other similar text editing tools.


8.) Make sure that the last row is COMMIT; or END TRANSACTION; if its ROLLBACK; change it to COMMIT; and save the file. (Please note that the semicolon is required)


9.) Rename the existing Setting.sqlite file to any other name. (e.g. Setting-old.sqlite or Setting-corrupt.sqlite)


10.) Import the exported data into a new database with the following command:
Windows: sqlite3.exe -init Setting.sql Setting.sqlite
Mac: sqlite3 -init Setting.sql Setting.sqlite


11.) A new Setting.sqlite file will be created, now you need to put the Setting.sqlite back into your iPad.


12.) On iTunes select the Add... button and select the newly created Setting.sqlite file. Select Yes when ask for confirmation on replacing the Setting.sqlite file.


13.) Delete the Setting.sqlite-shm and Setting.sqlite-wal, by using the Backspace or Delete key on your keyboard. (Skip this step if Setting.sqlite-shm and Setting.sqlite-wal could not be found)


14.) You can now launch ARMS F&B and see if your issue is solved.


If you're still experiencing the same issue after repairing your database or you have trouble following the steps, you may contact support at [email protected]
If possible please try to include your Setting.sqlite file(follow until step 4) and your crash logs together so that we can speed up the investigation process.
You may refer here on how to retrieve the crash logs: http://kb.arms.my/faq/arms-f-b/others/crash-log-submission


If above steps doesn't help, you can open a support ticket at http://support.arms.my/