# Error: no such table: topics **URL:** \ **Category:** Issues\ **Created:** [December 16, 2014, 6:59am UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306 "2014-12-16T06:59:54Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![naory159](https://avatars.discourse-cdn.com/v4/letter/n/c89c15/32.png) [@naory159](https://discuss.zetetic.net/u/naory159)\ **Post date:** [December 16, 2014, 6:59am UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/1 "2014-12-16T06:59:55Z")
Hallo I try to do this: ``` 180 String query = String.format("select title,id from topics;"); 181 Cursor c = db.rawQuery(query, null); ``` The DB exist, and the table “topics” exist! And I get this crash in line 181: ``` Caused by: net.sqlcipher.database.SQLiteException: no such table: topics: , while compiling: select title,id from topics; ``` In some smartphones I do not get an error, and some I do get an error! What the problem? ---
**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Post date:** [December 16, 2014, 2:52pm UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/2 "2014-12-16T14:52:56Z")
Hello @naory159, Is this an issue you can reproduce? Can you pull the database file off of the device when you receive this error message to allow for further evaluation? ---
**Author:** ![naory159](https://avatars.discourse-cdn.com/v4/letter/n/c89c15/32.png) [@naory159](https://discuss.zetetic.net/u/naory159)\ **Post date:** [December 16, 2014, 9:56pm UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/3 "2014-12-16T21:56:55Z")
The DB files do not change during running the application (The DB files are books). I have access to all encrypted files. And all have the above table. I did not encounter this problem, but other users encountered the problem. I tried myself to create the problem but it seems that everything is fine! The error occurred smartphones which are (maybe this information will help): Galaxy Note II (t03g) Galaxy Tab4 8.0 (milletlteatt) Galaxy Note2 (t0ltespr) Galaxy S (GT-I9000) Galaxy S3 (m3) Nexus 4 (mako) Droid MAXX (obake-maxx) OnePlus One (A0001) LG G2 (g2) ---
**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Post date:** [December 16, 2014, 10:24pm UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/4 "2014-12-16T22:24:56Z")
Hi @naory159 I have not seen that issue before. If you find out any additional information regarding the scenario we would love to know about it. Being able to recreate it within the SQLCipher for Android [test suite](https://github.com/sqlcipher/sqlcipher-android-tests) would be preferred. ---
**Author:** ![naory159](https://avatars.discourse-cdn.com/v4/letter/n/c89c15/32.png) [@naory159](https://discuss.zetetic.net/u/naory159)\ **Post date:** [January 5, 2015, 7:54am UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/5 "2015-01-05T07:54:21Z")
OK! I wiil try. What version of sqlchiper most stable to use in android (maybe this is the problem? Today I use version “SQLCipher for Android v2.2.2”)? ---
**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Post date:** [January 5, 2015, 1:58pm UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/6 "2015-01-05T13:58:37Z")
Hello @naory159, The current version of SQLCipher for Android is the 3.2.0 build which is available [here](https://www.zetetic.net/sqlcipher/open-source/). Please keep in mind if you are upgrading from databases that were using the 2.x library, you will need to upgrade existing databases. More information can be found [here](https://www.zetetic.net/blog/2013/11/11/sqlcipher-300-release.html). ---
**Author:** ![naory159](https://avatars.discourse-cdn.com/v4/letter/n/c89c15/32.png) [@naory159](https://discuss.zetetic.net/u/naory159)\ **Post date:** [January 5, 2015, 5:32pm UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/7 "2015-01-05T17:32:56Z")
Thank you! I updated to version 3.2. I noticed that this version weighs much more. Are there any files that are disposable and not put them in the app? But I want you to be fully compatible with all smartphones ---
**Author:** ![developernotes](https://sea2.discourse-cdn.com/flex016/user_avatar/discuss.zetetic.net/developernotes/32/1309_2.png) [@developernotes](https://discuss.zetetic.net/u/developernotes)\ **Post date:** [January 5, 2015, 10:43pm UTC](https://discuss.zetetic.net/t/error-no-such-table-topics/306/8 "2015-01-05T22:43:31Z")
Hello @naory159 The only option would be to customize the size of the ICU localization dat file. More information can be found [here](https://www.zetetic.net/sqlcipher/sqlcipher-for-android/) at the bottom of the page, however adjustments like this may impact your application.