Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OK folks - I still need help.


onesixthdepot

Recommended Posts

The error:

 

1054 - Unknown column 'p.products_cost' in 'field list'

 

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_cost, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '18484' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

This error report is in place of the shopping cart contents - front end only - IF I look at the customers cart contents via whosonline - I see everything fine.

 

I have searched all of the visible php files for "p.products_cost" - I have not found anything...

 

IS there hidden files in oscommerce?

 

WHERE is the "registry file"?

IS there a registry file?

 

I am at a point where I am contemplating starting from scratch - but the fact that I have OVER 6000 different items in stock, keeps me from starting from fresh (ALOT of data entry)

 

HELP?

 

Thanks again...

 

Bear Johnson

www.onesixthdepot.com

Link to comment
Share on other sites

The error:

 

1054 - Unknown column 'p.products_cost' in 'field list'

 

select p.products_id, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_cost, p.products_weight, p.products_tax_class_id from products p, products_description pd where p.products_id = '18484' and pd.products_id = p.products_id and pd.language_id = '1'

 

[TEP STOP]

 

This error report is in place of the shopping cart contents - front end only - IF I look at the customers cart contents via whosonline - I see everything fine.

 

I have searched all of the visible php files for "p.products_cost" - I have not found anything...

 

IS there hidden files in oscommerce?

 

WHERE is the "registry file"?

IS there a registry file?

 

I am at a point where I am contemplating starting from scratch - but the fact that I have OVER 6000 different items in stock, keeps me from starting from fresh (ALOT of data entry)

 

HELP?

 

Thanks again...

 

Bear Johnson

www.onesixthdepot.com

 

Hi

 

Please check the dataase for the field. The product_cost is not a standard field. Also, I am not sure of your implementation details ( templates ). but since thereis a specific mention to the products id. check the

includes/classes/shopping_cart.php

includes/modules/*.php

product_info.php

shopping_cart.php

 

Regards,

Hari

Link to comment
Share on other sites

Hi

 

Please check the dataase for the field. The product_cost is not a standard field. Also, I am not sure of your implementation details ( templates ). but since thereis a specific mention to the products id. check the

includes/classes/shopping_cart.php

includes/modules/*.php

product_info.php

shopping_cart.php

 

Regards,

Hari

 

WOOT!

 

I found it!

 

I deleted the line!

 

AND...

 

wait for it!

 

IT WORKS FINE NOW!

 

Hari - it was NOT in modules...

It was hiding in classes/order.php

 

I swear I looked there...

 

phew!

 

I do NOT have to relist all that stock...

 

Bye for now - may it be a LONG time before I have the need to visit this forum again!

 

Thank you all for being here!

 

Bear Johnson

www.onesixthdepot.com

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...