WordPress database error

  • Hi,

    Thanks much for your helpful plugin. I am trying it and see the following error in the log:

    WordPress database error Table 'sitename-tablename.wp_coderun_oneclickwoo_orders' doesn't exist for query select * from wp_coderun_oneclickwoo_orders where active=1 made by do_action('woocommerce_page_buyone'), WP_Hook->do_action, WP_Hook->apply_filters, Coderun\BuyOneClick\BuyCore->showSettingPage, include_once('/plugins/buy-one-click-woocommerce/page/option1.php'), Coderun\BuyOneClick\BuyCore->tabViwer, include_once('/plugins/buy-one-click-woocommerce/page/tab3-option1.php'), Coderun\BuyOneClick\Order->get_orders

    Any suggestions to fix this?

    Kind regards,

Viewing 1 replies (of 1 total)
  • Plugin Author Djo

    (@northmule)

    You can run this query in the database to create a table

    
CREATE TABLE 'wp_coderun_oneclickwoo_orders' (
  'id' BIGINT(10) NOT NULL AUTO_INCREMENT,
  'plugin_version' VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8_general_ci',
  'active' TINYINT(1) NULL DEFAULT '1',
  'status' TINYINT(1) NULL DEFAULT '2',
  'product_id' INT(11) NULL DEFAULT '0',
  'product_name' VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  'product_meta' MEDIUMTEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  'product_price' DOUBLE(10,2) NULL DEFAULT '0.00',
  'product_quantity' INT(11) NULL DEFAULT NULL,
  'form' LONGTEXT NULL DEFAULT NULL COLLATE 'utf8_general_ci',
  'sms_log' VARCHAR(400) NULL DEFAULT '' COLLATE 'utf8_general_ci',
  'woo_order_id' BIGINT(20) NULL DEFAULT '0',
  'user_id' BIGINT(20) NULL DEFAULT '0',
  'date_update' DATETIME NULL DEFAULT NULL,
  'date_create' DATETIME NULL DEFAULT NULL,
  PRIMARY KEY ('id') USING BTREE
)
COMMENT='Заказы плагина Buy one click WooCommerce'
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=11
;
    • This reply was modified 4 years, 2 months ago by Djo.
    • This reply was modified 4 years, 2 months ago by Djo.
Viewing 1 replies (of 1 total)
  • The topic ‘WordPress database error’ is closed to new replies.