You have an error in your SQL syntax

  • Resolved stormgunner

    (@stormgunner)


    4 years, 11 months ago

    AH01071: Got error ‘Y (meta_id)’ at line 1PHP message: require_once(‘wp-admin/admin.php’), do_action(‘appearance_page_tgmpa-install-plugins’), WP_Hook->do_action, WP_Hook->apply_filters, TGM_Plugin_Activation->install_plugins_page, TGM_Plugin_Activation->do_plugin_install, TGM_Plugin_Activation->activate_single_plugin, activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_woocommerce_log ADD COLUMN PRIMARY KEY (log_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (log_id)’ at line 1PHP message: require_once(‘wp-admin/admin.php’), do_action(‘appearance_page_tgmpa-install-plugins’), WP_Hook->do_action, WP_Hook->apply_filters, TGM_Plugin_Activation->install_plugins_page, TGM_Plugin_Activation->do_plugin_install, TGM_Plugin_Activation->activate_single_plugin, activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_webhooks ADD COLUMN PRIMARY KEY (webhook_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (webhook_id)’ at line 1PHP message: require_once(‘wp-admin/admin.php’), do_action(‘appearance_page_tgmpa-install-plugins’), WP_Hook->do_action, WP_Hook->apply_filters, TGM_Plugin_Activation->install_plugins_page, TGM_Plugin_Activation->do_plugin_install, TGM_Plugin_Activation->activate_single_plugin, activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_download_log ADD COLUMN PRIMARY KEY (download_log_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (download_log_id)’ at line 1PHP message: require_once(‘wp-admin/admin.php’), do_action(‘appearance_page_tgmpa-install-plugins’), WP_Hook->do_action, WP_Hook->apply_filters, TGM_Plugin_Activation->install_plugins_page, TGM_Plugin_Activation->do_plugin_install, TGM_Plugin_Activation->activate_single_plugin, activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_product_meta_lookup ADD COLUMN PRIMARY KEY (product_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (product_id)’ at line 1PHP message: require_once(‘wp-admin/admin.php’), do_action(‘appearance_page_tgmpa-install-plugins’), WP_Hook->do_action, WP_Hook->apply_filters, TGM_Plugin_Activation->install_plugins_page, TGM_Plugin_Activation->do_plugin_install, TGM_Plugin_Activation->activate_single_plugin, activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_tax_rate_classes ADD COLUMN PRIMARY KEY (tax_rate_class_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (tax_rate_class_id)’ at line 1PHP message: require_once(‘wp-admin/admin.php’), do_action(‘appearance_page_tgmpa-install-plugins’), WP_Hook->do_action, WP_Hook->apply_filters, TGM_Plugin_Activation->install_plugins_page, TGM_Plugin_Activation->do_plugin_install, TGM_Plugin_Activation->activate_single_plugin, activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_tax_rate_classes ADD COLUMN UNIQUE KEY slug (slug(191)) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘UNIQUE KEY slug (slug(191))’ at line 1′,

    In the new update i got a better error message. Updating MariaDB doesnt work, can you help?

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

  • Typically issues like this may be caused by either a conflict with your theme or with another plugin. How we usually address this type of issue is to have you temporarily switch back to a default WordPress theme such as WordPress Twenty Twenty Theme (https://www.ads-software.com/themes/twentytwenty/) or Storefront (https://www.ads-software.com/themes/storefront/) and disable all plugins except for WooCommerce. If that resolves the issue, then re-enable features one-by-one until you find the one that’s causing the conflict.

    Thread Starter stormgunner

    (@stormgunner)

    Okay i used WP Twenty theme then activated only Woocommerce and i still have the same problem.

    AH01071: Got error ‘(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_download_log ADD COLUMN PRIMARY KEY (download_log_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (download_log_id)’ at line 1PHP message: activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_product_meta_lookup ADD COLUMN PRIMARY KEY (product_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (product_id)’ at line 1PHP message: activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_tax_rate_classes ADD COLUMN PRIMARY KEY (tax_rate_class_id) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘PRIMARY KEY (tax_rate_class_id)’ at line 1PHP message: activate_plugin, do_action(‘activate_woocommerce/woocommerce.php’), WP_Hook->do_action, WP_Hook->apply_filters, WC_Install::install, WC_Install::create_tables, dbDelta taraf\xc4\xb1ndan olu\xc5\x9fturulan ALTER TABLE 60t0JYkmc_wc_tax_rate_classes ADD COLUMN UNIQUE KEY slug (slug(191)) sorgusu i\xc3\xa7in WordPress veritaban\xc4\xb1 hatas\xc4\xb1 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘UNIQUE KEY slug (slug(191))’ at line 1′

    Installed manually. Automatic install doesnt work either.

    The only suggestion that I can offer would be to contact your host to see if they can provide an explanation for why the database is performing in this way.

    Plugin Support EtienneP a11n

    (@etiennep)

    We haven’t heard back from you in a while, so I’m going to mark this as resolved – if you have any further questions, you can start a new thread.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘You have an error in your SQL syntax’ is closed to new replies.