I need help !

[Sandra Shine]

Hi guys,

 

I heard this forum is full of clever people so I am writing in order to solve a problem.

I have purchesed an OS Comerce store software with a design.

But in the meantime my webhosting company updated my server from PHP4 to PHP5.

And now the store index page brings up this error message:

 

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

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '54' order by p.products_date_added DESC limit 3

 

[TEP STOP]

 

Please if you have any idea how could I make it work, PM or mail me with suggestions.

 

Thank you very much in advance,

 

Sandra

[Guest]

get the latest osc upgrade

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

 

integrate at least the mysql5.x changes to your store

[Sandra Shine]

get the latest osc upgrade

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

 

integrate at least the mysql5.x changes to your store

Thanks Enigma1, I have tried this already, it does not help.

 

I have one more Q.

 

Could you please tell me what does this mean in the mentioned update?

 

The following SQL queries need to be performed:

 

 

 

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

 

 

 

ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;

 

 

 

ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);

 

In the last line how do I set the "final_price" from NULL to DECIMAL(15,4) ?

 

Many thanks :-)

[Guest]

Thanks Enigma1, I have tried this already, it does not help.

meaning you still get the same error?

 

I have one more Q.

 

Could you please tell me what does this mean in the mentioned update?

 

The following SQL queries need to be performed:

 

 

 

ALTER TABLE whos_online MODIFY COLUMN last_page_url VARCHAR(255) NOT NULL;

 

 

 

ALTER TABLE customers MODIFY COLUMN customers_default_address_id INTEGER;

 

 

 

ALTER TABLE customers_basket MODIFY COLUMN final_price DECIMAL(15,4);

 

In the last line how do I set the "final_price" from NULL to DECIMAL(15,4) ?

 

Many thanks :-)

 

use the phpmyadmin to change the column parameters.

[Honza]

Hi

 

There is a work around , but might be depend dependant on your host cooperation.

 

I run a similar server and it is possible to have PHP4 and Php 5 at the same time on the same server.

 

One is the primary the other secondary,

 

the file atribute of the secondary has to be redefined

 

on my servers PHP5 is secondary there for any use of php5 files must be specified as filename.php5

 

 

 

so in your case the workaround will depend on 2 parts

 

1 the host has PHP on the server as secondary

 

2 you change all references to php to .php4

 

that is a massive task and you are probably better off getting a host with php 4 running where you know it is stable and will not be changed again and again.

 

Good luck

 

 

 

 

Hi guys,

 

I heard this forum is full of clever people so I am writing in order to solve a problem.

I have purchesed an OS Comerce store software with a design.

But in the meantime my webhosting company updated my server from PHP4 to PHP5.

And now the store index page brings up this error message:

 

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

 

select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price 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 = '54' order by p.products_date_added DESC limit 3

 

[TEP STOP]

 

Please if you have any idea how could I make it work, PM or mail me with suggestions.

 

Thank you very much in advance,

 

Sandra

[muttsnuts]

Have you edited anything they could possibly have cause the error?

 

Can you post and link?

 

In one of the previous posts someone recommends changing hosts. I would agree, my host runs php4 which has proved very reliable.