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
Andres Oliva
7,810 PointsError executing the query
As I execute the query:
SELECT * FROM movies;
I get two output lines on response column on the console, one says "Fetching..." and the other one has a red cross on it and says "Error: Error formatting SQL query: empty string given as argument for ! character"
I am currently running the MySQL Workbench 6.2.3.
Does anybody know why am I getting this error? (It gives back the exact same error message when querying actors)
Andres Oliva
7,810 PointsI don't know if you're in the exact same situation as me, but I was working on the project right after I installed the workbench. I restarted my computer and run the statement again, I only got an error that's fixed simply double clicking the database name "treehouse_movie_db" on the sidebar. Right now I am almost at the end of the course and I haven't had any more issues :)
Hope that helps!
Andres Oliva
7,810 PointsAlso, I am running MySQL on Mac OS X, make sure that you've started the server, it's in system preferences under "MySQL". You only need to click on "Start MySQL Server" and you're ready to go!
Kenneth Mentele
819 PointsIt worked for me after I double clicked on the database name like you suggested. Thanks Andres!
Kenneth Mentele
819 PointsKenneth Mentele
819 PointsI'm running into the same problem..