Software Transfer to New Server - Errors detected

[jco5150]

Hello All,

 

I have recently switched servers, I dumped the Database and Zipped up the shop contents. After modifying the configuration files i am receiving this error below when trying to access a category:

 

see page URL:

https://www.ginsingclothing.com/shop/

 

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

 

Accessing a product page and adding to cart works fine:

http://www.ginsingclothing.com/shop/produc...;products_id=46

 

Any advise on how to configure this correctly or what settings to confirm.

 

Thank you!

 

Jeremy

[BryceJr]

http://www.oscommerce.com/forums/index.php?showtopic=230304

 

http://www.oscommerce.com/community/contributions,4654

[jco5150]

http://www.oscommerce.com/forums/index.php?showtopic=230304

 

http://www.oscommerce.com/community/contributions,4654

 

 

Wow thanks for the quick response, that did indeed work! ! !

Now the remaining issue... I can see that the payment module isnt functioning properly. I have placed an order it collected my credit card info as its pending on the bank account, though there is an ERROR message that says check payment info again. It doesnt take the buyer to the confirmation page.

 

I have verified that the Gateway settings are correct as its collecting the payment!

 

Any ideas, maybe due to server upgrades?

Thanks so much!

 

J