Solution for phpmyadmin.pma_table_uiprefs doesn't exist
X

Congrats, You are Subscribed to Receive Updates.

Solution for phpmyadmin.pma_table_uiprefs doesn’t exist


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 .

error_screenshot

 

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.

 

commenter

About Varadharaj V

The founder of Kvcodes, Varadharaj V is an ERP Analyst and a Web developer specializing in WordPress(WP), WP Theme development, WP Plugin development, Frontaccounting(FA), Sales, Purchases, Inventory, Ledgers, Payroll & HRM, CRM, FA Core Customization, OpenCart Theme Development, PHP, HTML, CSS, jQuery, Bootstrap development and content SEO.

12 comments

  1. commenter

    Hello,

    I faced the issue and the naming looks correct, so I don’t think the issued comes from here.
    My error message is :

    #1146 - Table 'phpmyadmin.pma__table_uiprefs' doesn't exist 
    

    The create_tables.sql shows:

    CREATE TABLE IF NOT EXISTS `pma__table_uiprefs`   (same naming)
    

    and my phpmyadmin/config.inc.php shows the same naming:

    $cfg['Servers'][$i]['table_uiprefs'] = 'pma__table_uiprefs';

    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 ?

  2. commenter

    Be carefull with the underscore in the name of the tables.
    It will work for me.

    nano /etc/phpmyadmin/config.inc.php
    .... 
    $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';  # the original was 2 underscores
    ...
    
    but in usr/usr_/share/doc/phpmyadmin/examples/create_tables.sql.gz 
    ...
    --
    -- Table structure for table `pma_recent`
    --
    
    CREATE TABLE IF NOT EXISTS `pma_recent` (
      `username` varchar(64) NOT NULL,
      `tables` text NOT NULL,
      PRIMARY KEY (`username`)
    )
      ENGINE=MyISAM COMMENT='Recently accessed tables'
      DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
    
    -- --------------------------------------------------------
    .....
    

    just one, that’s the problem for me, I just have to modified the

    $cfg['Servers'][$i]['bookmarktable'] = 'pma__bookmark';  # the original was 2 underscores
    

    for

     
    $cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';  # the new 1 underscore
    

    in all the lines with these references and now is everithing worknig fine.

  3. commenter

    Thank you so much. That’s solved

  4. commenter

    sir…
    then i change this file config.inc.php does not save tha chnages on my file.

  5. commenter

    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!

    • commenter

      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.

  6. commenter

    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).

  7. commenter

    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.

Comment Below

Your email address will not be published. Required fields are marked *

*

Current ye@r *

Menu

Sidebar

Subscribe E-mail Updates

Congrats, You are Subscribed to Receive Updates.

Advertisement

Category Posts