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

TOPIC: Custom Fields problems

Custom Fields problems 14 years 7 months ago #7597

  • angekay
  • angekay's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
I am having two issues with using custom fields:

1. The "Conditional Field" drop shows nothing, even though I have created a custom field. (The custom field is radio, no fee.)

2. I get an error message when I go to Custom Fields:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=select * from jos_dtregister_fields where (type = 1 or type=4) and id <>
Warning: Invalid argument supplied for foreach() in /home/(mysite)/public_html/components/com_dtregister/class.dtregister.php on line 1959

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

Custom Fields problems 14 years 7 months ago #7598

  • angekay
  • angekay's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 9
  • Thank you received: 0
Just got another error message, when I used "copy custom field."

Warning: Invalid argument supplied for foreach() in /home/(mysite)/public_html/components/com_dtregister/class.dtregister.php on line 1435
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=select * from jos_dtregister_fields where (type = 1 or type=4) and id <>
Warning: Invalid argument supplied for foreach() in /home/(mysite)/public_html/components/com_dtregister/class.dtregister.php on line 1959

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

Custom Fields problems 14 years 7 months ago #7601

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Well, you don't REALLY have a problem here.

1. If you have no qualifying field, nothing will show in that dropdown. First, the only field types that will show in that dropdown are checkboxes, radio buttons and dropdowns... as explained in the video tutorial. Also, the field you are editing will also not show in the dropdown as you can't set your field to display conditional to itself :) .

2. You are seeing a warning show because you don't have any qualifying custom fields for the conditional dropdown. We are addressing this now so no warning shows in that case. We'll update the package shortly with that... but this is not a big problem... create a qualifying field, then you won't see that anyway.

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

Custom Fields problems 14 years 7 months ago #7602

  • creasemonkey
  • creasemonkey's Avatar
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 20
  • Thank you received: 0
I'm getting the same error now since updating to the latest package. It happens when I try to copy an existing and also when are trying to create a new custom field without a condition. Prior to the update with the JQuery fix it worked fine.

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

Custom Fields problems 14 years 7 months ago #7603

  • creasemonkey
  • creasemonkey's Avatar
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 20
  • Thank you received: 0
I can successfully modify any existing custom field. I can also add a conditional field to an existing one. The error only seems to occur when adding a new field or trying to copy an existing one.

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=select * from jos_dtregister_fields where (type = 1 or type=4) and id <>
Warning: Invalid argument supplied for foreach() in /home/SITE/public_html/components/com_dtregister/class.dtregister.php on line 1959
Custom Field: New

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

Custom Fields problems 14 years 7 months ago #7608

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Ok, we have now updated the package again as these little annoying items have been sorted out. Not all users would have even seen them, but it's done now. Download and reinstall. The latest version will show as 2.6.6a in the list of installed components. Thanks.

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

  • Page:
  • 1
  • 2
Time to create page: 0.237 seconds