WordPress.org

Ready to get started?Download WordPress

Forums

BP Group Hierarchy
Fatal Error: You have an error in your SQL syntax (4 posts)

  1. lightbox20
    Member
    Posted 2 years 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/

  2. David Dean
    Member
    Plugin Author

    Posted 2 years 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?

  3. lightbox20
    Member
    Posted 2 years 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

  4. 12sp
    Member
    Posted 2 years 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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.