Zen Cart 1.3.8a
Database Patch Level: 1.3.8
v1.3.8 [2008-05-01 17:33:03] (Fresh Installation)
v1.3.8 [2008-05-01 17:33:03] (Fresh Installation)
PHP Version: 5.2.4 (Zend: 2.2.0)
Database: MySQL 5.0.67-log
Easy Populate basic 1.2.5.4
ultimate_seo_urls_2.106

The New Products link in the categories listing does not work. The "More" link in the header of the New Products sidebox does work.

sidebox link: mystore/products_new.html
categories listing link: mystore/index.php?main_page=index&cPath=193

I'm also getting a wierd "1054 Unknown column 'p.products_id' when I click some categories. The site will be fine for a while, then I get that error, then I re-upload, then it's fine again. There's def something odd here, lots of wierd little db probs.

In the Admin the New Products category shows 0 products, but if I click the new prods box I see my entire store.

I found a lot of posts regarding the 1054 Unknown err. But I am not on 1.2x, did change the SEO settings to kill the category parent thing. I have no 0 values in Maximum values, all New Prods setting have some value. The date range should be 1 month but it's showing every prod I have.

I did find one similarity to some other posts: I moved hosts a couple months ago, and went from mySQL 4 to 5. This error never happened before the move.

Anyone have an idea what could be going on? Or how I can start to diagnose these constant db hiccups?

Thanks

--Pat