urgent help needed - cart broke on host switch

[denning]

OScommerce site broke when switching from Plesk host (Mediatemple.net) to a new Cpanel host.

 

Urgently need help getting it running again.

 

Thanks

[Wayne Weedon]

Seems you need to setup your database.

 

Create a blank one with Cpanel. Use phpmysql to import your last backup .sql file from your old host into the blank database.

 

Note the database name and username & password when doing the above,

 

Then

 

Modify the two configure.php files to reflect the new database name, username, password.

 

Wayne...

[Guest]

Adolf,

 

As Wayne pointed out, there are database issues. However, I don't suggest creating another database. It is obvious that there is more going on than just the database issue, there are also layout issues with your landing page. Your oscommerce cart itself appears to function well, it's just the connection with the custom material which is probably hard coded.

 

 

Let me know if you have any other questions.

 

Chris

[Wayne Weedon]

It sort of works in the cart as far as I could see.

 

But it does appear some columns are missing from the database.

 

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

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_qty_blocks, p.products_tax_class_id, IF(s.status = '1' AND s.stores_id = '1', s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = '1' AND s.stores_id = '1', s.specials_new_products_price, p.products_price) as final_price from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_description pd left join specials s on p.products_id = s.products_id and s.stores_id = '1', products_to_categories p2c INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id where p2s.stores_id = '1' AND p.products_status = '1' and p.products_id = '1653' and pd.products_id = '1653' and pd.language_id = '1'

 

[TEP STOP]"

 

Thats why I suggested importing backup data from the old host into a fresh blank db as manually entering tables and columns required for an add on template etc can be a bitch of a job!

 

 

Wayne....

[burt]

mysql 5; the sql's need parentheses in the correct places.

 

The other error is in a non-standard piece of code that's been bastardised into osCommerce, change the passwords/username/host to match the new settings.