need help trouble with template instalation on alraedy made oscwebsite

[Guest]

Hi all, im new on these forums, untill yesterday i was able to manage it all myself lol.

 

Here is the problem, i installed a template on a website i already made before, on which i put products and a paysistem that all worked.

this is what i did.

i coppied the "include" and "images" folder from the template together with files as "account.php" "stylesheet.css" etc. Problem is (as you can see here www.marfiusgrowshop.com/osc ) when clicking on a category the following error appears:

 

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 = '3' and p2c.categories_id = '62'

 

[TEP STOP]

-------

 

so i tried to create new categories and products, but still the same error, i know it must be something bad linked to database or something.. but i am not really into mysql etc.. so i really need a hand...

 

please someone help me with this..

 

saludos from spain.

[davidinottawa]

Hi all, im new on these forums, untill yesterday i was able to manage it all myself lol.

 

Here is the problem, i installed a template on a website i already made before, on which i put products and a paysistem that all worked.

this is what i did.

i coppied the "include" and "images" folder from the template together with files as "account.php" "stylesheet.css" etc. Problem is (as you can see here www.marfiusgrowshop.com/osc ) when clicking on a category the following error appears:

 

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 = '3' and p2c.categories_id = '62'

 

[TEP STOP]

-------

 

so i tried to create new categories and products, but still the same error, i know it must be something bad linked to database or something.. but i am not really into mysql etc.. so i really need a hand...

 

please someone help me with this..

 

saludos from spain.

 

http://www.oscommerce.com/community/bugs,3...;+Configuration

http://mysqldatabaseadministration.blogspo...e-transfer.html