org.jumpmind.db.sql.SqlException: near "null": syntax error (code 1): , while compiling: pragma table_info(null)

symmetricds | jazaman | 11 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Symmetricds Synchronization failure: Failed to route and batch data

    symmetricds | 11 months ago | jazaman
    org.jumpmind.db.sql.SqlException: near "null": syntax error (code 1): , while compiling: pragma table_info(null)
  2. 0

    Error executing sqlite query

    Stack Overflow | 3 years ago | user2764599
    android.database.sqlite.SQLiteException: no such table: qt_um_stock_items_qty (code 1): , while compiling: SELECT BAL_DATE AS ON_DT, (IFNULL ( IN_QTY, 0)-IFNULL (OUT_QTY, 0)) AS CL_QTY,(SELECT CODE || '-' || NAME FROM qm_um_stock_items WHERE ID = STOCK_ITEM_ID) AS ITEM,(SELECT CODE|| '-' ||NAME FROM qm_um_unit WHERE ID = BASE_UNIT_ID ) AS UNIT FROM qt_um_stock_items_qty WHERE STOCK_CENTER_ID =? AND STOCK_ITEM_ID=?
  3. 0

    Execute query in Sqlite database in android

    Stack Overflow | 2 years ago | user3411639
    android.database.sqlite.SQLiteException: no such table: Table1 (code 1): , while compiling: select CellID from Table1 where _id='2'
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sqlite database path is not working

    Stack Overflow | 4 years ago | Tasneem
    android.database.sqlite.SQLiteException: no such table: QUESTIONS (code 1): , while compiling: SELECT * FROM QUESTIONS
  6. 0

    Android "no such table" on some devices

    Stack Overflow | 4 years ago | user1751439
    java.lang.RuntimeException: Unable to start activity ComponentInfo{com.radoman.gameofthrones/com.radoman.gameofthrones.FavQuotesActivity}: android.database.sqlite.SQLiteException: no such table: quotes (code 1): , while compiling: SELECT * FROM quotes WHERE fav=1

  1. Aria Pahlavan 8 times, last 4 months ago
  2. mrokay97 2 times, last 8 months ago
  3. Riyaz 1 times, last 10 months ago
  4. Bardh 1 times, last 10 months ago
  5. jk 12 times, last 10 months ago
4 more registered users
17 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

    near "null": syntax error (code 1): , while compiling: pragma table_info(null)

    at android.database.sqlite.SQLiteConnection.nativePrepareStatement()
  2. Android Platform
    SQLiteDatabase.rawQuery
    1. android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
    2. android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:882)
    3. android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493)
    4. android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
    5. android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
    6. android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37)
    7. android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
    8. android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
    9. android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
    9 frames
  3. org.jumpmind.symmetric
    AndroidSqlReadCursor.<init>
    1. org.jumpmind.symmetric.android.AndroidSqlReadCursor.<init>(AndroidSqlReadCursor.java:48)
    1 frame