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

Development Tools Using PHP with MySQL Connecting PHP to MySQL Creating the Products Table

Aamir Mirza
Aamir Mirza
25,077 Points
Posted by Aamir Mirza
Aamir Mirza
25,077 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?

Thanks!