Solution for phpmyadmin.pma_table_uiprefs doesn’t exist
- Article
- Comment (15)
Solution for phpmyadmin.pma_table_uiprefs doesn’t exist. the below image explains you the error message completely.The error is ”
SELECT `prefs` FROM `phpmyadmin`.`pma_table_uiprefs` WHERE `username` = 'root' AND `db_name` = 'kvcodes_test' AND `table_name` = 'kvc0005_users' MySQL reports: #1146 - Table 'phpmyadmin.pma_table_uiprefs' doesn't exist
The images tells you more .
If you faced any such a error. just do the following steps, your problem will be solved. just find ” create_tables.sql ” , once you found the file, just open it, check whether the table name is correct or not. I think its ” pma__table_uiprefs ” . If the table name is changed, than open “C:/Xampp/phpmyadmin/ config.inc.php” . just change all the tables as like the create_table.sql file and save it.
Than come to your browser to check the tables. Now, it will allow you to get access the table contents. else, comment below, i will help you.
Hello,
I faced the issue and the naming looks correct, so I don’t think the issued comes from here.
My error message is :
The create_tables.sql shows:
and my phpmyadmin/config.inc.php shows the same naming:
I think the issue comes from the fact that I modified the mysql path on my mysql config (my.ini), but I don’t know where I should reflect that change in order to have everything working.
Any input ?
i think its config issue. so try configure the config.inc again.
Be carefull with the underscore in the name of the tables.
It will work for me.
just one, that’s the problem for me, I just have to modified the
for
in all the lines with these references and now is everithing worknig fine.
Thank you so much. That’s solved
sir…
then i change this file config.inc.php does not save tha chnages on my file.
you mean you can’t make the changes to save in it.
yes sir..
your file is denying the permission. check its property and make it writable by your username
I have error #1932 Table phpmyadmin.pma__tracking’ does not existing in engine but I do see that it’s there. I compared the create_tables.sql with the config.inc.php and they do look the same. Can’t I just delete that out of my phpmyadmin and have it recreate? I’ve been looking at this for over 12 hours now and trying everything. I have many client databases in my phpmyadmin so really need to figure this out.
Thank you!
Of course you can check it trail and error basis. Sometimes a small thing can’t be noted for long time. Just take a backup before making changes and testing. Hope you can get solution.
After many hours of searching for a solution to error #1932 – Table ‘phpmyadmin.pma__tracking’ doesn’t exist in engine.
I downloaded a very old version of XAMPP (xampp-win32-1.7.7-VC9.zip) SourceForge.net. I knew my original version was from 2012 so I was in luck. I think as long as it’s older it shouldn’t matter. Then MAKE SURE YOU BACKUP YOUR OLD XAMMP FOLDER BEFORE DELETING. XAMPP will tell you that the folder already exists and won’t install over it. I just renamed the XAMPP folder to XAMPP-OLD and made another copy of it just for my own security. I had been dealing with this issue for much over 12 hours because I had too many client databases to lose if I didn’t recover.
Then follow these instructions:
1) Shut down all instances of Apache and MySQL (if there are running any processes)
2) Proceed to the NEW installed Xampp folder, proceed to the mysql folder and rename the data folder to data-original (or similar)
3) Proceed to the BACKUP Xampp folder, proceed to thy mysql folder and copy the whole data folder from this BACKUP to the NEW Xampp folder (what results in replacing the original data folder by the backuped folder). DO NOT CUT&PASTE THE DATA FOLDER, COPY&PASTE IT!! Because this is your only valid backup.
4) Start the NEW Xampp installation and open http://localhost/phpmyadmin – it *should* show the old content of your backuped Xampp installation. If phpmyadmin fails to open, it might by necessary to copy&paste the configuration file config.inc.php from the backuped Xampp/Phpmyadmin folder to the new one (and reload http://localhost/phpmyadmin).
Hi Vicky
No need to get back to old version. Just follow the following steps: –
You have to run the create_tables.sql inside the examples/ folder on phpMyAdmin to create the tables needed for the advanced features.
Create table by importing the create_tables.sql file, you should go to the import tab on phpmyadmin and select that file, and click on Go button.
Now open xampp/phpMyAdmin/config.inc.php file and check in line no. 36-47 like pma_bookmark and other with pma_ . Replace pma__bookmark (__ this is double underscore). Save and then browser the table without any issue.
I did above steps in your article but still get error: “- Table ‘phpmyadmin.pma__tracking’ doesn’t exist in engine”
Your problem is different dude, looks like the table doesn’t exist. I am sorry, I have no idea about this issue, Because I never faced such an issue before
It worked. Thanks.