Subject Field in commerce Email module limit the characters.

7 posts / 0 new
Last post
sakar
sakar's picture
Subject Field in commerce Email module limit the characters.

I am using the commerce email module + html email module for sending the order mail

Now as i want the subject which is long text and drupal is restricting me provide that...

What it is so.....:-(

I want my Subject line for order confirmation mails.
Please provide solution its a very small expection
can u please look into this.

support
support's picture
Hi there Sakar:

Hi there Sakar:

As this post is related with this other one from you, lets continue the thread in one single place http://doublemthemes.com/forum/token-text-showing-order-mail-whenever-te...

Thanks!!!

sakar
sakar's picture
No, Its completely different

No, Its completely different .
let me explain you in detail

whenever user is putting order and confirm for the payment; he/she gets the order confirmation mail.

For sending the confirmation mail I am using the commerce order module.
Click on store->configuration->email

Here we can find order mail as well as admin mail section where we can customize our email format.

here Drupal is asking "subject" and then "Body".

And Question is :
for subject i can't put
"
[commerce-order:commerce-customer-billing:commerce_customer_address:name-line] Purchase Order [commerce-order:order-number] - [site:name] Happy Customer
"
its restricting me to provide this much long string.

how we can remove this restriction..

sakar
sakar's picture
Hi support,

Hi support,

can u suggest me any solution for this problem?

support
support's picture
Hi there Sakar:

Hi there Sakar:

Sorry or the delay. So, if the problem comes with the length of the field my doubt now is that if it stills an Input Limit problem or when you submit the Subject structure, it gets trimmed.

So:

- if the field does not allows you to submit more than a specific length:

I would go for the database, search for the string and replace it directly on the database. Just for testing.

- If it gets trimmed when you submit the entire value, then you will still need to know which supported value (mostly the length of it is on the Database for the Subject field)

Let me know.

Best!!!

sakar
sakar's picture
Yes that subject field is not

Yes that subject field is not allowing me to submit the specific length.

which string i need to replace?

I can understand that in some table length restriction must be present but where in which table?

In which table I need to do the changes for subject Field, I can not find the appropriate table for making the change.
can you please tell me the table name where i can change .

Please help me out..
Need to close the issue ASAP.

support
support's picture
Hi there Sakar:

Hi there Sakar:

What I would do is export the database in a SQL file and search for the string that composes your subject:

"[commerce-order:commerce-customer-billing:commerce_customer_address:name-line] Purchase Order [commerce-order:order-number] - [site:name] Happy Customer"

At least partially or some fragments of it, depending on what get's submitted when you save.

Then check for the surrounding SQL statements until you find the table and the field.

Best!!!

Log in to post comments