Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Error in admin order page


Guest

Recommended Posts

I have followed all of the instructions per the readme file and the credit cards go through with no problem and the emails arrive no problem but when i click on orders received and click on a name and click on edit, remove cc info, invoice, or packaging slip I get the following error.

 

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

 

select orders_products_id, products_id, products_name, products_model, products_price, products_tax, products_quantity, final_price, products_serial_number from orders_products where orders_id = '83'

 

[TEP STOP]

 

 

Anyone have an idea as to what I have done wrong or missed?

I would really appreciate the help. Lisa

Link to comment
Share on other sites

cdubshon had the product serial number contrib installed, but the insert for sql was missing. Added and fixed.

9 times out of 10 its a PEBCAK Error (Problem exists between chair and keyboard)

 

Replace that and you're fine...

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...