My error : error DatabaseException(near "INTEGER": syntax error (code 1): , while compiling: CREATE TABLE commercant(
I/flutter ( 5164): id INTEGER PRIMARY KEY,
I/flutter ( 5164): nom TEXT,
I/flutter ( 5164): departement TEXT,
I/flutter ( 5164): districtActiviter TEXT,
I/flutter ( 5164): categorie TEXT,
I/flutter ( 5164): marcher TEXT,
I/flutter ( 5164): gameProduit TEXT,
I/flutter ( 5164): telephone TEXT,
I/flutter ( 5164): whatsapp TEXT,
I/flutter ( 5164): email TEXT,
I/flutter ( 5164): favorite INTEGER) sql ' CREATE TABLE commercant(
I/flutter ( 5164): id INTEGER PRIMARY KEY,
I/flutter ( 5164): nom TEXT,
I/flutter ( 5164): departement TEXT,
I/flutter ( 5164): districtActiviter TEXT,
I/flutter ( 5164): categorie TEXT,
I/flutter ( 5164): marcher TEXT,
I/flutter ( 5164): gameProduit TEXT,
I/flutter ( 5164): telephone TEXT,
I/flutter ( 5164): whatsapp TEXT,
I/flutt
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (1)
Hi Marcel. Given the info in your question it's almost impossible to figure out what's going on. It's just a truncated error output. But for troubleshooting and helping you it's also necessary to see the actual full
CREATE TABLE commercant
source code so it's possible to point out where the syntax error is coming from.I'm not sure if it's just an error log output glitch, but it seems the
CREATE TABLE commercant(...)
code is duplicated, and right before the duplication starts there is in fact anINTEGER
keyword as pointed out by the syntax error message:This would be in fact invalid SQL and could be a copy paste mistake in the SQL script file?
Two SQL statements, such as for creating tables, need to be separated by a semicolon. But again, without having seen the original SQL source file it's hard to guess what's going on.