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.

Error from sql query: #42000

Discussion in 'Database Discussions' started by magicalwonders, Feb 18, 2014.

  1. magicalwonders

    magicalwonders Well-Known Member

    Joined:
    Nov 21, 2012
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    Hello folks,

    I'm running a VPS - CENTOS 6.5 x86_64 virtuozzo – WHM 11.40.1 (build 11).

    The VPS had to be rebuilt just over a week ago using a openvz template when malware was discovered on the server.

    The new VPS is clean, but there have been a few issues that needed reconfiguring. There seems to be one remaining concern. When I go into the cPanel of each account and click on the backup icon, it displays the following message at the top of the screen -

    ##################################################################
    Error from sql query: #42000: Can't find any matching row in the user tableError from sql query: #42000: Can't find any matching row in the user tableError from sql query: #42000: Can't find any matching row in the user tableError from sql query: #42000: Can't find any matching row in the user table
    ##################################################################

    This message appears in each cPanel account including those that don't have any MySQL databases created.

    I don't know much about cPanel, and the MySQL databases for Wordpress etc., seem to be working without issue, but I'm guessing this message is not normal?

    Screenshot attached.

    Can anybody suggest what may be causing this error message?

    Many thanks,

    Myles
     

    Attached Files:

  2. magicalwonders

    magicalwonders Well-Known Member

    Joined:
    Nov 21, 2012
    Messages:
    96
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Root Administrator
    I'm happy to report that this issue has now been fixed by my host. :) I'm not sure what actually caused the problem, but they were able to sort it out! :)
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,854
    Likes Received:
    676
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    I am happy to see the issue is now resolved. To note, I have seen this error in the past when the "skip-name-resolve" entry is added to the /etc/my.cnf file.

    Thank you.
     
Loading...

Share This Page