Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Losing cpses after query?

Discussion in 'Database Discussion' started by Rdubya, Apr 15, 2014.

  1. Rdubya

    Rdubya Registered

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

    We have just started to receive this error: (the only change we know from when it was working to not working is an SSL install)

    "Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1449 The user specified as a definer ('cpses_res####'@'localhost') does not exist' in ...."

    What makes this very strange is that some queries do run, but eventually in the script it shoots out that error.
    Nothing changes the database connection between queries.

    I don't know what the heck is occuring between queries to cause this. There is nothing in the script that has changed from yesterday when it was working.

    Any information would be greatly appreciated.

    Thank you,
    Ryan
     
  2. Rdubya

    Rdubya Registered

    Joined:
    Apr 15, 2014
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Resolved:

    The triggers in the database had a cpses_*** that were not working. I am not certain how cpses works with databases, but when I recreated the triggers it had a new value in there and it works now.
     
  3. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    I am happy to see the issue is now resolved. Feel free to let us know if you encounter any additional issues.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice