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

Databases Creating and Modifying Database Tables Creating and Modifying Database Tables Creating a Table

Daniele Fusari
Daniele Fusari
40,669 Points
Posted by Daniele Fusari
Daniele Fusari
40,669 Points

CREATE 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
Steven Parker
231,272 Points
Steven Parker
Steven Parker
231,272 Points

Your 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.

Steven Parker
Steven Parker
231,272 Points
Steven Parker
Steven Parker
231,272 Points

UPDATE — it looks like the bug has been fixed, try it now.