Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Python Using Databases in Python Meet Peewee Queries Are Your Friend

Posted by kangweichen
kangweichen
7,727 Points

Getting an Operational Error

Copied from the project file "students.py" Tried running it on the launch workspace, but kept getting the error:

peewee.OperationalError: table student has no column named username

Could anyone tell me how to fix it? Thanks!

2 Answers

beven nyamande
beven nyamande
9,575 Points
beven nyamande
beven nyamande
9,575 Points

try python student.py

Dean Vollebregt
Dean Vollebregt
24,583 Points
Dean Vollebregt
Dean Vollebregt
24,583 Points

Had this same problem running my code externally on sublime, I deleted the database named students.db then ran the teachers code and it worked fin. I know this question was over a year ago, just looking to help other users.