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 trialJack Dean
5,772 PointsIs 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…?
6 Answers
Rich Bagley
25,869 PointsHi 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
5,772 PointsThanks, I'm glad it's not just me!
MUZ140146 Warrant Ganye
7,120 PointsHey Rich,
i tried your solution and it worked perfectly, this one: SELECT year, title FROM movies;
Jack Dean
5,772 PointsIt 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.
Alex Berk
3,709 PointsYes, it appears that the issue is with 3 of the section's challenges:
Kam Mitchell
14,073 PointsYup! 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
5,772 PointsAh it just worked for me too after hitting try again about 5 times. Good tip, thanks!
Brandon Meredith
29,350 PointsJust came to report the same issue. Glad I am not the only one.
Jack Dean
5,772 PointsI 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...
Brandon Meredith
29,350 PointsMine is not going through. Now getting too many connections errors
Jack Dean
5,772 PointsYeah same, oh well...
Kam Mitchell
14,073 Pointsthis is the most aggravating thing that has happened to me on Team Treehouse lol
Alex Berk
3,709 PointsAlex Berk
3,709 PointsThis 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