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 Manipulating Schema with SQL Altering Tables

TRUNCATE TABLE movies; Last step in the Altering Tables challenge. Can't get it to work??

Last step in the Altering Tables challenge. Can't get it to work??

Tried TRUNCATE TABLE movies; TRUNCATE movies;

Just keep getting "Bummer"

13 Answers

Oziel Perez
Oziel Perez
61,321 Points

I submitted a message to Support on saturday. They still haven't changed anything. Either they're forgetting or the problem is more complex than they thought

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

Yvette Alasti
Yvette Alasti
17,589 Points

I am getting the same error, I think there is a bug. My answer is: TRUNCATE TABLE movies;

joel bindi
joel bindi
11,923 Points

Me too, tried

TRUNCATE TABLE movies;

and

TRUNCATE movies;

Was driving me crazy!

joel bindi
joel bindi
11,923 Points

Me too, tried

TRUNCATE TABLE movies;

and

TRUNCATE movies;

Was driving me crazy!

"Database Foundations" challenges are now working!!!

KAZUYA NAKAJIMA
KAZUYA NAKAJIMA
8,851 Points

input TRUNCATE TABLE movies

and keep returning

Oh no! There was a temporary issue running this code challenge. We've been notified and will investigate the problem.

If you continue experiencing problems, please contact support at help@teamtreehouse.com.

Jay McGavren
STAFF
Jay McGavren
Treehouse Teacher

We were having an issue with our MySQL code challenges over the weekend. The code that was responsible has been rolled back, and things seem to be working now. If anyone continues to experience problems, please let us know at help@teamtreehouse.com . Sorry for the trouble!

TRUNCATE TABLE movies;...................... THIS SHOULD WORK GUYS. JUST TRY IT

DATABASE FOUNDATIONS / SQL

Challenge Task 1 of 4

Rename the "actors" table to "t_actor".

RENAME TABLE actors to t_actor;

Challenge Task 2 of 4

Rename in one SQL statment both the "t_movie" table to "movies" and the "t_actor" table to "actors".

RENAME TABLE t_movie to movies, t_actor to actors

Challenge Task 3 of 4

Remove the "actors" table from the database.

DROP TABLE actors;

Challenge Task 4 of 4

Truncate the "movies" table.

TRUNCATE table movies;

Same error here

Oziel Perez
Oziel Perez
61,321 Points

ok good I'm not the only one, Yeah I'm getting this bug as well.

Ieva Salte
Ieva Salte
15,356 Points

still have a bug and not working

Yes, it is still not working.