android.database.sqlite.SQLiteException

table hospital has no column named zip (code 1): , while compiling: INSERT INTO hospital(zip,avgCharges,avgPayment,_id,address,providerName,state,procedure,discharges,city) VALUES (?,?,?,?,?,?,?,?,?,?)


Solutions on the web1776

Solution icon of stackoverflow
via Stack Overflow by Srihari Srinivasan
, 3 months ago
table hospital has no column named zip (code 1): , while compiling: INSERT INTO hospital(zip,avgCharges,avgPayment,_id,address,providerName,state,procedure,discharges,city) VALUES (?,?,?,?,?,?,?,?,?,?)

Solution icon of stackoverflow
table tbcategory has no column named _gender (code 1): , while compiling: INSERT INTO tbcategory(_name,_id,_age,_gender) VALUES (?,?,?,?)

Solution icon of stackoverflow
via Stack Overflow by zyngawow
, 1 year ago
table farms has no column named farms (code 1): , while compiling: INSERT INTO farms(farms) VALUES (?)

Solution icon of stackoverflow
via Stack Overflow by Parth Patel
, 4 months ago
table members has no column named COLUMN_USERNAME (code 1): , while compiling: INSERT INTO members( COLUMN_USERNAME ) VALUES (?)

Solution icon of stackoverflow
table question has no column named question: , while compiling: INSERT INTO question(question, _id) VALUES(?, ?);

Solution icon of stackoverflow
table ings has no column named ing_name (code 1): , while compiling: INSERT INTO ings(ing_name) VALUES (?)

Solution icon of stackoverflow
table stock has no column named Discount (code 1): , while compiling: INSERT INTO stock(Discount,Detail,_id,Price,ImageURL,Quantity,Name) VALUES (?,?,?,?,?,?,?)

Solution icon of stackoverflow
table userdetails has no column named lname: , while compiling: INSERT INTO userdetails(username, lname, password, fname, city) VALUES(?, ?, ?, ?, ?);

Solution icon of stackoverflow
table LOGIN has no column named EMAIL (code 1): , while compiling: INSERT INTO LOGIN(EMAIL,USERNAME,PASSWORD) VALUES (?,?,?)

Solution icon of stackoverflow
via Stack Overflow by Android Learner
, 1 year ago
table REGISTER has no column named NAME (code 1): , while compiling: INSERT INTO REGISTER(NAME,NUMBER) VALUES (?,?)

Stack trace

  • android.database.sqlite.SQLiteException: table hospital has no column named zip (code 1): , while compiling: INSERT INTO hospital(zip,avgCharges,avgPayment,_id,address,providerName,state,procedure,discharges,city) VALUES (?,?,?,?,?,?,?,?,?,?) at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Once, 1 month ago
11 times, 8 months ago
5 times, 11 months ago
18 times, 11 months ago
1728 times, 1 year ago
108 more bugmates