Hi,
I have a checkbox field, like this: http://prntscr.com/k4f7an .
When I do the research, it gives the error: 1054 Unknown column 't2.state' in 'where clause'
How can I resolve this situation?
What is your checkbox sotrage? unless it is article - state it should not have anything to do with the error.
BUT - your checkbox values are probably wrong, are you sure you have values like historico.png? In select simple text and values are written like this text=value.
Also check our matching, you need to use one of matchings that use quotes (click on + for this setting) around value as value with dot will otherwise produce error.
Hi Klas,
Many thanks for the reply!
When I save the checkbox field, I record the image name. Like this:
- BackEnd: Form / Insert Registration: http://prntscr.com/k4hlu8
- FrontEnd: http://prntscr.com/k4hm5u
That is, I use the name of the image, so in FrontEnd the user see icons and not text.
To do a search the fields can not have points (name.png)?
Situation Resolved! It did not have the status field assigned. I added the status field and it worked :)
