Android - SQLite could not read row 0, col -1 error -

-

i have application populates 11 database tables , fetches data , displays in logcat. application used work until changed primary key autoincrement. change worked fine tables 1 table gave me problem.

here dbadapter, , part generate user database (the 1 that's giving me problem):

//variables user table public static final string table_user = "user"; public static final string user_id = "_id"; public static final string username = "username"; public static final string password = "password"; public static final string l_name = "l_name"; public static final string m_name = "m_name"; public static final string f_name = "f_name"; public static final string office = "office"; public static final string cellphonenumber = "cellphone_number"; public static final string landline = "landline"; public static final string address = "address"; public static final string email = "email";  private static final string database_create_user_table = "create table " + table_user          + "(" + user_id + " integer primary key autoincrement,"          + username + " text not null, "         + password + " text not null, "         + l_name + " text not null, "         + m_name + " text not null, "         + f_name + " text not null, "         + office + " text not null, "         + cellphonenumber + " text not null, "         + landline + " text not null, "         + address + " text not null, "         + email + " text not null);" ;

of course few lines down, in dbadapter's oncreate method, have this:

        database.execsql(database_create_authorized_personnel_table);

i have userclass shown below:

public class userclass {  private string _id; private string username; private string password; private string l_name; private string m_name; private string f_name; private string office; private string cellphone_number; private string landline; private string address; private string email;   //constructor - empty public userclass(){  }  //constructor public userclass(string username, string password, string lastname, string middlename, string firstname,                      string office, string cpnumber, string landline, string address, string email){     this.username = username;     this.password = password;     this.l_name = lastname;     this.m_name = middlename;     this.f_name = firstname;     this.office = office;     this.cellphone_number = cpnumber;     this.landline = landline;     this.address = address;     this.email = email;  }

i have setters , getters after constructors.

i have userdbadapter class, takes care of database queries , data fetching, data access object. adduser(userclass user) method:

//add 1 user public long adduser(userclass user){      contentvalues values = new contentvalues();      values.put(username, user.getusername());     values.put(password, user.getpassword());     values.put(l_name, user.getl_name());     values.put(m_name, user.getm_name());     values.put(f_name, user.getf_name());     values.put(office, user.getoffice());     values.put(cellphonenumber, user.getcellphone_number());     values.put(landline, user.getlandline());     values.put(address, user.getaddress());     values.put(email, user.getemail());      return this.mdb.insert(table_user, null, values); }

and method gets users along details: //get users public list getallusers() { list contactlist = new arraylist(); // select query string selectquery = "select * " + table_user;

    cursor cursor = mdb.rawquery(selectquery, null);      // looping through rows , adding list     if (cursor.movetofirst()) {         {             userclass user = new userclass();              user.set_id(cursor.getstring(cursor.getcolumnindex(user_id) ) );             user.setusername(cursor.getstring(cursor.getcolumnindex(username) ) );             user.setpassword(cursor.getstring(cursor.getcolumnindex(password) ) );             user.setl_name(cursor.getstring(cursor.getcolumnindex(l_name) ) );             user.setm_name(cursor.getstring(cursor.getcolumnindex(m_name) ) );             user.setf_name(cursor.getstring(cursor.getcolumnindex(f_name) ) );             user.setoffice(cursor.getstring(cursor.getcolumnindex(office) ) );             user.setcellphone_number(cursor.getstring(cursor.getcolumnindex(cellphonenumber) ) );             user.setlandline(cursor.getstring(cursor.getcolumnindex(landline) ) );             user.setaddress(cursor.getstring(cursor.getcolumnindex(address) ) );             user.setemail(cursor.getstring(cursor.getcolumnindex(email) ) );               // adding contact list             contactlist.add(user);         } while (cursor.movetonext());     }      // return contact list     return contactlist; }

in activity, populating database such , getting data such:

public void initializeuserdb(){     log.d("users", "inserting . . .");      userdb.open();     userdb.adduser(new userclass("user1", "1234", "doe", "smith", "john", "makati",                                      "09123456789", "1234567", "lorem ipsum dolor", "loremipsum@dolor.com"));     userdb.adduser(new userclass("user2", "1234", "smith", "doe", "john", "makati",                                      "cpnumber", "landline", "address", "electronic mail address"));       //check if inputted     log.d("reading: ", "reading users . . .");      list<userclass> users = userdb.getallusers();             (userclass user : users) {         string log = "id: " + user.get_id() + "\n" +                         "username: " + user.getusername() + "\n" +                         "password: " + user.getpassword() + "\n" +                         "last name: " + user.getl_name() + "\n" +                         "middle name: " + user.getm_name() + "\n" +                         "first name: " + user.getf_name() + "\n" +                         "office: " + user.getoffice() + "\n" +                         "cellphone number: " + user.getcellphone_number() + "\n" +                         "landline: " + user.getlandline() + "\n" +                         "address: " + user.getaddress() +"\n" +                         "email: " + user.getemail();             // writing contacts log         log.d("details: ", log);     }     userdb.close(); }

the data inserted properly, however, when comes getting data, logcat tells me there's problem @ line user.setemail(cursor.getstring(cursor.getcolumnindex(email) ) ); in userdbadapter class.

i think able initialize email column, otherwise i'd error data insertion sequence. if comment out line, user.getemail(); method in activity give me null.

i'm confused problem, initialized table right , inserted values properly, don't understand why not able fetch value properly.

another simple mistake on part, sorry.

in userdbadapter class, line public static final string email = "email"; should be: public static final string email = "email";


Comments

Post a Comment

Popular posts from this blog

css - Which browser returns the correct result for getBoundingClientRect of an SVG element? -

-
this svg contains rect overflows svg element: <svg id='svg' width='10' height='10'> <rect x='-10' y='-10' width='30' height='30'/> </svg> chrome 28 , opera 12 return getboundingclientrect() svg element width , height of 10. firefox 23 reports width , height of 30. correct? jsfiddle the relevant spec cssom , delegates svg spec if svg element not "have associated css layout box". haven't found definition of "having associated css layout box", correct result seem hinge on definition, getbbox returns 30x30 rect in browsers. this firefox bug fixed now, fix in firefox nightlies , should make through firefox 33 released on 14 october 2014. see bug 530985 details.
Read more

gcc - Calling fftR4() in c from assembly -

-
i trying asm fft implementation www.embeddedsignals.com work. running make gives error: undefined reference fftr4(short*, short*, int) at top of asm have .syntax unified .thumb .global fftr4 .type fftr4, %function and there #define's associate c functions arguments registers followed macros fftr4 function uses. after that, fftr4 called .thumb_func fftr4: stmfd sp!, {r4-r11, lr} mov tmp0, #0 // bit reversed counter mov tmp1, #0 .word 0xf3a2fa92 //rbit r3,r2 //rbit r,n lsl r,#3 and c code follows: void fftr4(short *y, short *x, int n); short x[512]; short y[512]; int i; void loop() { (i=0;i<512;i++) x[i]=0; (i=0;i<512;i=i+8) { x[i+0]=16384; x[i+2]=16384; x[i+4]=-16384; x[i+6]=-16384;} fftr4(y, x, 256); serialusb.println(y[128]); serialusb.println(y[129]); serialusb.println(y[384]); serialusb.println(y[385]); // expected results: //y[128]is 8191; y[129] -8190 y[...
Read more

.htaccess - Matching full URL in RewriteCond -

-
i'm trying block post access site (and return 403), except 2 ip's , 1 url ( http://mydomain.com/about-us/contact-us/ ). here's have: rewritecond %{request_method} post rewritecond %{remote_addr} !=1.2.3.4 rewritecond %{remote_addr} !=4.3.2.1 rewritecond %{request_uri} !^http://mydomain.com/about-us/contact-us/$ rewriterule ^ / [f] these rules allowing access ip properly, contact page still not accessible. i'm not sure i'm using request_uri correctly? i've tried variations relative urls rewritecond %{request_uri} !^/about-us/contact-us$ , rewritecond %{request_uri} !^/about-us/contact-us/$ without luck. what doing wrong please? it looks me rule on file name specific. if relax bit, should work. made few other esthetic tweaks. give try: rewritecond %{request_method} post rewritecond %{remote_addr} !^1.2.3.4 rewritecond %{remote_addr} !^4.3.2.1 rewritecond %{request_uri} !about-us/contact-us rewriterule ^ - [f]
Read more