[ic] Form seach on other tables than Products
N.E.S.T. Solutions
nest_consulting at yahoo.ca
Sun Nov 19 18:46:50 EST 2006
> "N.E.S.T. Solutions" <nest_consulting at yahoo.ca> wrote:
> > The problem seems to be when I use
> > form action="[area search]" with fi=distributors table, it gives me
> > this error, even though I specify another table which doesn't
> > have an "inactive" column:
> >
> > DBD::mysql::st execute failed: Unknown
> > column 'inactive' in 'where clause' at
> > /usr/local/spitfire-stores/lib/Vend/Table/DBI.pm line 1849.
> >
> I suspect that you probably have the following somewhere in your
> configuration:
>
> Database distributors HIDE_FIELD inactive
>
> If you don't have an "inactive" column then the error message
> would seem reasonable.
>
> You probably copied the "products" Database directives to
> create a new "distributors" table definition, and didn't
> remove the HIDE_FIELD.
>
> --
> _/ _/ _/_/_/_/ _/ _/ _/_/_/ _/ _/
> _/_/_/ _/_/ _/ _/ _/ _/_/ _/ K e v i n
> W a l s h
> _/ _/ _/ _/ _/ _/ _/ _/_/ kevin at cursor.biz
> _/ _/ _/_/_/_/ _/ _/_/_/ _/ _/
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/int> erchange-users
>
In the end, you were right, for that DB, I must have copied from
somewhere and modified the .mysql config. I did find that line in
it, but not in my other DB's configs that I created.
Damn you're good!
Thanks again! Solved 2 problems in 1
Martin H.
More information about the interchange-users
mailing list