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
christopherhycner
8,402 PointsDatabase Foundations > Creating Tables quiz issue
Sorry for not directly linking this from the quiz, but there was not an option to create forum discussion on the quiz.
So there seems to be an issue in the parser that may require you to completely close the quiz instance and restart to be able to move onto step 2. If you put incorrect code that is enough to create the table in step 1, it will give an appropriate error "Wrong number of columns in table":
CREATE TABLE movies (title VARCHAR(255));
or
CREATE TABLE movies (title VARCHAR(255), INTEGER year);
or
etc.
However, if you then input the correct text it will give you an error message since you are still in the same instance, "table movies already exists":
CREATE TABLE movies (title VARCHAR(255), year INTEGER);
This could be very confusing/frustrating for someone who doesn't realize that they need to restart the quiz to be able to use the correct text.
James Barnett - I would imagine this isn't something that chalkers could change since it seems like more of a structural issue, but I'm not sure who else this should go to. Could you help refer this to the appropriate person? Thanks!
1 Answer
Andrew Chalkley
Treehouse Guest TeacherYeah - this is on our radar to fix. Currently the quick fix is to refresh the page and type in the correct SQL query as it wipes the temporary database.
I'll also raise an issue re posting questions from SQL Code challenges in our dev support ticket system.
James Barnett
39,199 PointsJames Barnett
39,199 Points>Sorry for not directly linking this from the quiz, but there was not an option to create forum discussion on the quiz.In that case you can just edit your post to include the link to the quiz page.
>I would imagine this isn't something that chalkers could change since it seems like more of a structural issue, but I'm not sure who else this should go to.In cases like these teachers usually tag the relevant developer.
//cc: Andrew Chalkley