The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL Upgrade error message

Discussion in 'Database Discussions' started by samehhosny, Aug 23, 2014.

  1. samehhosny

    samehhosny Registered

    Joined:
    Aug 17, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello,

    I have centos OS with WHM 11.42 version installed on my VPS server. Last few days, I got an error message regarding connection to my MySQL database from all of my wordpress sites. I solved the problem each time it happened by doing a graceful restart to my server after I noticed that the MySQL service is not running. I noticed that this error is not appearing anymore which is good.
    Now, my problem is in the WHM mySQL upgrade section. I get this message every time I click on MySQL Upgrade
    Code:
    [B]"file error - parse error - mysqlupgrade/mysqlupgrade-inprogress.tmpl line 1-10: unexpected token (SET) [% PROCESS '_defheader.tmpl' header = 'MySQL Upgrade' breadcrumburl = '/scripts/mysqlupgrade' SET upgrade_types = { unattended_automatic = locale.maketext('Unattended Upgrade'), unattended_manual = locale.maketext('Partially-Interactive Upgrade'), interactive = locale.maketext('Interactive Upgrade') } %]"
    [/B]
    
    I tried to find out my searching other threads without any luck to find a solution for this issue.

    Hope to get a solution here for my issue.

    Thanks and have a great day.

    Sameh Hosny
     
  2. corporatehost

    corporatehost Member

    Joined:
    Jul 17, 2014
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi Samehhosny,

    Can you please let us know the steps to reproduce this issue ?

    We have many servers were i never seen this error during mysql upgrade. What was the current mysql server version ? and to what version do you upgrade to ?
     
  3. samehhosny

    samehhosny Registered

    Joined:
    Aug 17, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    First, Thank you for your reply.
    The error message comes up once I clicked the mySQL upgrade button in WHM interface. I attached screenshot of the error message. 2014-08-24_000533.png

    MySQL server version: 5.6.17

    I don't know if this is the latest version or not but at least I should get a message other than this error message.

    Thank you again for your prompt reply.
     
  4. corporatehost

    corporatehost Member

    Joined:
    Jul 17, 2014
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hi
    samehhosny,

    Strange. At this moment, I recommend you to post a ticket to cPanel support team. Someone from cPanel support should be able to fix the issue.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  6. datawave

    datawave Registered

    Joined:
    Apr 7, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Hi,

    I have the same problem. I ran the script as suggested without success. Still receiving the same error.

    Is there any further steps I can try?
     
  7. datawave

    datawave Registered

    Joined:
    Apr 7, 2011
    Messages:
    4
    Likes Received:
    0
    Trophy Points:
    1
    Part of a ticket I had with Cpanel Support:
    -------------------------------------------------
    I don't currently have access to this server, but from what you've described, you accidentally aborted the MySQL Upgrade by clicking the Load Average link. By doing this, the upgrade stopped and the MySQL Upgrade lockfile was not removed.

    If you have SSH access, can you run the following command?
    # mv /var/cpanel/mysql_upgrade_in_progress /root

    And then try the MySQL Upgrade again?
    --------------------------------------------

    This solved my problem :)
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page