30 Posts
tiagovareta
3 years ago
Topic

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?

Get a VIP membership
4229 Posts
Kadministrator
3 years ago
2
Level 1

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.

30 Posts
tiagovareta
3 years ago
1
Level 2

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)?

30 Posts
tiagovareta
3 years ago
0
Level 3

Situation Resolved! It did not have the status field assigned. I added the status field and it worked :) 

Get a VIP membership