toolsnz

Thanks for those suggestions and looks like they will do what I need…. I will try them out

Thanks very much, wp_kses_post() worked for me and allows basic html formatting to be saved in the custom field

… 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

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 ;

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 ;

I tried deleting and reinstalling… still no go.
I have sent you a login

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

Arh, Logo is working fine, but not an image in the body… which would be expected if unsupported ??

so well done… all working – thanks

Hi Alberto,

… I think I misunderstand what I should be doing here.
for the ignorant (me) can you please give me some steps/exmaple for ‘including directly in code’

I am having the same issue with images even after upgrading to 3.2.7.
Both with the logo, and in body of pdf.

Can you perhaps post the image you are using for testing?
Maybe we can eliminate the image(s) as the issue?

Thanks for your efforts.

… the theme must have got corrupted. Re-installing storefront fixed it – thanks

Manoj, sorry we also moved host yesterday… should be working for you now.

Mikey, thanks for the reply. I tried that in style.css of our child theme. But no change… something else must be overriding it. I have searched for any other .qty and not found any.

Is it possible that the size of the text box is the problem? I note one of my other sites seems to have a slightly larger qty box… and the default qty of “1” is there, but off to one side until clicked into?

… and all good for me as well ??

Thanks for this

I am not using any inline CSS

I have noticed a bit more of this problem.

if you code the HTML email in the WordPress text editor Email Subscribers -> Compose in this format for example;

<table>
<tr>
<td> etc

The email sent to subscribers is output as;
<table><br /><tr><br /><td><br /> etc

if you edit in the text window as;
<table><tr><td> etc, then the output is all fine

But here is the catch, if you change from the text window to the visual, wordpress ‘tidyies’ up the code and puts each element onto a new line, and thus introduces a <br /> for each element!