android.database.sqlite.SQLiteException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • In APN settings dialog, cannot create a new APN OR reset APNs. Cause, Logcat, and Solution follow. Cause: /data/data/com.android.providers.telephony/databases/telephony.db carriers table lacks sub_id field Relevant logcat: D/ApnEditor( 3923): ApnEditor onCreate received sub: 1 D/TelephonyProvider( 3987): subIdString = 1 subId = 1 E/SQLiteLog( 3987): (1) table carriers has no column named sub_id E/SQLiteDatabase( 3987): Error inserting mvno_match_data= password= modem_cognitive=false carrier_enabled=true sub_id=1 mvno_type= roaming_protocol=IP profile_i d=0 authtype=-1 user= localized_name= protocol=IP read_only=false mmsport= bearer=0 mmsproxy= proxy= server= name= max_conns_time=0 port= apn= wait_time=0 max_c onns=0 E/SQLiteDatabase( 3987): android.database.sqlite.SQLiteException: table carriers has no column named sub_id (code 1): , while compiling: INSERT INTO carriers(mv no_match_data,password,modem_cognitive,carrier_enabled,sub_id,mvno_type,roaming_protocol,profile_id,authtype,user,localized_name,protocol,read_only,mmsport,bear er,mmsproxy,proxy,server,name,max_conns_time,port,apn,wait_time,max_conns) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:891) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:502) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1341) E/SQLiteDatabase( 3987): at com.android.providers.telephony.TelephonyProvider.insert(TelephonyProvider.java:988) E/SQLiteDatabase( 3987): at android.content.ContentProvider$Transport.insert(ContentProvider.java:239) E/SQLiteDatabase( 3987): at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:163) E/SQLiteDatabase( 3987): at android.os.Binder.execTransact(Binder.java:446) W/ApnEditor( 3923): Failed to insert new telephony provider into content://telephony/carriers//subId/1 D/ApnSettings( 3923): getOperatorNumeric: sub= 1 mcc-mnc= 310150 D/ApnSettings( 3923): getOperatorNumericSelection: numeric="310150" D/TelephonyProvider( 3987): subIdString = 1 subId = 1 D/TelephonyProvider( 3987): subIdString = 1 subId = 1 D/TelephonyProvider( 3987): Preferred APN: -1 Solution: sqlite3 /data/data/com.android.providers.telephony/databases/telephony.db alter table carriers add sub_id INTEGER;
    via by James Prister,
  • In APN settings dialog, cannot create a new APN OR reset APNs. Cause, Logcat, and Solution follow. Cause: /data/data/com.android.providers.telephony/databases/telephony.db carriers table lacks sub_id field Relevant logcat: D/ApnEditor( 3923): ApnEditor onCreate received sub: 1 D/TelephonyProvider( 3987): subIdString = 1 subId = 1 E/SQLiteLog( 3987): (1) table carriers has no column named sub_id E/SQLiteDatabase( 3987): Error inserting mvno_match_data= password= modem_cognitive=false carrier_enabled=true sub_id=1 mvno_type= roaming_protocol=IP profile_i d=0 authtype=-1 user= localized_name= protocol=IP read_only=false mmsport= bearer=0 mmsproxy= proxy= server= name= max_conns_time=0 port= apn= wait_time=0 max_c onns=0 E/SQLiteDatabase( 3987): android.database.sqlite.SQLiteException: table carriers has no column named sub_id (code 1): , while compiling: INSERT INTO carriers(mv no_match_data,password,modem_cognitive,carrier_enabled,sub_id,mvno_type,roaming_protocol,profile_id,authtype,user,localized_name,protocol,read_only,mmsport,bear er,mmsproxy,proxy,server,name,max_conns_time,port,apn,wait_time,max_conns) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:891) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:502) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) E/SQLiteDatabase( 3987): at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1341) E/SQLiteDatabase( 3987): at com.android.providers.telephony.TelephonyProvider.insert(TelephonyProvider.java:988) E/SQLiteDatabase( 3987): at android.content.ContentProvider$Transport.insert(ContentProvider.java:239) E/SQLiteDatabase( 3987): at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:163) E/SQLiteDatabase( 3987): at android.os.Binder.execTransact(Binder.java:446) W/ApnEditor( 3923): Failed to insert new telephony provider into content://telephony/carriers//subId/1 D/ApnSettings( 3923): getOperatorNumeric: sub= 1 mcc-mnc= 310150 D/ApnSettings( 3923): getOperatorNumericSelection: numeric="310150" D/TelephonyProvider( 3987): subIdString = 1 subId = 1 D/TelephonyProvider( 3987): subIdString = 1 subId = 1 D/TelephonyProvider( 3987): Preferred APN: -1 Solution: sqlite3 /data/data/com.android.providers.telephony/databases/telephony.db alter table carriers add sub_id INTEGER;
    via by James Prister,
  • Database File not Creating Android
    via Stack Overflow by Miuranga
    ,
  • SQLite insert errors
    via Stack Overflow by 1. 618
    ,
    • android.database.sqlite.SQLiteException: table carriers has no column named sub_id (code 1): , while compiling: INSERT INTO carriers(mv no_match_data,password,modem_cognitive,carrier_enabled,sub_id,mvno_type,roaming_protocol,profile_id,authtype,user,localized_name,protocol,read_only,mmsport,bear er,mmsproxy,proxy,server,name,max_conns_time,port,apn,wait_time,max_conns) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:891) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:502) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31) at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469) at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1341) at com.android.providers.telephony.TelephonyProvider.insert(TelephonyProvider.java:988) at android.content.ContentProvider$Transport.insert(ContentProvider.java:239) at android.content.ContentProviderNative.onTransact(ContentProviderNative.java:163) at android.os.Binder.execTransact(Binder.java:446)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor2 times, last one,
    Alexandru Popa
    7 times, last one,
    jk
    1112 times, last one,
    bayukresno
    40 times, last one,
    108 more bugmates