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

Yvette Alasti
Yvette Alasti
17,589 Points

Null Challenge 1 not working

Is anyone else having a problem with this? I think it has a bug. My answer is : SELECT * FROM movies WHERE year IS NULL;

jeremie marichal
jeremie marichal
5,009 Points

i get this problem too !

this is in the result box: 3c373f4f-7888-412e-942c-cea9288fc15f.rb:345:in abandon_results!': Column count doesn't match value count at row 1 (Mysql2::Error) from 3c373f4f-7888-412e-942c-cea9288fc15f.rb:345:in'

2 Answers

Tobias Edwards
Tobias Edwards
14,458 Points

https://teamtreehouse.com/forum/dealing-with-null-challenge-cant-get-past-this-one-bummer

This links to a similar problem. It seems to be a problem with the actual database, not your code.

Someone has already contacted Treehouse, so for now, just skip the challenge and come back to it later.

Erik Myers
Erik Myers
11,582 Points

Everything works fine now, though I did experience some delay when submitting my answers (1-5 seconds).