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

Aamir Mirza
Aamir Mirza
15,506 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!