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 Modifying Data with SQL Adding Data to a Database Adding Data With SQL

What does this error mean: Bummer: Was expecting 7 entries in the phone_book table. There's only 6.

I keep getting this error but it's extremely unhelpful in diagnosing my issue.

Travis Alstrand
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Data Analysis Techdegree Graduate 49,443 Points

Hey zaal rottunda !

If you could provide your code that you're trying and which of the three parts of the challenge you're stuck on that would be extremely helpful!

7 Answers

Travis Alstrand
seal-mask
.a{fill-rule:evenodd;}techdegree seal-36
Travis Alstrand
Data Analysis Techdegree Graduate 49,443 Points

I believe the issue is that the program is expecting the new row to be added to the table and it's not, so it's saying "there should now be 7 entries and there's still only 6".

Be sure to have everything typed out correctly

INSERT INTO phone_book (first_name, last_name, phone)
VALUES (
  "taco",
  "man",
  5555555555
);

Update phone_book Set first_name="Mystery" AND last_name="Person";

All it's asking me to do is run an SQL update to a table, the prompt before this was the same with only one entry and was giving me the same error until I refreshed the page and pasted my copied code and it accepted?

Challenge Task 2 of 2 Now we're using a database from a smartphone. It has a phone_book table. It has the columns id, first_name, last_name and phone.

Update all contacts to have the first name of "Mystery" and last name of "Person".

Type in your command below, then press Ctrl-Enter.

Update phone_book Set first_name="Mystery" AND last_name="Person";

Bummer: Was expecting 6 entries in the phone_book with the updated name. There's only 0.

nevermind, I just kept refreshing and entering and it eventually took lol