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 Dealing with NULL

Posted by Bruce Berdine
Bruce Berdine
13,607 Points

Dealing with NULL Challenge Can't get past this one.... Bummer

Tried SELECT * FROM movies WHERE year IS NULL; and SELECT * FROM movies WHERE year IS NULL OR year='';

Just keep getting "Bummer" What am I doing wrong?

Adam Haley
Adam Haley
7,792 Points
Adam Haley
Adam Haley
7,792 Points

I am also getting an error: 8f943377-1d48-4d7d-acaa-04361a8354b0.rb:345:in `abandon_results!': Column count doesn't match value count at row 1 (Mysql2::Error) from 8f943377-1d48-4d7d-acaa-04361a8354b0.rb:345:in

when running: "select * from movies where year is null;" The same query works from MySQL workbench.

How do I skip this challenge?

Bruce Berdine
Bruce Berdine
13,607 Points

Hey Adam,

You can just use the arrow at top right to move on to the next section.

I have contacted support and will update here when I get a reply.

Jonathan Dueck
Jonathan Dueck
4,596 Points
Jonathan Dueck
Jonathan Dueck
4,596 Points

I think this is still buggy, though i didn't get an "error" message. There's one task that demonstrates you know how to make text disappear when a condition is false -- and that worked. However, the following task is to make the text reappear by making the condition true. It works in the preview, but when you check your answer you get Bummer! and are given the option to go back to task three.

8 Answers

Bruce Berdine
Bruce Berdine
13,607 Points

I contacted support...

Hi there,

Thanks for reaching out to us about this. We apologize for the inconvenience that this may have caused you. We're aware of this quiz bug and our developers are looking into it. If you have any other issues or questions, please let us know. We greatly appreciate your patience!

Best, Treehouse Support

Cesar Marroquin
Cesar Marroquin
10,520 Points
Cesar Marroquin
Cesar Marroquin
10,520 Points

It seems to be a bug because that would be the correct way to select it. I had trouble with another code challenge in databases as well, where i used the same code in the video for the same problem in the challenge but it wouldnt work.

Cesar Marroquin
Cesar Marroquin
10,520 Points

If you look at the error its not an error about your code but about the actual database

Bruce Berdine
Bruce Berdine
13,607 Points

Thanks Cesar,

Think you are right. I am having issues with some of the other challenges in this section as well.

Luckily, I think it is optional so I will be able to continue my track without answering these.

Thanks again for the response!!!

kabir k
PLUS
kabir k
Courses Plus Student 18,036 Points
kabir k
kabir k
Courses Plus Student 18,036 Points

Actually, it works. I believe they are looking for a different way of writing the query for the second Challenge question.

If you write it as shown in the video,

SELECT * FROM movies WHERE year IS NOT NULL ORDER BY year;

it will not pass. But if you write it simply without the ORDER BY year part, like so:

SELECT * FROM movies WHERE year IS NOT NULL;

it will pass.

Hope this helps.

Jade Briggs
Jade Briggs
16,714 Points
Jade Briggs
Jade Briggs
16,714 Points

I am having the same issue. The answer is correct but it throws an error. Sometimes it will let me complete the first part of the challenge and sometimes it throws an error even though the answer is exactly the same. Here is one of the errors:

52ac2322-faee-400f-8823-9ed4b4f035e6.rb:345:in `abandon_results!': Column count doesn't match value count at row 1 (Mysql2::Error) from 52ac2322-faee-400f-8823-9ed4b4f035e6.rb:345:in `
Jade Briggs
Jade Briggs
16,714 Points
Jade Briggs
Jade Briggs
16,714 Points

I think I found a way to get it to work.

If you let the page sit for 5 minutes after it has shown the error, then come back to it and hit the 'Enter' key a couple times, it will resubmit the answer and accept it this time. Hopefully that works for you.

Bruce Berdine
Bruce Berdine
13,607 Points

Thanks Jade,

Didn't work for me. I contacted support but from what I saw in the forum they may be aware of the problem already.

Thanks again!!

Bruce Berdine
Bruce Berdine
13,607 Points
Bruce Berdine
Bruce Berdine
13,607 Points

"Database Foundations" challenges are now working!!!

Jade Briggs
Jade Briggs
16,714 Points
Jade Briggs
Jade Briggs
16,714 Points

Thanks for following up with support Bruce!

Craig Kuriger
Craig Kuriger
37,104 Points
Craig Kuriger
Craig Kuriger
37,104 Points

Question 2 of this challenge is still not working...