Path Problem

[Maxen]

Hey everybody!

 

I made this site: http://icon-grp.com/clothes/HTML/catalog/index.php (it is just a test site, so it's not perfectly up and running yet)

 

And suddently i had a problem, i kept getting this message: Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'......................................... and so on...

 

I found this fix online: http://www.pubwebhost.com/mysql5upgrade.html

I put it on all of the pages described except for the advanced_search... (i could find the place to put it in, if you know what line please let me know)

 

It worked fine except for one thing. FX: when i clicked on the SPEAKERS category it says: "There are no products to list in this category." even though i know that all of my products are in that category.

 

I think it is a path problem, and i really hope that some of you know how to fix it. >_<

 

Thanks

[MrPhil]

Is your (new) host running MySQL version 5? If so, start here: http://www.oscommerce.com/forums/index.php?showtopic=335136&hl=

[Maxen]

Would that also change the category page?

[MrPhil]

Are you asking if it will fix the problem with nothing coming up for a category? It might, if the database query to get all the products in that category has failed (and thus returned nothing). Go ahead and find all the LEFT JOIN places (with a list of tables) and fix them anyway. You'll need to, sooner or later.

 

If you are using 2.2 MS2 or earlier, also check that your register global variables are "on" in PHP. I think sometime around RC1 (or maybe later) osC was upgraded to not need register globals any more. Are you getting an error message from osC that register globals need to be enabled?

[Maxen]

I got it working, thanks for helping :rolleyes: