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 trialDaniele Fusari
40,669 PointsCREATE TABLE MEMBERS (ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK)
Just spend 30 trying to solve this. Watched the video over again. Can't see the error, can help ?
We're starting a rock collectors club! Can you create a 'members' table with the following columns: id, first_name, last_name, and favorite_rock. Also, make sure we only allow unique ids.
CREATE TABLE MEMBERS ( ID PRIMARY KEY, FIRST_NAME, LAST_NAME, FAVORITE_ROCK)
Bummer: SQL Error: UNIQUE constraint failed: MEMBERS.ID
1 Answer
Steven Parker
231,184 PointsYour code looks OK to me, and I've seen at least five other folks with the same exact issue in the last few days.
I suspect there's a problem with the validation system and you may need to ask for assistance from the Support folks.
Daniele Fusari
40,669 PointsDaniele Fusari
40,669 PointsTHANKS STEVEN
Steven Parker
231,184 PointsSteven Parker
231,184 PointsUPDATE — it looks like the bug has been fixed, try it now.