Error viewing products after wiping them all out.

[cdxrevvved]

Hello all, been a while.. Had everything working once upon a time, but needed to wipe out and redo my products database. So, I deleted everything in there, categories, products and all. Then I added in some new categories and products, and now, it will display the categories just fine, but I get an error message like the one below.

Looking over the database tables, everything appears in place just fine, no table configs have changed or anything. Any ideas what could be going on? I can do a table dump if needed.

I think this is the right forum for the version Im using, i cant find a version number anywhere.. Aside from where it says osCommerce ms2-max.

Thanks for you help!! Wanna get this back up by weeks end at the latest!

1054 - Unknown column 'p.products_id' in 'on clause'

select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.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' and p2c.categories_id = '279'

[michael_s]

See this:
Error #1054 caused by MySQL 5.0?

[cdxrevvved]

Even though it was all working just perfect before i wiped out the products tonite? seems a little odd but worth a shot. =)

Umm, one other thing. Gotta link? cant seem to find the link to download the update..

Nvm. FOund it..

[michael_s]

If your server was recently upgraded to mysql 5 or php 5, the error would only crop up after the upgrade, so it is not strange at all really.

[cdxrevvved]

Catch is, I didnt do any upgrades. Ive been running this same setup for at LEAST 8 months now. The site worked fine till i removed all the products to get the inventory updated.

Ill install the patch tomorrow'ish and see if it fixes things for me. Currently Im running php 4.3.11 and mysql 5.0.21.

Tomorrow shall be the test I guess. If it works, I owe ya one.. =)

[michael_s]

Odd... You should have always gotten that error if you have been on mysql 5... I think you will be ok after the update.

Let me know if all goes well...or not.

[cdxrevvved]

Well, first thing I noticed in the read me was: "DO NOT INSTALL ON A PLAIN OSCOMMERCE MS2 SHOP!" .. well, thats what I have.. MS2-MAX.

So doing some searching I found this:
1054 - Unknown column 'p.products_id' in 'on clause' - AWH Forums

A one liner for the index.php page. Made 4 changes total in the file and works like a charm now!!!

[michael_s]

MS2Max is not a plain oscommerce MS2 shop. It is the v1.x version of osCMax.

You posted to the wrong forum though... this is for discussing osCMax v2.0, and so I gave you the solution for v2.0... Next time make sure you post to the correct forum.

Glad you found the solution to your problem.

[cdxrevvved]

Ok. least I know which ver it is.. Still cant find a version number listed anywhere in the admin.. Ah well.. preciate the help!