I upgraded from 1.3.7 to 1.3.8 and ran into database linking issues and filter search programing errors.

I have checked the admin area to verify that the db version matches the zen version...they match.

I also tested my problem on a clean install of 1.3.8 locally. I used the sample data provided with the cart and I get the same results in both.

I have 2 record companies in my website. When I select the first record company, all the songs listed with that company appear in the list. I get one dropdown filter, the alphabetic search, at the top of the page but the search by dropdown does not appear. When I select any alpha search criteria, I recieve a database error message:

1054 Unknown column 'm.music_genre_id' in 'field list'
in:
[select p.products_id, p.products_type, p.master_categories_id, m.music_genre_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_record_company m, zen_product_music_extra pme on pme.record_company_id = m.record_company_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1']

With the second record company, the products list just fine. However, I get both search by and alpha filters at the top of the page.

Why would I get only one filter box with one record company and both filter boxes for the other company?

When I try to do an alpha search with the second record company, nothing happens. The program fails to identify the criteria I searched for and all products continue to be listed on the page.

I am no db wizard and would appreciate it if someone could help me resolve this issue.

Thanks.

Mike