osCommerce and osCMax shopping cart software forums

Shopping Cart Software

osCommerce with teeth!

 

1054 - Unknown column when restock product

This is a discussion on 1054 - Unknown column when restock product within the osCMax v2 Customization/Mods forums, part of the osCMax v2.0 Forums category; Hi When deleting an order and checking the 'restock product quantity' box I get the following error 1054 - Unknown ...



Find us on Facebook
Go Back   osCommerce and osCMax shopping cart software forums > osCMax v2.0 Forums > osCMax v2 Customization/Mods

Connect with Facebook Register FAQDonate Members List Calendar Mark Forums Read


Closed Thread

 

LinkBack Thread Tools
  #1  
Old 07-06-2005, 12:09 PM
New Member
 
Join Date: Jun 2005
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
DigitalPimp
Default 1054 - Unknown column when restock product

Hi

When deleting an order and checking the 'restock product quantity' box I get the following error

1054 - Unknown column 'opa.products_attributes_id' in 'where clause'

SELECT opd.orders_products_filename FROM orders_products_attributes opa, orders_products_download opd WHERE opa.orders_products_id = '1' AND opa.products_attributes_id=opd.products_attributes _id


Any ideas anyone!!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #2  
Old 07-17-2005, 09:06 PM
Lurker
 
Join Date: Apr 2005
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
bet123cli
Default me too

i also got the same error. fixes anyone?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #3  
Old 07-25-2005, 11:39 AM
Member
 
Join Date: Aug 2004
Posts: 49
Thanks: 4
Thanked 4 Times in 3 Posts
Rep Power: 0
jbanda
Default

I, too, am getting this error - I know why I'm getting it, I just don't know what to do about it.

If you're not selling gift vouchers or any other virtual product (i.e. downloads), simply turn off the download feature in the admin panel. Once you've done so, you'll no longer get the error message when you delete a product and choose to restock the quantity.

However, I do have gift vouchers on both of my live sites, and if I turn off the download feature the site tries to charge the customer shipping for gift vouchers.

Can anyone help?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
  #4  
Old 07-25-2005, 02:57 PM
michael_s's Avatar
osCMax Developer


 
Join Date: Jul 2002
Location: Phoenix, AZ
Posts: 15,708
Thanks: 139
Thanked 606 Times in 519 Posts
Rep Power: 10
michael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond reputemichael_s has a reputation beyond repute
Default

Check the bugtracker. It is a bug in QTPro. You can update it to v4.2 to fix the problem.
__________________
Michael Sasek
osCMax Developer

*** Do not PM me requesting paid help. The only paid work I do is for AABox Web Hosting customers ***

Stay Up To Date with everything osCMax:
Free osCMax Newsletters - Security notices, New Releases, osCMax News
osCMax on Twitter - Up to the minute info as it happens. Know it first.

osCMax User Manual - osCMax Templates - Advanced Template Tutorial

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Closed Thread

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads

Thread Thread Starter Forum Replies Last Post
1054 - Unknown column 'a.authors_id' in 'on clause' fuzzyphil osCMax v2 Customization/Mods 29 01-08-2009 04:05 PM
Error: 1054 - Unknown column islander osCMax v2 Installation issues 1 02-27-2006 11:31 AM
1054 - Unknown column 'p.vendors_product_price' RoyceK osCMax v2 Installation issues 1 02-12-2006 08:22 PM
1054 - Unknown column 'popt.products_options_type Anonymous osCMax v1.7 Discussion 5 03-08-2004 01:47 AM
1054 - Unknown column - Help, please ! Anonymous osCommerce 2.2 Modification Help 2 11-27-2002 11:48 AM


All times are GMT -8. The time now is 02:58 AM.


Powered by vBulletin®
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
SEO by vBSEO
Copyright 2009 osCMax
Inactive Reminders By Icora Web Design