RE: [ic] Form seach on other tables than Products

["N.E.S.T. Solutions" <suppressed>]

> "N.E.S.T. Solutions" <suppressed> 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
>  _/ _/    _/          _/ _/     _/    _/  _/_/    suppressed
> _/   _/  _/_/_/_/      _/    _/_/_/  _/    _/
> _______________________________________________
> interchange-users mailing list
> suppressed 
> 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.




_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users