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!

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 Manipulating Schema with SQL Removing Databases

shen lei
shen lei
495 Points

Bug in Removing db Challenge Task?

Hi all, Have tried everything I can think of - no luck yet. Challenge task 1 answer is

drop database movie_db;

Instructions say to keep the code from Task 1 when adding answer to task 2, yielding:

drop database movie_db;
drop database movie_db if exists;

However, when running Task 2 - kicks back an error: "Task 1 is no longer parsing"... If Task 1 answer actually results in movie_db being dropped, then this makes sense... you're keeping a command to drop a database that no longer exists (without the 'if exists' conditional). However, if you answer Task 2 with only the conditional command, you still get the parsing error. Is this a bug? Any help much appreciated!