[ic] Category select box not working in 4.6.5

[Chris Rapier]

Guess I spoke too soon.  I have a select box and when I went to modify
it to the combo select box I foudn that it was listed as the 'text
entry' widget. Whoops. Anyway, after changing it everything broke again.
It doesn't seem to be a problem with the widget itself but in how its
trying to get the data from the tables: The error I find is often:

128.182.61.60 CJfieIfI:128.182.61.60 - [06/June/2001:17:16:24 -0400]
ic-wind /cgi-bin/ic-wind.cgi/ui.html Bad SQL, query was: select DISTINCT
category, category FROM products ORDER BY category

I'll try reinstall and possibly jumpt to 4.7.x and maybe it won't crash
and burn on me :)



Chris Rapier wrote:
> 
> > I looked at this problem briefly, but I don't have access to the machine the
> > demos run on, and when I installed a copy of 4.6.5 locally, it didn't
> > exhibit those symptoms.  If you don't have any categories you should still
> > see the combo box with 'no current value' as the only option on the popup.
> 
> Sigh. Maybe its a freebsdism but I doubt that the demo is running on
> freebsd. I am going to uninstall and reinstall and see if that helps any
> (which is horribly microsoftian but if it works...).
> 
> However, I will note that categories do exist in the products.txt
> database. The actual error reported in the error log is (he says as he
> goes to tail -f the error log only to discover that all of the sudden it
> is working...)
> 
> All I would like to say at this point is WTF?
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users