1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Trying to create pmadb... ERROR 1047 at line 31: Unknown command

Discussion in 'Plesk for Linux - 8.x and Older' started by ian.foulds, Jul 6, 2005.

  1. ian.foulds

    ian.foulds Guest

    For any of you poor souls who are experiencing a totally dreadful time trying to update to 7.5.3, here is the solution to errors I have experienced.

    During the installation of psa I received the error: "Trying to create pmadb... ERROR 1047 at line 31: Unknown command"

    After several hours of debugging install scripts and rebuilding rpms I tracked this down to a GRANT command when trying to build the phpMyAdmin database.

    The reason was that 'skip-grant-tables' had been included in /etc/my.cnf to resolve some other issues elsewhere, I removed it, restarted mysqld, and it worked. This can also be achieved by putting a "FLUSH PRIVILEGES;" in the install script just to make sure but SW-Soft didn't bother!!!

    FYI the catalogue of errors I have encountered upgrading from 7.5.2 to 7.5.3 as as follows:

    1. "Database integrity check failed: duplicate values of (action_id, component) exist in table log_components"
    The data in psa.log_components was saved and deleted as suggested in some other forum posts.

    2. "Table 'psa.ControlVisibility' doesn't exist"
    Ran a script to convert tables frorm mySQL to InnoDB format - see posting "Urgent - Failed Upgrade to 7.5.3" for details.

    3. "Trying to create pmadb... ERROR 1047 at line 31: Unknown command"
    See above for a solution.

    SW-Soft please note - ALL these errors, and I do mean ALL, could have been prevented by by better testing and better installation scripts. Your ineptitude has cost me a lot of time and aggrevation.