[Plugin: BP Group Hierarchy] Fatal Error: You have an error in your SQL syntax

  • lightbox20

    (@lightbox20)


    11 years, 10 months ago

    When I try to activate this plugin I get the following error:

    Plugin could not be activated because it triggered a fatal error.

    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 ‘) DEFAULT CHARACTER SET utf8’ at line 4]
    CREATE TABLE 2G_bp_groups ( parent_id BIGINT(20) NOT NULL DEFAULT 0, KEY parent_id (parent_id), ) DEFAULT CHARACTER SET utf8;

    BP Group Hierarchy – Required column was not found – last MySQL error was:
    Could not create the required column. Please enable debugging for more details.

    Can anyone help me figure out how to activate this plugin?

    http://wordpress.org/extend/plugins/bp-group-hierarchy/

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author David Dean

    (@ddean)

    11 years, 10 months ago

    I have some questions to help us get our footing here, since it sounds like you don’t have a groups table.

    – Have you installed and activated BuddyPress?

    – Does your MySQL user have “ALTER” privileges on your WordPress database?

    Thread Starter lightbox20

    (@lightbox20)

    11 years, 10 months ago

    Hi David, thanks for talking this up with me.

    A. I have activated buddy press.
    B. My MySQL user does have “ALTER” privileges.
    C. I do have a bp_groups table however, the table is prefixed with a random string for security i.e. xyz_bp_group.

    -L

    12sp

    (@sp12)

    11 years, 9 months ago

    I got a similar error.I do have buddypress installed. I don’t know how to determine the “alter: privileges, but I’m running on blue host.

    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 '' at line 1 for query DESCRIBE  made by require('wp-admin/plugins.php'), activate_plugins, activate_plugin, do_action('activate_bp-group-hierarchy/index.php'), call_user_func_array, bp_group_hierarchy_install, bp_group_hierarchy_verify_install

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 '' at line 1 for query DESCRIBE  made by require('wp-admin/plugins.php'), do_action('activate_bp-group-hierarchy/index.php'), call_user_func_array, bp_group_hierarchy_install, bp_group_hierarchy_verify_install

    I continued to get this error as well until I deactivated the hierarchiy plugin.

    PHP Fatal error: Call to a member function set_404() on a non-object in /home2/zetaport/public_html/wp-content/plugins/buddypress/bp-core/bp-core-functions.php on line 1470

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘[Plugin: BP Group Hierarchy] Fatal Error: You have an error in your SQL syntax’ is closed to new replies.