A Alam122 Member Dec 30, 2019 #1 I have error message, i tried many ways but still confused with it "java.lang.IllegalArgumentException: column 'foto' does not exist. Available columns: [Email, nama, password, no.telepon, alamat]" Attachments Screenshot (21).png 189.7 KB · Views: 313
I have error message, i tried many ways but still confused with it "java.lang.IllegalArgumentException: column 'foto' does not exist. Available columns: [Email, nama, password, no.telepon, alamat]"
udg Expert Licensed User Longtime User Dec 30, 2019 #2 Are you sure that table datapengguna has a column named foto of type TEXT (or equivalent depending on the DBMS used)? The error message shows 5 columns but no "foto" among them. Upvote 0
Are you sure that table datapengguna has a column named foto of type TEXT (or equivalent depending on the DBMS used)? The error message shows 5 columns but no "foto" among them.
LucaMs Expert Licensed User Longtime User Dec 30, 2019 #3 Alam122 said: Available columns: [Email, nama, password, no.telepon, alamat] Click to expand... (bad name, with that dot) Upvote 0
Alam122 said: Available columns: [Email, nama, password, no.telepon, alamat] Click to expand... (bad name, with that dot)
A Alam122 Member Dec 31, 2019 #4 udg said: Are you sure that table datapengguna has a column named foto of type TEXT (or equivalent depending on the DBMS used)? The error message shows 5 columns but no "foto" among them. Click to expand... i add coloumn 'foto' at my sql, type of variable BLOB Attachments Screenshot (23).png 168.7 KB · Views: 355 Upvote 0
udg said: Are you sure that table datapengguna has a column named foto of type TEXT (or equivalent depending on the DBMS used)? The error message shows 5 columns but no "foto" among them. Click to expand... i add coloumn 'foto' at my sql, type of variable BLOB
DonManfred Expert Licensed User Longtime User Dec 31, 2019 #5 Alam122 said: i add coloumn 'foto' at my sql, type of variable BLOB Click to expand... that may be. But did you copied the new db to your device replacing the old one? And at appstart you copied this new db over the old db? I guess you are using an old version of the DB without this field. Upvote 0
Alam122 said: i add coloumn 'foto' at my sql, type of variable BLOB Click to expand... that may be. But did you copied the new db to your device replacing the old one? And at appstart you copied this new db over the old db? I guess you are using an old version of the DB without this field.
