PHPMyAdmin 'database_name.pma_tracking' doesn't exist

HowardE

• March 17, 2021 14:56

I recently imported an sql file to a client database using the command line. This database apparently had some tables .pma_ etc... I removed this database, and now phpMyAdmin as Root doesn't work right. Every click gets me errors showing I can use PHPMyAdmin as a user under their cpanel, but when I use the WHM Root phpmyadmin, i get only this error. I didn't want to re-install this other database as a solution. Everything I've found online suggests re-installing the \phpMyAdmin\sql but I didn't find anything specific to WHM/cPanel. Any help would be appreciated. Thanks.

• 

  cPRex Jurassic Moderator

  • March 17, 2021 20:33

  Hey there! I'd start with the following before trying any deeper changes: rpm -e --nodeps cpanel-phpmyadmin /scripts/check_cpanel_rpms
  You will need to push "y" to confirm the RPM reinstall while the second command runs. Can you try that and see if that gets things working?

  0
• 

  HowardE

  • March 17, 2021 21:56

  Hi, thanks for the answer. Unfortunately, that didn't change anything. /scripts/check_cpanel_rpms [2021-03-17 17:50:35 -0400] [2021-03-17 17:50:35 -0400] Problems were detected with cPanel-provided files which are RPM controlled. [2021-03-17 17:50:35 -0400] If you did not make these changes intentionally, you can correct them by running: [2021-03-17 17:50:35 -0400] [2021-03-17 17:50:35 -0400] > /usr/local/cpanel/scripts/check_cpanel_rpms --fix [2021-03-17 17:50:35 -0400] The following RPMs are missing from your system: [2021-03-17 17:50:35 -0400] cpanel-phpmyadmin-4.9.5-1.cp1186 Do you want to repair these RPMs?(y/n): y [2021-03-17 17:51:20 -0400] Removing 0 broken rpms: [2021-03-17 17:51:20 -0400] rpm: no packages given for erase [2021-03-17 17:51:20 -0400] Maximum sync children set to 16 based on 21545M available memory. [2021-03-17 17:51:20 -0400] Downloading http://httpupdate.cpanel.net/RPM/11.86/centos/7/x86_64/rpm.sha512 [2021-03-17 17:51:27 -0400] Successfully verified signature for cpanel (key types: release). [2021-03-17 17:51:27 -0400] Maximum sync children set to 16 based on 21403M available memory. [2021-03-17 17:51:27 -0400] Downloading http://httpupdate.cpanel.net/RPM/11.86/centos/7/x86_64/cpanel-phpmyadmin-4.9.5-1.cp1186.noarch.rpm [2021-03-17 17:51:28 -0400] Disabling service monitoring. [2021-03-17 17:51:28 -0400] Hooks system enabled. [2021-03-17 17:51:28 -0400] Checking for and running RPM::Versions 'pre' hooks for any RPMs about to be installed [2021-03-17 17:51:28 -0400] All required 'pre' hooks have been run [2021-03-17 17:51:29 -0400] No RPMS need to be uninstalled [2021-03-17 17:51:29 -0400] Installing new rpms: cpanel-phpmyadmin-4.9.5-1.cp1186.noarch.rpm [2021-03-17 17:51:29 -0400] Preparing packages... [2021-03-17 17:51:29 -0400] cleaning up old phpmyadmin before installing new one. [2021-03-17 17:51:29 -0400] We only do this the first time we install the cpanel-phpmyadmin RPM [2021-03-17 17:51:29 -0400] cpanel-phpmyadmin-4.9.5-1.cp1186.noarch [2021-03-17 17:51:35 -0400] Releasing lock for Cpanel::RPM::Versions::File [2021-03-17 17:51:35 -0400] Hooks system enabled. [2021-03-17 17:51:35 -0400] Checking for and running RPM::Versions 'post' hooks for any RPMs about to be installed [2021-03-17 17:51:35 -0400] All required 'post' hooks have been run [2021-03-17 17:51:35 -0400] Restoring service monitoring.
  The Error is still the same though

  0
• 

  cPRex Jurassic Moderator

  • March 17, 2021 22:00

  I was hoping that would do it! I don't have a guide handy for rebuilding the internal PHPMyAdmin tables, so it might be best to submit a ticket to our team to do some additional research on that behavior.

  0

Please sign in to leave a comment.