IndexError tuple index out of range ----- Python

Question

Please Help me  I m running a simple python program that will display the data from mySQL database in a tkinter form     from Tkinter import   import MySQLdb  def button click        root destroy    root   Tk   root geometry  600x500 10 10   root title  Ariba    myContainer   Frame root  myContainer pack side TOP  expand YES  fill BOTH   db   MySQLdb connect   localhost   root      chocoholics   s    Select   from member  cursor   db cursor   cursor execute s  rows   cursor fetchall    x   rows 1  1          rows 1  2  myLabel1   Label myContainer  text   x  y   rows 2  1          rows 2  2  myLabel2   Label myContainer  text   y  btn   Button myContainer  text    Quit   command button click  height 1  width 6   myLabel1 pack side TOP  expand NO  fill BOTH  myLabel2 pack side TOP  expand NO  fill BOTH  btn pack side TOP  expand YES  fill NONE    Thats the whole program      The error was   x   rows 1  1          rows 1  2  IndexError  tuple index out of range  y   rows 2  1          rows 2  2  IndexError  tuple index out of range   Can anyone help me    im new in python   Thank you so much

User · Accepted Answer

Probably one of the indexes is wrong  either the inner one or the outer one   I suspect you mean to say  0  where you say  1  and  1  where you say  2   Indexes are 0-based in Python

User · Answer

This is because your row variable tuple does not contain any value for that index  You can try printing the whole list like print row  and check how many indexes there exists

User · Answer

A tuple consists of a number of values separated by commas  like   gt  gt  gt  t   12345  54321   hello    gt  gt  gt  t 0  12345   tuple are index based  and also immutable  in Python   Here in this case x   rows 1  1          rows 1  2  have only two index 0  1 available but you are trying to access the 3rd index

[python] IndexError: tuple index out of range ----- Python

Examples related to python

Examples related to python-2.7

Examples related to mysql-python