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....

It's saying that the index (position) you are accessing doesn't exist. — Ramchandra Apte
– Ramchandra Apte, Commented Nov 30, 2013 at 3:34
I don't know; could you provide a small self-contained reproducible example and edit your question to include that. — Ramchandra Apte
– Ramchandra Apte, Commented Nov 30, 2013 at 3:46
You should try to print(rows) and print(rows[1]) to see what your data looks like. It may help you finding your problem. — Soravux
– Soravux, Commented Nov 30, 2013 at 3:54
was getting this error when i changed train_sizes=np.linspace(0.1, 1.0, 10) to just train_sizes=10 — Mr-Programs
– Mr-Programs, Commented Feb 20, 2020 at 22:21

Rcheologist · Accepted Answer · 2021-06-22 21:51:05Z

69

Probably one of the indices is wrong, either the inner one or the outer one.

I suspect you meant to say [0] where you said [1], and [1] where you said [2]. Indices are 0-based in Python.

edited Jun 22, 2021 at 21:51

Rcheologist

3232 silver badges15 bronze badges

answered Nov 30, 2013 at 20:28

glglgl

91.5k13 gold badges157 silver badges230 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

amr Over a year ago

I was getting this message because I was passing an array to a function that was expecting a variadic sequence of arguments (eg '{}{}'.format([1,2]) vs '{}{}'.format(*[1,2])

Dror Over a year ago

another situation was accidentally having two '{}' inside the string, while only one variable/value in the .format()

Seldom 'Where's Monica' Needy Over a year ago

If you have a misplaced assignment-operator (=) in an argument-list, that's another cause for this one. I had shuffled some code around and wound up with that.

cfi Over a year ago

...and as a variant to Dror's comment: Having {} inside a format string instead of {{}}. This is a typical copy&paste error when someone wants to literally print a pair of curly braces.

Pyd Over a year ago

I am also getting the same error, can you check stackoverflow.com/questions/46945860/…

|

Sai prateek · Accepted Answer · 2020-01-04 20:17:02Z

5

A tuple consists of a number of values separated by commas. like

>>> t = 12345, 54321, 'hello!'
>>> 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.

answered Jan 4, 2020 at 20:17

Sai prateek

11.9k10 gold badges56 silver badges67 bronze badges

Comments

delaflota · Accepted Answer · 2021-08-31 20:38:28Z

0

I received the same error with
query = "INSERT INTO table(field1, field2,...) VALUES (%s,%s,...)"
but in the statement
cursor.execute(query, (field1, field2,..)
I had delivered less variables as necessary...
In this case I used

import mysql.connector as mysql

I just wanted to say that this is also possible...not only in arrays
(I didn't have a very close look at this specific case...)

answered Aug 31, 2021 at 20:38

delaflota

1791 gold badge3 silver badges13 bronze badges

Comments

Ankit Singh · Accepted Answer · 2019-10-27 02:40:14Z

-1

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.

answered Oct 27, 2019 at 2:40

Ankit Singh

9121 gold badge9 silver badges17 bronze badges

Collectives™ on Stack Overflow

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

4 Answers 4

6 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related