After installing Monster template on OSC

[macstunning]

I have been having several problems after installing a OSC Monster template for my website

 

When you click on category this error comes up:

 

"

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

 

[TEP STOP] "

 

The second problem I'm having is that I had to change title on homepage. I'm wondering if I'll have to do this for the rest of the pages. And 3rdly how do I autoamtically make the language NGN (=N=) insteand of $. There is a currency drop down. And I've added my own currency from admin but it seems not reflecting in catalog. BUt from Admin I see the NGN (=N=) currency sign.

 

Along the line I'm thinking most of my problems might be from the template. And I would want to believe the template version older than the OSC version I have installed.

 

If you would like to have URL to the website plese send my a private message through the forum or an email majormediainc (a) gmail . com

 

I sincerely need help

[spooks]

Did you test before you applied template?

 

Error Message - 1054 - Unknown column 'p.products_id' in 'on clause'

 

If you get this message it is probably due to your server upgrading to php5 or MySQL5

 

Update your version with the required php5/mysql5 code snippets

 

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

 

For the rest talk to monster, as your code is changed so we've no idea.

[macstunning]

Well I can't see the section to change change in my index.php and on search_result.php. I need the codes I should update them with.

 

======================

 

Error Message - 1054 - Unknown column 'p.products_id' in 'on clause' ozstar 11 Nov 2006

 

If you get this message it is probably due to your server upgrading to php5 or MySQL5. You get the message when you try a search on your site. The new OSC from around Sept-Oct 2006 or so, doesn't have this problem.

 

You just need to change one section in index.php and one in advance search_result.php.

 

Very simple Good Luck!

 

Ozstar

[spooks]

talk to monster, as your code is changed so we've no idea.

[bkellum]

I have been having several problems after installing a OSC Monster template for my website

 

When you click on category this error comes up:

 

"

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

 

[TEP STOP] "

 

The second problem I'm having is that I had to change title on homepage. I'm wondering if I'll have to do this for the rest of the pages. And 3rdly how do I autoamtically make the language NGN (=N=) insteand of $. There is a currency drop down. And I've added my own currency from admin but it seems not reflecting in catalog. BUt from Admin I see the NGN (=N=) currency sign.

 

Along the line I'm thinking most of my problems might be from the template. And I would want to believe the template version older than the OSC version I have installed.

 

If you would like to have URL to the website plese send my a private message through the forum or an email majormediainc (a) gmail . com

 

I sincerely need help

 

This is very common with purchased osC templates since you really do not know what version of PHP, MySQL or even what version of osCommerce they were built upon.

 

I personally think the best option when using a purchased template is to use STS (Simple Template System) to integrate it into the most recent version of osCommerce. By doing so, you get to keep the design of the purchased template but prevent the merging of any outdated code from the purchased template.

 

See my step by step on the subject here:

http://www.oscommerce.com/forums/index.php?showtopic=295660&st=2560&p=1131089entry1131089

 

I really hope you found this to be useful,