Kryptronic Software Support Forum
You are viewing this forum as a guest. Login to an existing account, or create a new account, to reply to topics and to create new topics.
Pages: 1
- Index
- » ClickCartPro and EuropaCart 7
- » Increasing text length of Display Name for Option Selection Items.
#1 02-19-2010 13:44:47
- shambright
- Member
- Registered: 06-04-2009
- Posts: 13
Increasing text length of Display Name for Option Selection Items.
Our use of the cart requires that the Display Name field of product option selections be longer than 40 characters.
I made the following "tweaks" with no success --- What am I missing?!?
1) Changed 'name' column of MySQL table ecom_prodoptionsel to VARCHAR(255)
2) Changed the file table_ecom_prodoptionsel.xml for "Display Name" from this...
<cnumeric>40</cnumeric>
<crequired>1</crequired>
<cinsdisplaytype>TEXTBOX-REG</cinsdisplaytype>
<cinsdisplaydata></cinsdisplaydata>
<cinsdefaultvalue></cinsdefaultvalue>
<cupddisplaytype>TEXTBOX-REG</cupddisplaytype>
to this:
<cnumeric></cnumeric>
<crequired>1</crequired>
<cinsdisplaytype>TEXTAREA-SMALL</cinsdisplaytype>
<cinsdisplaydata></cinsdisplaydata>
<cinsdefaultvalue></cinsdefaultvalue>
<cupddisplaytype>TEXTAREA-SMALL</cupddisplaytype>
Offline
#3 02-19-2010 14:47:05
- shambright
- Member
- Registered: 06-04-2009
- Posts: 13
Re: Increasing text length of Display Name for Option Selection Items.
Hi John,
That was step (1) -- using PHPMyAdmin
Those two steps did not change the form at Store -> Catalog -> OptionSelection Items (Update)
The form field is still a single textline with MAXLENGTH set to 40.
---
Or am I missing what else needs to be changed in the MySQL DB?
Offline
#5 02-20-2010 00:41:16
Re: Increasing text length of Display Name for Option Selection Items.
The main area you need to change is in the core_columndef database table for the options column, but you still need to make sure/change it directly in the database (sometimes). The xml files will only help you when and if you rerun the installer and chose to reload the definations, but probably in the process the xml files will be over written with the current xml files pulled from the central server.
John
Offline
#6 02-20-2010 12:28:38
- shambright
- Member
- Registered: 06-04-2009
- Posts: 13
Re: Increasing text length of Display Name for Option Selection Items.
That solved it...
Steps (1) & (2) above, and then
3) in PHPMyAdmin, update core_columndefs
cnumeric = 255
cinsdisplaytype = TEXTAREA-SMALL
cupddisplaytype = TEXTAREA-SMALL
where cid= ecom_prodoptionsel.name
Offline
Pages: 1
- Index
- » ClickCartPro and EuropaCart 7
- » Increasing text length of Display Name for Option Selection Items.