Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL problem, I think!!!


Recommended Posts

Hi,

 

I think I have a sql problem, if I try to look at the order or packingslip in de admin I get the following error

 

1054 - Unknown column 'products_model' in 'field list'

 

select orders_products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price from orders_products where orders_id = '14'

 

[TEP STOP]

 

I think the problem is in the products_model that is called because I use the products-sku and changed this everywhere where it was called, only not in the sql product-id.

 

After working with oscommerce I'm getting more confidence with using php, only messing around with the sql scares the hell out of me :o

 

Can somebody help me with this? and show me what to do :blush:

 

Thanks Denice

Link to comment
Share on other sites

If I'm understanding you correctly, I think you made changes to column names in the database.

 

Based on my assumption, I suggest that you check the database table called "orders_products". Change the column called "products_sku" back to "products_model".

Link to comment
Share on other sites

If I'm understanding you correctly, I think you made changes to column names in the database.

 

Based on my assumption, I suggest that you check the database table called "orders_products". Change the column called "products_sku" back to  "products_model".

 

Thank you, that did the trick. Only know I have the problem that the sku is not showing in de invoice or packingslip. Oh Well, that's the name of game, I will start searching the forum to see if someone had that same problem

 

Thanks again

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...