• Hi!
    I’m trying to move my wordpress database to another server. When importing I get this error (also all tables after wp_comments are not imported properly/site unaccessable):

    Error
    
    SQL query: Documentation
    
    --
    -- Triggers <code>wp_comments</code>
    --
    DELIMITER $$ CREATE TRIGGER <code>livenotification</code> AFTER INSERT ON <code>wp_comments</code>
    FOR EACH
    ROW IF( INSTR( new.comment_agent, 'Disqus' ) )
    THEN INSERT INTO wp_livenotifications( userid, userid_subj, content_type, content_id, parent_id, content_text, is_read, time, username )
    VALUES (
    (
    
    SELECT post_author
    FROM wp_posts
    WHERE ID = new.comment_post_ID
    ), new.user_id, 'comment', new.comment_ID, new.comment_post_ID, (
    
    SELECT post_title
    FROM wp_posts
    WHERE ID = new.comment_post_ID
    ), '0', UNIX_TIMESTAMP( ) , new.comment_author
    );
    
    END IF $$
    
    MySQL said: Documentation
    #1142 - TRIGGER command denied to user 'xxxxxxxx'@'localhost' for table 'wp_comments'

    Would be very happy about any help!

  • The topic ‘Import database: Mysql error #1142 – TRIGGER command denied’ is closed to new replies.