New Products listing

**Hostboard** · 10-19-2010, 05:12 PM

New products shows properly everywhere except when being viewed within a catagory. When I click on a catagory the new products for the month gives an error:

Code:

1054 - Unknown column 'p.products_featured' in 'where clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price as products_price from products p, products_to_categories p2c, categories c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '8' and p.products_status = '1' and p.products_featured = '1' order by p.products_date_added desc limit 3

[TEP STOP]

Again this was after a site upgrade from 2.0.4 to 2.0.25. There are other issues but I think this is the last for the front end that I have not figured out.

**ridexbuilder** · 10-19-2010, 10:29 PM

You did apply the SQL file in the upgrade directory?

**Hostboard** · 10-20-2010, 06:11 AM

I ran the update PHP file. Should I run it again or take the guts and just run the table updates in phpmyadmin? Where there any updates to the DB prior to .4? Say from .2 to .3 then to .4 that maybe I missed?

**ridexbuilder** · 10-20-2010, 06:30 AM

Originally Posted by Hostboard

I ran the update PHP file. Should I run it again or take the guts and just run the table updates in phpmyadmin? Where there any updates to the DB prior to .4? Say from .2 to .3 then to .4 that maybe I missed?

Look in the upgrade directory.

**Hostboard** · 10-21-2010, 10:29 AM

Re-downloaded OSCMax, applied all DB changes in update folder and still no luck as I am still getting the same error. Any other suggestions?

**ridexbuilder** · 10-21-2010, 12:33 PM

Note: I upgrade by starting a new 2.0.25 install and transfer the relevant (not all) tables from 2.0.4
In other words, I bypass the inbuilt upgrade procedure, mentioned by Michael in forum posts (and possibly the wiki).
This way, items like configuration are not transferred over, which may effect later releases. A bit more manual work is involved but given that templates often need adjusted, I have found it successful.

[Just my personal experience, not the 'official line']

**Hostboard** · 10-21-2010, 05:28 PM

I am not sure I am talented enough to figure out what tables need to be manally transfered over. I am pretty sure I could install the latest and then dump the older DB in but if things did not import I know I am not going to be able to figure out how to manually move that data over.

Maybe I should just remove this section and call it a day.