Databases
StackOverflow2013
Postsdbo
POSqlite Exception, syntax error
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POSqlite Exception, syntax error
    primarykey
    data
    text
    <p>i'm still learning Android development, And i have a problem creating an sqlite database table. here is a part of my code :</p> <p>`</p> <pre><code>private static final String CREATE_ADS_PICTURE = "CREATE TABLE " + AdsBDD.TABLE_ADS_PICTURE + "(" + AdsBDD.ID_PICS + " INTEGER PRIMARY KEY AUTOINCREMENT ," + AdsBDD.AD_ID + " INTEGER NOT NULL," + AdsBDD.PICTURE + " TEXT," + AdsBDD.FOLDER + " TEXT," + AdsBDD.ORDER_NO + " INTEGER NOT NULL);"; private static final String CREATE_AGENCES = "CREATE TABLE " + AgencesBDD.TABLE_AGENCES + "(" + AgencesBDD.ID + " INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL," + AgencesBDD.GROUP + " INTEGER," + AgencesBDD.USERNAME + " TEXT," + AgencesBDD.EMAIL + " TEXT," + AgencesBDD.CONTACT_NAME + " TEXT," + AgencesBDD.REGISTRATION_DATE + " TEXT," + AgencesBDD.ACTIVATION + " TEXT," + AgencesBDD.ACTIVE + " INTEGER," + AgencesBDD.STORE + " INTEGER," + AgencesBDD.STORE_BANNER + " TEXT," + AgencesBDD.RATING + " REAL," + AgencesBDD.LANGUAGE + " TEXT," + AgencesBDD.IDENTITY + " TEXT," + AgencesBDD.ADDRESS + " TEXT," + AgencesBDD.PHONE + " TEXT," + AgencesBDD.COMPANY + " TEXT," + AgencesBDD.WEBPAGE + " TEXT," + AgencesBDD.CODE_POSTAL + " TEXT," + AgencesBDD.JE_SUIS_UN + " TEXT," + AgencesBDD.VILLE + " TEXT," + AgencesBDD.VIDEO + " TEXT);"; @Override public void onCreate(SQLiteDatabase db) { db.execSQL(CREATE_ADS_PICTURE); db.execSQL(CREATE_AGENCES); } public class AgencesBDD { public static final String TABLE_AGENCES = "agences"; public static final String ID = "id"; public static final String GROUP = "group"; public static final String USERNAME = "username"; public static final String EMAIL = "email"; public static final String CONTACT_NAME = "contact_name"; public static final String REGISTRATION_DATE = "registration_date"; public static final String ACTIVATION = "activation"; public static final String ACTIVE = "active"; public static final String STORE = "store"; public static final String STORE_BANNER = "store_banner"; public static final String RATING = "rating"; public static final String LANGUAGE = "language"; public static final String IDENTITY = "identity"; public static final String ADDRESS = "address"; public static final String PHONE = "phone"; public static final String COMPANY = "company"; public static final String WEBPAGE = "webpage"; public static final String CODE_POSTAL = "code_postal"; public static final String JE_SUIS_UN = "je_suis_un"; public static final String VILLE = "ville"; public static final String VIDEO = "video"; </code></pre> <p>` So the problem is that Sqlite throws this exception for the table AGENCES, but the Table AD_PICTURE works fine:</p> <pre><code>03-08 14:36:01.892: E/AndroidRuntime(10822): FATAL EXCEPTION: main 03-08 14:36:01.892: E/AndroidRuntime(10822): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.infonetdiffusion.immohabitation/com.infonetdiffusion.immohabitation.FragmentBaseActivity}: android.database.sqlite.SQLiteException: near "group": syntax error (code 1): , while compiling: CREATE TABLE agences(id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,group INTEGER,username TEXT,email TEXT,contact_name TEXT,registration_date TEXT,activation TEXT,active INTEGER,store INTEGER,store_banner TEXT,rating REAL,language TEXT,identity TEXT,address TEXT,phone TEXT,company TEXT,webpage TEXT,code_postal TEXT,je_suis_un TEXT,ville TEXT,video TEXT); </code></pre> <p>it should be easy to fix, but i can't find where i'm wrong... any help would be apreciated!</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPsypher
    1. USNcm112
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POSqlite Exception, syntax error
      1. This table or related slice is empty.
      1. VTUpMod
    1. COIt would probably be a lot easier if you just printed out your create strings and posted those. Also, as a quick guess i'd say 'group' is just a reserved command and its now expecting a GROUP BY command. Try changing group to something random like 'test'
      singulars
      1. POSqlite Exception, syntax error
      1. USStefan de Bruijn
    2. COjust edited it.
      singulars
      1. POSqlite Exception, syntax error
      1. USNcm112
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload