The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
checkbox values not appearing in database, only commas - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: checkbox values not appearing in database, only commas (/showthread.php?tid=1267)



checkbox values not appearing in database, only commas - JMW - May 6th, 2011

OK, after a long, hard journey I finally got this form working as desired, (thanks again to Ben for his time and effort Smile).

Now I only have one small issue, checkbox values are not being displayed in the database, just a series of commas for each selection made. The values are being uploaded because they appear correctly in the e-mail sent upon submission.

Now before any body asks,
Yes, the name attribute of the arrays have the []
Yes, the database fields and views are set to maximum (VERY LARGE)
I've tried both horizontal (preferred) and vertical views, same result.
Yes, I looked through almost EVERY single post in the forums to find an answer before posting,(wish more people would do that, it would cut down on the repetative questions).
So now I'm asking for any tips.

As a side thought, I know that often questions are posted in the midst of confusion and frustration, but PLEASE people, when posting questions or answers, be descriptive in the thread subject title. Subject titles such as "Help" or "How can I fix this" or "Problem with form"
are next to useless to others looking for help or trying to provide help.
I feel sorry for Ben as he has to sort through numerous questions and has to open each post to see what someone is actually talking about.
I have been on other forums where such vague subjects are just deleted because they waste the admins time as well as others looking for help or providing help.
Ben maybe you could stress the need for more concise thread titles to make the forums easier to utilize.

Thanks in advance Smile


RE: checkbox values not appearing in database, only commas - Ben - May 6th, 2011

Hi Jeff,

Sounds like you're definitely making progress though!

If you just see a series of commas that's actually half good. It means that the script was able to understand that your field has multiple values (so the [] characters are doing their thing Smile ), it's just that it doesn't find any actual values to store for those selected options.

Did you check the actual Field Option Group section? Make sure that for the Field Option Group being used by your field has values in both the Field Value AND Display Text columns options. If they don't have any, they'll just show up as a series of commas like that. Check this page for some related info:
http://docs.formtools.org/userdoc/?page=fog_editing

That might not be the cause, but it's my best bet!

All the best -

- Ben



RE: checkbox values not appearing in database, only commas - JMW - May 6th, 2011

DOH!!!!
That was it. Thanks Ben, again.
Ya know it's been the little obvious things that have been more problematic than anything else.
But now I have all the forms up and live. thanks.