[ic] More Information : Category select box not working in 4.6.5

Chris Rapier interchange-users@lists.akopia.com
Wed Jun 6 19:24:00 2001


Jason Kohles wrote:
> 
> On Wed, Jun 06, 2001 at 01:01:43PM -0700, Steve Bourg wrote:
> > I actually had this same problem with 4.6.3.  I never determined what it
> > was .. but I used the brute force method of deleting all categories and
> > recreating them.  Sorry :(
> >
> 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.

As a further note

I reinstalled 4.6.5 from the latest sources. I installed the 'construct'
demo store and before making any changes went to the admin/items section
and was able to reproduce the problem. Its not that there isn't anything
in the select box widget it is that there is *no* widget whatsoever.

The error I receieved from the demo store was:
128.2.85.12 T7aYyIJD:128.2.85.12 - [06/June/2001:19:22:30 -0400]
construct /cgi-bin/construct.cgi/admin/item_edit Bad SQL, query was:
select DISTINCT category, category FROM products ORDER BY category

NOTE: I am using the default DBM database. I'm guessing that this might
be the problem. However, it seems to me that if thats the default
database all of the attributes of the demo store should work as
advertised. 

I'm going to try 4.7.2 now.