store not working when moved to a new server

[bozboz]

Hi I wonder if anyone can help with a problem that has me tearing my hair out at the moment

 

I have just moved a store to a new server and its functioning entirely fine as far as i know except for that the products in each category are not being listed

 

when the store tries to go to a main category page i get the nav etc but an error occurs which i have traced to product_listing.php

 

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 = '91'

 

 

The database and code are the same in both stores, the only difference is that one requires vars to be set in php.ini one in htaccess files. register globals is enabled but perhaps there is something else that is not enabled and causing the error

 

Im pretty much at a loss to work out why this one query is not working, i can only guess that the url is not being dissected properly on this occasion ad so the query fails?

 

 

here is a link to the erroring store

 

http://www.eddielock.co.uk/index.php?cPath=81_91 - the error message shows in black so you cant see it unless you highlight the page

 

the store is working fine here http://svr33.edns1.com/~eddie/index.php

 

Any help would be greatly appreciated else i will have to revert back to th eold server

 

Thanks in advance!

[bozboz]

anyone?

[Gauravs]

what is the version of PHP and mysql.

This error comes after upgrade of mysql from 4 to 5 due to the way left join is handled in new version, while queries were made for version 4.

 

Cheers

Gaurav

[bozboz]

what is the version of PHP and mysql.

This error comes after upgrade of mysql from 4 to 5 due to the way left join is handled in new version, while queries were made for version 4.

 

Cheers

Gaurav

 

 

 

Thanks

 

on the old server 4.3.11 is Php versiona nd MYSQL version is MySQL version 4.0.25-standard

 

on the new server Php version is 4.4.7 anf Mysql verison is 5.0.27

 

So it seems you may well be correct.

 

Do you have any idea how i can correct the left join statements ?

 

Thanks!

[♥toyicebear]

There are mysql/php 5 upgrade contribs available in the add-ons section at this site...

 

or you can upgrade your osCommerce shop to the latest version RC1 , available in the downloads section.

[bozboz]

Thanks everyone. I have now fixed the issue after finding this thread via google

 

http://www.oscommerce.com/forums/index.php?sho...p;#entry1148504

 

I think as you say it relates to the MYSQL queries

 

Thanks for all the help!