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

[svrv]

i am getting an error: 1054 - Unknown column 'p.products_id' in 'on clause'

 

i know that this generally has something to do with php5 but Mamp is set up on php4

 

our online store is already set up on a web server with:

 

Apache version 1.3.37 (Unix)

PHP version 4.4.7

MySQL version 4.1.22-standard

 

i am trying to set up a local testing server using Mamp with:

 

Apache version 2.0.63 (Unix)

PHP version 4.4.9

MySQL version 5.1.37

 

 

I know that the versions do not all match, is that the problem?

I am just trying to get a local version working if anyone has any ideas i am all ears.

 

Thanks

 

Nick

[MrPhil]

i know that this generally has something to do with php5 but Mamp is set up on php4

Wrong. It's MySQL 5 that osC is incompatible with. All explained here: http://www.oscommerce.com/forums/topic/335136-osc-and-mysql-5-1054-errors

[Guest]

i am getting an error: 1054 - Unknown column 'p.products_id' in 'on clause'

 

On which page you got this error?

 

If you have access to phpMyAdmin it can be good idea test your SQL-query there. Of course you must then change all $variables to correct values before testing...

 

-ppajukos-