Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: why is length of fees values in the fee field limited?

why is length of fees values in the fee field limited? 15 years 2 weeks ago #5458

  • gegmbh
  • gegmbh's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 1
  • Thank you received: 0
I was just setting up a custom fee field. My customers shell be able to select from a drop down list a country from which they are calling. This list has around 90 options. The drop down list shows them fine, but the values for the fees are limited to 40 entries? That is more than not good. Is there any way to overcome that strange bug?

Otherwise I have to tell people from Hungary and South Africa that they can not call because dt register does not allow that! ;)

Please Log in or Create an account to join the conversation.

why is length of fees values in the fee field limited? 15 years 2 weeks ago #5459

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
There is a limit in the file:
/administrator/components/com_dtregister/admin.dtregister.html.php

Around line 4886 you'll find this:
<input class="text_area" type="text" name="fees" size="70" maxlength="250" value="<?php echo $row->fees;?>" <?php if((!$row->type) || ($row->type==2)) echo  "disabled"; ?> />

Remove maxlength="250" from the above code, save and upload the modified file. We are removing this for the next release as well. Then you need to change the field type in the database...

table: jos_dtregister_fields
field: fees
type: currently "varchar(255)", change it to "TEXT". Also clear the length/values parameter for the field

Now you'll have no limitation on your fees. You're the first person to ever report not having enough room for the fees field, so congrats! :) Hope this helps.

Please Log in or Create an account to join the conversation.

why is length of fees values in the fee field limited? 14 years 10 months ago #6236

  • breezeboogie
  • breezeboogie's Avatar
  • Visitor
  • Visitor
Just purchased DTRegister for my client in January. I too do not have enough space as the fee values are being truncated. If I install the latest version (2.6), can I avoid having to make these edits to the php file and the database?

Please Log in or Create an account to join the conversation.

why is length of fees values in the fee field limited? 14 years 10 months ago #6237

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
breeze - yes, the latest packages have this change already made. You'll likely need to make the database change still. In a new install, it would be fine, but you'll have the old db structure and that field type won't have been changed. Quick fix though.

Please Log in or Create an account to join the conversation.

why is length of fees values in the fee field limited? 14 years 10 months ago #6242

  • breezeboogie
  • breezeboogie's Avatar
  • Visitor
  • Visitor
The database edit wasn't even necessary for me. In the database, the field type was already set to text with no character limit specified. I simply needed to make the update to the php file as you instructed and it worked. I'll upgrade them to 2.6 over the weekend after testing it on a back up installation of the site. Before upgrading to 2.6 on the production site, i'll want to do it in a test environment to be sure. (this client's events have really complex price structures with 36 possible prices for each of their events depending on special field criteria the user selects. Still amazing that I can set something up like this as I'm not a programmer.

BTW, I've said it before but THIS COMPONENT F'@##'in ROCKS! Can't wait for a J1.5 version of DTInvoice.

Please Log in or Create an account to join the conversation.

why is length of fees values in the fee field limited? 14 years 10 months ago #6247

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
breeze - thanks for the kind comments! If you haven't already, please take a minute and give a vote/review on the JED:
[url]
http://extensions.joomla.org/extensions ... ation/2037 [/url]

Thanks again.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.205 seconds