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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

JIRA | James Prister | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    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;

    JIRA | 2 years ago | James Prister
    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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
  2. 0

    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;

    JIRA | 2 years ago | James Prister
    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 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
  3. 0

    Cm 12.1 Nightlies - Apn Issues - Motorola Moto X Development - CyanogenMod Forum

    cyanogenmod.org | 2 years ago
    android.database.sqlite.SQLiteException: table carriers has no column named localized_name (code 1): , while compiling: INSERT INTO carriers(mvno_match_data,password,modem_cognitive,carrier_enabled,sub_id,mvno_type,roaming_protocol,profile_id,authtype,user,localized_name,protocol,read_only,mmsport,bearer,mmsproxy,proxy,server,name,max_conns_time,port,apn,wait_time,max_conns) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Database File not Creating Android

    Stack Overflow | 2 years ago | Miuranga
    android.database.sqlite.SQLiteException: no such table: userInfo (code 1): , while compiling: INSERT INTO userInfo(passHint,password,username) VALUES (?,?,?)
  6. 0

    [ROM] CyanogenMod 12.0 | Android 5.0 Lollipop | [03/13/2015] - Post #0 - XDA Forums

    xda-developers.com | 2 years ago
    android.database.sqlite.SQLiteException: table sms has no column named sub_id (code 1): , while compiling: INSERT INTO sms(address,creator,seen,thread_id,sub_id,read,date,body,subject,type) VALUES (?,?,?,?,?,?,?,?,?,?)
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. 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()
  2. Android Platform
    SQLiteDatabase.insert
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:891)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:502)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    6. android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
    7. android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1469)
    8. android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1341)
    8 frames
  3. com.android.providers
    TelephonyProvider.insert
    1. com.android.providers.telephony.TelephonyProvider.insert(TelephonyProvider.java:988)
    1 frame
  4. Android Platform
    Binder.execTransact
    1. android.content.ContentProvider$Transport.insert(ContentProvider.java:239)
    2. android.content.ContentProviderNative.onTransact(ContentProviderNative.java:163)
    3. android.os.Binder.execTransact(Binder.java:446)
    3 frames