• redactuk

    (@redactuk)


    After activating plugin errors at top opf screen:

    r: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (container_id) REFERENCES srm_container(id)' at line 1]
    ALTER TABLE srm_containerrating ADD COLUMN FOREIGN KEY (container_id) REFERENCES srm_container(id)
    
    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (review_id) REFERENCES srm_reviews(id)' at line 1]
    ALTER TABLE srm_rating ADD COLUMN FOREIGN KEY (review_id) REFERENCES srm_reviews(id)
    
    WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (container_id) REFERENCES srm_container(id)' at line 1]
    ALTER TABLE srm_reviews ADD COLUMN FOREIGN KEY (container_id) REFERENCES srm_container(id)

    Can’t really ger further than this as whole WP navigation system gets messed up. Any ideas?

    https://ww.wp.xz.cn/plugins/star-review-manager/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Bram Dekker

    (@bramdnl)

    Could you tell me what MYSQL version you are running?

    Thread Starter redactuk

    (@redactuk)

    MySQL version 5.6.17

    Plugin Author Bram Dekker

    (@bramdnl)

    I am sorry for this late response. Your error should be fixed in the new version of the plugin. It was probably caused by the dbDelta not fully supporting foreign keys.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Install Errors’ is closed to new replies.