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.

Losing cpses after query?

Discussion in 'Database Discussions' 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 Forums Analyst
    Staff Member

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

Share This Page