Hi there

Im trying to creat a search but when i create the layout and test in the site gives me this error

1064
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 'AND ( ei.access LIKE '%,1,%' or ei.access=''' at line 7

Do you now what is?

I try every configuracion of the layout but sitll gives the error


thanks

Hi

Please check your email

Where you see this error: on backend or on frontend ?
Which fields type you use in search ?
Can you turn off field by field and find which field give this error ?

If you will continue see error.
Please in joomla admin menu: System->"global configuration""->Server: "Error Reporting" - turn to "Development"

Please turn on there also "Debug"

Please send to us error message

Regards
OrdaSoft team

You will need do activation of CCK.
Please check more details here: ordasoft.com/News/Joomla-Tutorials/produ...ion-of-ordasoft.html

REgards
OrdaSoft team