record_company pulldown issues after upgrading

[jestcoun]

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

[jestcoun]

For now, I've disabled alpha filters and catagory filters.

The search box will work but I really would like to use the other filters as well.

[jestcoun]

I ran across another post that mentioned not to use the same database table prefix when upgrading the database or it could corrupt it.

I remembered that I did not change my prefix during the first upgrade; so, I went back and deleted my database and restored it to 1.3.7.

I tried upgrading again using a different prefix for the tables but I still get the same issues with the record company filters.

I also went to my database to see if the prefix changed to what I input during the upgrade process...the database table prefixes are the same as they were in 1.3.7 even though I told the upgrade to use a different prefix.

I really suspect that the database upgrade code is missing some instructions to add and remove tables and for changing the table prefixes.

[jestcoun]

I've had enough...remove my site from the showcase and delete all my threads.

I have too many problems with your software...I'll stick to staight html.