Hi @toolsnz
I don´t know if you can provide my an account for review the plugin on your site. I can provide you my email.
Thanks a lot for your donation 🙂
Best regards,
@toolsnz.
1- Check if you have version 3.2.9
2- Check if you have table named ‘wp_woocommerce_gift_coupon’ and let me know if this table has registered records.
Yes have 3.2.9, but I am missing table named ‘wp_woocommerce_gift_coupon’
I can give you a login… I have and can send to your paypal/gmail email?
Thanks
Hi @toolsnz.
The table its necessary for all funcionallity of this plugin. You could try to unnistall and install the plugin to generate again the table.
After this probably you cannot set old coupons, but new purchases with any coupon should be generated. Probably a solution for the old purchases with coupons could be to create manually the orders on WooCoomerce and send the coupons with the option on the order list page ‘Generate coupons’
I can check your site, but if you tell me that you dont have the table…
I tried deleting and reinstalling… still no go.
I have sent you a login
I cannot generate a new account of your site, please provide me a full account (user and pass) and send me an email with the credentials
Thanks
Hi again @toolsnz
Thanks, i will review that.
Hi @toolsnz,
I found the problem, your database initial is not created because it´s necesarry to change:
CHARACTER SET utf8 COLLATE utf8_general_ci
FOR:
ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ;
Probably the problem is the ‘ENGINE’
I will make an update for that issue on the next upgrade, but if you have few time for resolve it on production, please…send me a message with your email to send you a sql file.
On your dev server now…the coupons are generated right 🙂
Awsome thanks. good news.
You gave me a sql file, but the formatting is scrwed up at my end.
Can you check please;
CREATE TABLE IF NOT EXISTS <code>dev_woocommerce_gift_coupon</code> (
<code>id_wgc</code> INT(10) AUTO_INCREMENT PRIMARY KEY,
<code>id_user</code> BIGINT(20) UNSIGNED NULL,
<code>id_coupon</code> BIGINT(20) UNSIGNED NOT NULL,
<code>id_order</code> BIGINT(20) UNSIGNED NOT NULL,
KEY <code>woocomerce_key_coupon_generate_coupons</code> (<code>id_coupon</code>),
KEY <code>woocomerce_key_order_generate_coupons</code> (<code>id_order</code>),
FOREIGN KEY (<code>id_coupon</code>) REFERENCES <code>dev_posts</code>(<code>ID</code>) ON DELETE CASCADE,
FOREIGN KEY (<code>id_order</code>) REFERENCES <code>dev_woocommerce_order_items</code>(<code>order_id</code>) ON DELETE CASCADE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ;
arh, putting in cod tags above helped.
It was for example;
dev_woocommerce_gift_coupon (
id_wgc INT(10) AUTO_INCREMENT PRIMARY KEY,
editing that I think should be;
CREATE TABLE IF NOT EXISTS dev_woocommerce_gift_coupon (
id_wgc INT(10) AUTO_INCREMENT PRIMARY KEY,
id_user BIGINT(20) UNSIGNED NULL,
id_coupon BIGINT(20) UNSIGNED NOT NULL,
id_order BIGINT(20) UNSIGNED NOT NULL,
KEY woocomerce_key_coupon_generate_coupons (id_coupon),
KEY woocomerce_key_order_generate_coupons (id_order),
FOREIGN KEY (id_coupon) REFERENCES dev_posts(ID) ON DELETE CASCADE,
FOREIGN KEY (id_order) REFERENCES dev_woocommerce_order_items(order_id) ON DELETE CASCADE
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ;
… the forum, changed the formatting again in my example above! …. it had alt tags throughout.
Anyhow….I have successfully now got it working on my live site with the SQL above.
Only one small problem. When viewing All orders they have disappeared.
However they are visible via On-hold and completed etc so still functional.
Thanks for you help
Hi @toolsnz,
Great!!! :), remember, this issue will be resolved officially on the next upgrade (3.3.0)
If you have a problem with your WooCoommerce order list it´s because WooCommerce has registered a similar issue, but i think…today han been updated a new version to resolve it.
See the changelog of the last version: WooCommerce changelog
Thanks a lot for your communication for resolve the issue and thanks again for your donation 🙂
