Page 1 of 1

FrontEndUsers Special charachters error

Posted: Fri Mar 04, 2016 8:12 pm
by magallo
FEU 1.31.1

Hi All, i have 2 issues with the new FEU and i'm not sure if it's isolated to the last version however:

1) When i try to insert ' (single quotes) in the dropdown list i get a
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 '6"', 'height'), ('2', '2', '4'7"', 'height')' at line 3
I understand and can see the reason, I'm trying to create a Height field like 5'7",5'8"....

2) I created a Multi Select List property field and while the data is stored in the database, the value does is not populated back in the filed when you edit the user. It goes back to blank

3) Would it be complicated to implement a Checkbox Group property?

Thank you for your feedback :)

Re: FrontEndUsers Special charachters error

Posted: Fri Mar 04, 2016 9:52 pm
by Jeff
Try putting a \ in front of the '.

Re: FrontEndUsers Special charachters error

Posted: Tue Mar 08, 2016 12:25 am
by magallo
It worked (kind of): after saving the record, the data is being displayed without the '(quote) (still in the field details) so if you edit the list you will need to escape all the items again.

Do you know how i can add an "Select Option..." as a default value?

Thanks for the help.

Re: FrontEndUsers Special charachters error

Posted: Tue Mar 08, 2016 3:38 am
by Jeff
I complete guess would be to have this as your first line (using = as the delimiter change as needed.

Code: Select all

Select One...=

Re: FrontEndUsers Special charachters error

Posted: Tue Mar 08, 2016 5:30 pm
by magallo
Unfortunately that would not work, FEU will replace that with "Select One..." making it its value as well.

I noticed a big issue here:
When you edit a user from the admin area, all the dropdown fields will automatically select the first value in the list. I think that the admin or the user should make that choice.

In the "Change Settings" template in FEU i edited the template for the dropdown fields to have this:

{if $field->value == ''}<option value=''>-- Select--</option>{/if}

This will do, however my required fields are not being validated now :(