没有这样的表android_metadata，有什么问题？-Nosuchtableandroid_metadata,what'stheproblem?

107  

Actually, with a bit more reading, I have discovered that I need to use the SQLiteDatabase.NO_LOCALIZED_COLLATORS flag when calling SQLiteDatabase.openDatabase() - this no longer causes the problem.

实际上，通过更多阅读，我发现在调用SQLiteDatabase.openDatabase（）时我需要使用SQLiteDatabase.NO_LOCALIZED_COLLATORS标志 - 这不再导致问题。

30  

Use

使用

SQLiteDatabase.openDatabase(dbPath, null,SQLiteDatabase.NO_LOCALIZED_COLLATORS | SQLiteDatabase.CREATE_IF_NECESSARY);

or

要么

SQLiteDatabase.openDatabase(dbPath, null,SQLiteDatabase.OPEN_READWRITE);

4  

It seems that for some reason android requires every database to have a table called android_metadata that includes at least one locale. The reigndesign blog you mentioned tells you how to create the table and prefill it with a locale.

似乎由于某种原因，android要求每个数据库都有一个名为android_metadata的表，其中包含至少一个语言环境。您提到的reigndesign博客告诉您如何创建表并使用区域设置预填充它。

Check if your database contains this table and if the table has some content.

检查您的数据库是否包含此表以及该表是否包含某些内容。

3  

When you copy database from your assets directory for example, then you must have android_metadata table created in it already. This table should have two columns:

例如，从资产目录复制数据库时，必须已在其中创建了android_metadata表。该表应该有两列：

_id = an integer value
locale = en

2  

I am already using as given in that link for a long time..

我已经在该链接中使用了很长时间..

It works.. Checkout your DB again the table created or not ?

它的工作原理..再次检查你的数据库是否创建了表？

I prefer to install SQLite Manager plugin in firefox for sqlite database operation.. after completing all process as mentioned in the same link..

我更喜欢在firefox中安装SQLite Manager插件进行sqlite数据库操作..在完成同一链接中提到的所有进程之后..

Checkout http://www.devx.com/wireless/Article/40842/1954.

结帐http://www.devx.com/wireless/Article/40842/1954。

It contains all database operations.

它包含所有数据库操作。

2  

it might also just be file permissions - the error message is misleading. first you need to find out the user id of the app (this is assuming you have root access):

它也可能只是文件权限 - 错误消息具有误导性。首先，您需要找出应用程序的用户ID（假设您具有root访问权限）：

$ adb shell grep  /data/system/packages.xml

output should look like:

输出应如下所示：

userId here is 10002.

userId这里是10002。

then fix permissions:

然后修复权限：

$ adb shell chown -R 10002:10002 /data/data/

1  

In my case, I have discovered that this error will happen if I leave an open transaction left.

在我的情况下，我发现如果我留下一个打开的交易，就会发生这个错误。

In other words: If you forget to commit or rollback a transaction, in the next time you enter in your application, this error raises up.

换句话说：如果您忘记提交或回滚事务，则在下次输入应用程序时，会出现此错误。