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 trialFrancesco Sollitto
2,454 PointsI HAVE ADDED THE PRIMARY KEY ON ID, WHY YOU KEEP REPEATING THE SAME BUMMER????
CREATE TABLE if not exists MEMBERS( id integer primary key autoincrement, first_name varchar(255), last_name varchar(255), favorite_rock_id integer references rocks(id) );
Francesco Sollitto
2,454 PointsI have tried all the combinations with and without variable type specification, inverting variables, primary and foreign key.
1 Answer
Steven Parker
231,110 PointsYour code looks good to me, so I tried pasting it directly into the challenge as a test and it passed.
Perhaps your browser has gotten into an odd state. Try restarting your browser.
Francesco Sollitto
2,454 PointsIndeed, now it works. Thank you
Steven Parker
231,110 PointsSteven Parker
231,110 PointsPlease show the complete query your are entering so we can take a look.