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

  1. Alexandru Popa 7 times, last 1 month ago
  2. jk 2 times, last 5 months ago
  3. bayukresno 40 times, last 5 months ago
  4. Roberto Tomás 3 times, last 8 months ago
  5. zildjiandm 12 times, last 8 months ago
2 more registered users
14 unregistered visitors
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