Author Topic: sql database has changed  (Read 4235 times)

kitwashere

  • Newbie
  • *
  • Posts: 2
sql database has changed
« on: October 10, 2013, 01:11:58 am »
I used to be able to use the following query to pull the full contents of an email body, but as of recent this has been reduced to just the first few lines

sqlite3 /data/data/org.kman.AquaMail/databases/Messages.sqldb "SELECT body_main_content_utf8 || '@|@' || subject || '@|@' FROM message ORDER BY _id DESC LIMIT 1"

Would be nice if pulling the whole body of an email was possible again

Kostya Vasilyev

  • Hero Member
  • *****
  • Posts: 12740
Re: sql database has changed
« Reply #1 on: October 10, 2013, 02:47:58 am »
No change there, it's just that the entire message text is not loaded until you open a message.
Creating debug logs for diagnostics: https://www.aqua-mail.com/troubleshooting/

The official FAQ: https://www.aqua-mail.com/faq/

Лог-файлы для диагностики: https://www.aqua-mail.com/ru/troubleshooting/

Вопросы и ответы: https://www.aqua-mail.com/ru/faq/

kitwashere

  • Newbie
  • *
  • Posts: 2
Re: sql database has changed
« Reply #2 on: October 11, 2013, 02:28:31 am »
Ahh, okay. Thank you for the response.

I guess this is a feature request then haha. Maybe an option to turn this on or off, I imagine it might make the database unnecessarily large for some people.

Fingers crossed!