getting error while performing a simple code here...

[Krishnamishi123]

self.var_post.set(row[4]), IndexError: string index out of range
Exception in Tkinter callback

here is the code: self.var_ref.set(row[0]), self.var_name.set(row[1]), self.var_guard.set(row[2]), self.var_gender.set(row[3]), self.var_post.set(row[4]), self.var_mobile.set(row[5]), self.var_email.set(row[6]), self.var_nation.set(row[7]), self.var_idproof.set(row[8]), self.var_idnum.set(row[9]), self.var_address.set(row[10]) im setting details into mysql workbench

one more error im getting like: mysql.connector.errors.DataError: 1292 (22007): Truncated incorrect DOUBLE value: 'I

here is the code: mycursor.execute("update customer set name=%s,guard=%s,gender=%s,post=%s,mobile=%s,email=%s,nation=%s,idproof=%s,idnum=%s,address=%s where ref=%s",(

                                                                                                                                                        self.var_name.get(),
                                                                                                                                                        self.var_guard.get(),
                                                                                                                                                        self.var_gender.get(),
                                                                                                                                                        self.var_post.get(),
                                                                                                                                                        self.var_mobile.get(),
                                                                                                                                                        self.var_email.get(),
                                                                                                                                                        self.var_nation.get(),
                                                                                                                                                        self.var_idproof.get(),
                                                                                                                                                        self.var_idnum.get(),
                                                                                                                                                        self.var_address.get(),
                                                                                                                                                        self.var_ref.get()

                                                                                                                                                       ))

Expected behaviour

Tell us what should happen

Actual behaviour

Tell us what happens instead

Log

Please copy paste the log here if available