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!
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
Aamir Mirza24,819 Points
phpMyAdmin error - #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
I've downloaded the shirts4mike.sql file and copy & pasted it into MyAdmin to create the MySQL database, but when I try to select the "products" table in the shirts4mike database, I get the error -
1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
Apparently, this seems to be the problem code:
SELECT `prefs` FROM `phpmyadmin`.`pma_table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'shirts4mike' AND `table_name` = 'products'
I don't know where the line of code comes from (it doesn't seem to come from shirts4mike.sql), but I have the ability to edit it. Anyone know how to fix this?