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

Development Tools Database Foundations Reading Data from Databases with SQL Retrieving a Result Set

Jack Dean
Jack Dean
5,772 Points

Is the following challenge buggy or am I doing something wrong?

I can't seem to pass the first challenge task:

"Write a SELECT statement that retrieves all "movies" with the "year" first and the "title" second."

I'm typing in:

SELECT movies.year, movies.title FROM movies;

Can't see what I'm doing wrong here…?

This seems to be a bug, I have been having the same errors.

http://teamtreehouse.com/library/database-foundations/reading-data-from-databases-with-sql/retrieving-a-result-set

Answer: SELECT year, title FROM movies;

Error: Bummer! The ordering of your columns is incorrect. Check the order and try again. SQL Error: Table 'mysql_e610f52e_e1b3_4bfe_8434_a80c0ad45db3_cc_db.movies' doesn't exist

6 Answers

Hi Jack,

Your code looks correct to me. Just tried it and it's producing an error for me too.

Also tried this just in case:

SELECT year, title FROM movies;

Andrew Chalkley might be able to confirm in case we're missing something obvious.

-Rich

Jack Dean
Jack Dean
5,772 Points

Thanks, I'm glad it's not just me!

Hey Rich,

i tried your solution and it worked perfectly, this one: SELECT year, title FROM movies;

Jack Dean
Jack Dean
5,772 Points

It seems some of the other challenges ahead don't work correctly either, and there are a couple of questions from others about it posted there from a few months ago! It looks the problem eventually resolves itself judging from some of the comments ahead. Still, I'm surprised no one official at Team Treehouse has responded to any of these questions or even acknowledged the bug.

Kam Mitchell
Kam Mitchell
14,073 Points

Yup! I just ran into this issue as well and after submitting it over and over it finally went through...

However I now have this issue again with http://teamtreehouse.com/library/database-foundations/reading-data-from-databases-with-sql/ordering-the-result-set and it is not going through no matter how many times I submit the correct code...

Jack Dean
Jack Dean
5,772 Points

Ah it just worked for me too after hitting try again about 5 times. Good tip, thanks!

Just came to report the same issue. Glad I am not the only one.

Jack Dean
Jack Dean
5,772 Points

I can confirm that Kam's solution of just hitting 'try again' and 'enter' over and over does eventually seem to work.

Edit: Well it worked briefly, didn't save my progress, and now it doesn't work at all...

Mine is not going through. Now getting too many connections errors

Jack Dean
Jack Dean
5,772 Points

Yeah same, oh well...

Kam Mitchell
Kam Mitchell
14,073 Points

this is the most aggravating thing that has happened to me on Team Treehouse lol