This topic contains 47 replies, has 6 voices, and was last updated by 
We moved to new unified forum. Please post all new support queries in our New Forum
Is there a limit to the amount of fields on can put in a form? Because now, whenever I add a field, it always errors out when I go to rebuild the table.
Also is there anyway of adding just plain text between fields for text descriptions?
Thanh Nguyen Viet
Friend
Hello Mikeselk,
to resolve this issue, please open the file
components/com_jajobboard/asset/rendfield.php
Find this code snippet:
[PHP]case ‘SEPERATOR’:
$r = rendfieldlabel($field);[/PHP]
And replace it with:
[PHP]case ‘SEPERATOR’:
$r = ”;[/PHP]
That didn’t help at all. I replaced the code in that file and it did not make any change. I even went to that separator and changed it so I can rebuild the database and nothing.
But I also had two other issues as well in the post above yours. I am almost complete and if I can get this form customized I will be done with this project. The quicker I can get done the better. Please let me know what to do. Thanks
Jeff
Thanh Nguyen Viet
Friend
Hello Jeff,
There are two code snippet like that on that file, and you must replace them all.
And I had a small wrong, because the code that you need use it:
[PHP]$r = ‘ ‘;[/PHP]
not:
[PHP]$r = ”;[/PHP]
since, empty field will be skipped.
I have update it for you, please have a look.
FYI: I will improve this feature in the next version.
Thank you, but you still haven’t answered the questions I had previous about the rebuild not letting me add anymore. And is there anyway of adding html code to the label, so I can make the separators to stand out from the rest?
Thanh Nguyen Viet
Friend
Hello Mikeselk,
I’m sorry because I did not see this question. No, JB does not have a code to limit number of form field. But each mysql table only contains 85 columns is maximum (see more information at http://dev.mysql.com/doc/refman/4.1/en/column-count-limit.html), that why you can not create more 85 fields for each form (because each field is corresponding one column in mysql table).
If, your form does not reach this limit, please check your form fields setting again.
Regarding lable field issue, I’ll update in the next version to apply special html tag for this field, so you can css for them to get special style.
The problem I have with this, is that even my programmer is saying that there is a hard limit to the columns of 4096 columns per table. And I didn’t add that many more fields to the application. I have about 5 fields left to go and I have added more fields into RSForm. So I need to get this figured out or I am going to have to ask for money back.
Thanh Nguyen Viet
Friend
Hello Mikeselk,
Please update your administrator account, I’ll check and help you to resolve this issue.
I have tried with old one, but I couldn’t get an access.
ok, try again.
Thanh Nguyen Viet
Friend
Hello again,
Now is an off time in our side. I’ll check your issue tommorow.
Thanh Nguyen Viet
Friend
Hello Mikeselk,
I have tried to create table with more than 85 columns, and I couldn’t since I got this error message
” 1118 – Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs”
Please tell your developer to test it by himself (I have added sample code that I used).
I have checked your site, Application form has more than 85 fields, so you can not add more fields.
I’m sorry about that because we did not anticipate this case, we will update our wiki page about that.
Thanks you for your understanding.
FYI: could you change some fields to textarea type? since as above message of mysql, field with TEXT and BLOBs type are not counting. In Jobboard, form field with textare type will have TEXT type in database.
ok, my developer looked at it and thinks this is a bad way of designing a database. And my client is getting very irritated and is demanding his money back on this. So I am going to have to ask for the money back on this. Because I can’t use it and I have no desire to use it. So please move forward with a refund. Thanks
Arvind Chauhan
Moderator
Hi Mikeselk,
You can check the Refund Policy Page >> http://www.joomlart.com/joomlart/refunds
and raise refund request. If with in the refund policy guidelines, it would be processed.
Regards
Arvind
ok, we have not seen any refund yet for this. Please verify that this is coming. Thank you.
Anonymous
Moderator
<em>@mikeselk 344116 wrote:</em><blockquote>ok, we have not seen any refund yet for this. Please verify that this is coming. Thank you.</blockquote>
Our salesman has been replied you via ticket ID# SIT-805-78297. Please log into http://support.joomlart.com to find this ticket there.
Regards,
This topic contains 47 replies, has 6 voices, and was last updated by
We moved to new unified forum. Please post all new support queries in our New Forum