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 trialzaal rottunda
Courses Plus Student 2,434 PointsWhat 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.
7 Answers
Travis Alstrand
Data Analysis Techdegree Graduate 49,443 PointsI 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
);
zaal rottunda
Courses Plus Student 2,434 PointsUpdate phone_book Set first_name="Mystery" AND last_name="Person";
zaal rottunda
Courses Plus Student 2,434 PointsAll 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?
zaal rottunda
Courses Plus Student 2,434 PointsChallenge 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.
zaal rottunda
Courses Plus Student 2,434 PointsUpdate phone_book Set first_name="Mystery" AND last_name="Person";
zaal rottunda
Courses Plus Student 2,434 PointsBummer: Was expecting 6 entries in the phone_book with the updated name. There's only 0.
zaal rottunda
Courses Plus Student 2,434 Pointsnevermind, I just kept refreshing and entering and it eventually took lol
Travis Alstrand
Data Analysis Techdegree Graduate 49,443 PointsTravis Alstrand
Data Analysis Techdegree Graduate 49,443 PointsHey 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!