Support » Plugin: Buy one click WooCommerce » 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 1 month, 3 weeks ago by Djo.
    • This reply was modified 1 month, 3 weeks ago by Djo.
Viewing 1 replies (of 1 total)
  • You must be logged in to reply to this topic.