Error 1054 on Search page..

[cdxrevvved]

Ok, this is only on the search page that I get it. Im running oscmax 1.7 and the categories and catalogs, all of it shows fine. The search just returns this error. I know there were some changes with mysql 5, and I made a couple changes in the index.php file changing some things to p2c.products, but dont see where I need to fix this at.

Any help would be appreciated.

Also, how difficult would it be if i upgraded to 2.2, since a lot of the templates have been customized. Can I save those or will I have to remod it all from scratch?


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

select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%12%' or p.products_model like '%12%' or m.manufacturers_name like '%12%') )

[michael_s]

You need to manually patch your 1.7 store with the update051112 patch

Taking care not to overwrite anything but the update051112 patches. I suggest you do a dry run on a copy of your site first, to work out any kinks before you try it on your live site. Also make sure to backup your files.

Here is a link to the patch:
http://oscdox.com/index.php?name=Downloads&req=getit&lid=45

[cdxrevvved]

K.. Done that, 3 times now to be sure, changing only the 051112 patches. Still get the same error on the search page. Any other ideas?

Originally I had to change some lines from like p.products to p2c.products in the index.php and that fixed categories, etc.. looks like almost the same error as well.

[michael_s]

Here is the official osCommerce bug report:
osCommerce: Bug Reports

See the 9 Jan 2006 05:25:14 post for the fix.

:

[Keilup]

You need to manually patch your 1.7 store with the update051112 patch

I'm in much the same situation as OP. I'm on 1.7. Moved to new host and got the 1054 errors immediately. Turns out it's the MySQL 5 issues. I've made a couple changes and got rid of all errors so far but one - still get 1054 in "Printable Catalog".

Anyway, what I think is best to do is upgrade my store from 1.7 to 2.0. However, after a lot of searching, I'm still not clear on how exactly to do this. If I make all the manual changes in "update051112" to my site, will it then be RC2? Or is there something else I should do first? What are the correct steps to get from 1.7 to 2.0?

If you can point me in the right direction it would be most appreciated.

[mnpolock]

Hi Michael,

Read the readme file and it say only for use with OSCMAX 2 <---

I am guessing that it doesn't fix the problem in OSCMAX V1.7 ? .... just moved to a new host still running V1.7 and seeing this problem now. Any ideas for V1.7

Thanks,

Tony