Forums / Managing Customers and Orders / Attribute text in invoice is truncated

Attribute text in invoice is truncated

Locked

Views: 1,227

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
17 Mar 2010, 7:37 PM
#1
needhelpwiththis avatar

needhelpwiththis

New Zenner

Join Date:
Feb 2010
Posts:
17
Plugin Contributions:
0

Attribute text in invoice is truncated

I haven't been able to find the answer here yet, so I'm hoping somebody can help me.

The attribute text is truncated in my invoice and packing slip. Yet, the table row length seems to be long enough. as there's plenty of space after the text is truncated. In addition, each attribute seems to be randomly truncated- the further down the page it is, the less truncated it is. For example, my first attribute is truncated at 35 characters; the second one at 37, and the third one at 47 characters. I looked in the invoice and packingslip.php files but couldn't figure out what to change. Can anybody help?

17 Mar 2010, 8:59 PM
#2
needhelpwiththis avatar

needhelpwiththis

New Zenner

Join Date:
Feb 2010
Posts:
17
Plugin Contributions:
0

Re: Attribute text in invoice is truncated

I forgot to mention that it looks the same in the order page.

21 Mar 2010, 2:07 PM
#3
needhelpwiththis avatar

needhelpwiththis

New Zenner

Join Date:
Feb 2010
Posts:
17
Plugin Contributions:
0

Re: Attribute text in invoice is truncated

Any ideas?
My packing slips don't look good.

21 Mar 2010, 6:11 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute text in invoice is truncated

Go to phpMyAdmin and look at the structure of the:
orders_products_attributes

table and see what the definition is for the field:
products_options_values

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

21 Mar 2010, 8:36 PM
#5
needhelpwiththis avatar

needhelpwiththis

New Zenner

Join Date:
Feb 2010
Posts:
17
Plugin Contributions:
0

Re: Attribute text in invoice is truncated

Please bear with me because I'm new to this... what do you mean by look at the definition?
I found the field products_options_values but I'm not sure what I need to look for there. For "type" it says "text", "lenght/values" is blank, "collation" has the value "utf_general_ci", the field "attributes" is blank, "null" says "not null" and everything else is blank. Is there something here I need to change?

Thanks, I appreciate your help.

21 Mar 2010, 8:56 PM
#6
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute text in invoice is truncated

It should be text ... I just wanted to be sure you did not have it defined with varchar and a length that it would get cut off ...

I am not sure off hand what is cutting off the display for you ...

If you edit one of the Attributes in the table, is the products_options_values cut off or is all of the text there that should be there?

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

22 Mar 2010, 12:44 AM
#7
needhelpwiththis avatar

needhelpwiththis

New Zenner

Join Date:
Feb 2010
Posts:
17
Plugin Contributions:
0

Re: Attribute text in invoice is truncated

Fixed it! Thanks for pointing me in the right direction- never would have thought at looking at this specific part of the table.

The problematic field was products_options, which had a max character length of 30 something (forgot exact number). I increased the number and now it works perfectly.

22 Mar 2010, 1:07 AM
#8
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Attribute text in invoice is truncated

Glad that this helped straighten out the problem ... :smile:

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!