Error 1054 - Unknown column Help!!!

[HolmesHustle]

I am getting a error when trying to view categories and so on...

 

http://www.neverseezproducts.com/shop

 

and the error message is:

 

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

 

[TEP STOP]

 

 

what could be my problem?

[jonquil]

Searching the forums for you, it may be that you could have installed a contribution and not run a required SQL query to create a field needed by the contribution. Could this be it?

 

jon

[HolmesHustle]

I'm not sure...it's a template from template monster that im trying to help my friend install on his server which is just horrible... ive never had so many problems ever on mine if any and this is like one thing after another! i do know that i was having another problem with not gettin in to the admin panel and i was givin this advice:

 

 

Seems there is a lot of people having problems with php5 and osCommerce. I have no problems here. Maybe a site admin can sticky this.

 

 

 

What needs to be done is two things.

 

Before you install you must

 

1: Change in php.ini

register_globals = On

register_long_arrays = On

 

2: Change in catalog/admin/includes/classes/upload.php

on line 31 change

 

$this = null;

 

to

 

//$this = null;

 

 

i did step 2 and it fixed the admin pannel problem but i dint do step 1 because idk what php.ini is or where its found... so maybe i need to do that but some assistance as to how?

[jonquil]

As absolute guess (not knowing your setup):

 

/usr/local/lib/php.ini

 

jon

[HolmesHustle]

yah couldnt find it wow i hate this host

[jonquil]

Can't find it via FTP? Sorry for all the trouble you're having.

[HolmesHustle]

no =/ i checked every folder...this is on a windows box with god knows what setup as im just now finding out 0_0

[Brooke]

you may need to ask your host about your php.ini not all hosts give access to that file.

 

 

i dont know if that will solve your error though. was this store ever working properly with the template? my first guess is always a problem with the template, they can be such nightmares. did you install oscommerce first and then add the template? or was this a template that comes with all the oscommerce files already and you install it all at once? it looks like your install didnt go well.

[jonquil]

Best take care of permissions on your includes/configure.php. 'tis writeable :(

[HolmesHustle]

the template came with all the oscommerce files already =/

[HolmesHustle]

and i know that too...with this host you have to send in tickets to have anything like that done lol the control pannel is suuuper limited...

[Brooke]

and i know that too...with this host you have to send in tickets to have anything like that done lol the control pannel is suuuper limited...

you can set the permissions on your files with an FTP program.

[HolmesHustle]

nope 0_0 the server gives the error of "unreconized command" or something like that... in their ticket they said "thats more of a linix/unix" command in a ftp program and not compatable with wondows boxes...complete noobs =/

[jayeshshiyani]

I am getting a error when trying to view categories and so on...

 

http://www.neverseezproducts.com/shop

 

and the error message is:

 

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

 

[TEP STOP]

what could be my problem?

 

Please read PM!!!

[Guest]

likely caused because you're using mysql 5.x install/update to the latest osc

http://www.oscommerce.com/solutions/downloads