iOSMessageExport icon indicating copy to clipboard operation
iOSMessageExport copied to clipboard

DBD::SQLite::db prepare failed: no such table: message at iOSMessages.pm line 86.

Open gnosisgithub opened this issue 7 years ago • 2 comments

OK, tried on iMAC and this is what was returned: DBD::SQLite::db prepare failed: no such table: message at iOSMessages.pm line 86.

gnosisgithub avatar May 14 '18 15:05 gnosisgithub

Workaround for me was to edit the file iOSMessages.pm and change line 13 to include 3d/ _sms_db_filename => '3d/3d0d7e5fb2ce288813306e4d4636395e047a3d28',

Afterwards you will get a similar error for the contacts: no file at 40b4641adcc5fe20fa0e32b86a6b71f6c297bf55/31bb7ba8914766d4ba40d6dfb6113c8b614be442 at iOSMessageExport/iOSContacts.pm line 62.

To solve this change line 16 to include a 31/ _contacts_db_filename => '31/31bb7ba8914766d4ba40d6dfb6113c8b614be442',

Seems newer versions put the backup files into a subfolder.

arnemoor avatar Jun 14 '18 11:06 arnemoor

I made the change to line 13 and I don't get the second error, but I get this error? "failed: unable to open database file at iOSMessageExport/iOSMessages.pm line 45." Any suggestions?

**trailing / in --directory argument fixed this issue for me Works: perl iOSMessageExport/backup.pl --directory_path 9b9f73759fad7b31e330dd26bf7f745acccf1869/ Doesn't work perl iOSMessageExport/backup.pl --directory_path 9b9f73759fad7b31e330dd26bf7f745acccf1869

so if you are just dragging your directory into the terminal window it doesn't add the trailing slash at the end.

rudenik avatar Dec 17 '18 21:12 rudenik