William F Posted July 7, 2008 Posted July 7, 2008 Hello everyone =) Hope you had a great weekend! Please help me out here if you can. I am at a complete loss as how to fix or correct this problem. I am getting this error when testing my cart checkout process: 1146 - Table 'mycart.orders_products_attributes' doesn't exist insert into orders_products_attributes (orders_id, orders_products_id, products_options, products_options_values, options_values_price, price_prefix) values ('1', '1', 'download', 'e-book', '0.0000', '+') I went into mySQL database at Godaddy and looked for the orders_products_attributes table and couldn't find one, so I thought i would import the oscommerce.sql file into the database, just in case the orders_products_attributes table didn't get added for some reason.....The oscommerce.sql installed ok but still did not solve the problem. There still is no orders_products_attributes table in the database. Is there suppose to be one, or is one of the other tables perhaps named wrong? I don't know. I am new at this so please forgive the dumb question :blush: Here is a list of the tables in my SQL store database: address_book address_format administrators adsense_cc amazon_prod banners banners_history cache categories categories_description configuration configuration_group counter counter_history countries currencies customers customers_basket customers_basket_attributes customers_info faq geo_zones info_about info_conditions info_privacy languages links_description links_status links_to_link_categories link_categories link_categories_description manufacturers manufacturers_info newsletters orders orders_products orders_products_download orders_status orders_status_history orders_total products products_attributes products_attributes_download products_description products_notifications products_options products_options_values products_options_values_to_products_options products_to_categories reviews reviews_description seo_google seo_msn seo_yahoo sessions specials tax_class tax_rates whos_online zones zones_to_geo_zones Now I have about 200 products in the catalog and would like to add more, if I can get this bug? worked out. I would greatly appreciate any help you guys can give me. I have been at this for the past week and can't seem to find a solution. Thanks in advance, William
Guest Posted July 7, 2008 Posted July 7, 2008 Does it really say 1146 - Table 'mycart.orders_products_attributes' doesn't exist? What contribution were you installing?
William F Posted July 7, 2008 Author Posted July 7, 2008 Does it really say 1146 - Table 'mycart.orders_products_attributes' doesn't exist? What contribution were you installing? Hello Coopco, and thanks for the response. Yes, the error really does say 1146 - Table 'mycart.orders_products_attributes' doesn't exist ("mycart" is the database name). This error happens right after i press the button to confirm the order (just before it takes you to the Paypal page) I installed oscommerce v2.5. It was a pre-built turnkey site, built by a webmaster last year and is suppose to be ready to go.. The install went great with no errors.
Guest Posted July 7, 2008 Posted July 7, 2008 Hello Coopco, and thanks for the response. Yes, the error really does say 1146 - Table 'mycart.orders_products_attributes' doesn't exist ("mycart" is the database name). This error happens right after i press the button to confirm the order (just before it takes you to the Paypal page) I installed oscommerce v2.5. It was a pre-built turnkey site, built by a webmaster last year and is suppose to be ready to go.. The install went great with no errors. Without knowing the contrib it is hard to get the sql to insert the table correctly. It maybe QTPro from here http://addons.oscommerce.com/info/888
William F Posted July 8, 2008 Author Posted July 8, 2008 Without knowing the contrib it is hard to get the sql to insert the table correctly. It maybe QTPro from herehttp://addons.oscommerce.com/info/888 Hello again Coopco. The contrib is 2.2RC1. Are you saying that I can possibly get this corrected with QTPro for 2.2.RC1?
Guest Posted July 8, 2008 Posted July 8, 2008 Hello again Coopco. The contrib is 2.2RC1. Are you saying that I can possibly get this corrected with QTPro for 2.2.RC1? You mean QT Pro v4.3 for OSC v2.2 RC1 or osc 2.2RC1? Do you have QTPro installed?
mrbags Posted July 8, 2008 Posted July 8, 2008 You mean QT Pro v4.3 for OSC v2.2 RC1 or osc 2.2RC1? Do you have QTPro installed? I have this issue only on my admin side, but I didn't install QT Pro. The only module I have installed outside of oscommerce-2.2rc2a is STS. When I go to update the status of an order (using paypal) I get this error message on the admin screen and I cant set the status from pending to processing/shipped. * Edit: I'm sorry I didnt read the entire error message on this thread before posting. It was close enough, My error message says: 1146 - Table 'MYCART.orders_status_history_transactions' doesn't exist SELECT transaction_id, transaction_type, payment_type, payment_status, module_code, transaction_avs, transaction_cvv2, transaction_msgs FROM orders_status_history_transactions WHERE orders_status_history_id = 1 LIMIT 1
Guest Posted July 8, 2008 Posted July 8, 2008 I have this issue only on my admin side, but I didn't install QT Pro. The only module I have installed outside of oscommerce-2.2rc2a is STS. When I go to update the status of an order (using paypal) I get this error message on the admin screen and I cant set the status from pending to processing/shipped. * Edit: I'm sorry I didnt read the entire error message on this thread before posting. It was close enough, My error message says: 1146 - Table 'MYCART.orders_status_history_transactions' doesn't exist SELECT transaction_id, transaction_type, payment_type, payment_status, module_code, transaction_avs, transaction_cvv2, transaction_msgs FROM orders_status_history_transactions WHERE orders_status_history_id = 1 LIMIT 1 OK, I have not used STS, but is there a part of the install that says to do this ?????? if QTPRO is installed?
William F Posted July 8, 2008 Author Posted July 8, 2008 You mean QT Pro v4.3 for OSC v2.2 RC1 or osc 2.2RC1? Do you have QTPro installed? No, I don't have QT Pro installed. Should I install version 4.3, and will it work ok with OSC 2.2RC1? I would like to mention Coopco that when I installed this version, it came with over 250 products already in the catalog and zip files in the download folder, also with the images of the products in the images folder. When I go into the products attributes section (under catalog), here are the settings: Product Options Option IDOption Name 1 | ID Option Name Action 1 Format Option Values 1 | ID Option Name Option Value Action 1 Format Download 1 | ID Product Name Option Name Option Value Value Price Prefix Action 1 Product 1 Format Download 0.0000 + The is NO filename in the filename box for ANY of the products.. There is a dropdown box with all the products in the catalog. Shouldn't they be entered in the filename box as well?(product.zip) If I enter the filename in the filename box for each product and press insert, won't that give me a different product id then was already added for that product when i installed the script? Or, should i just leave things as they are and just put the filename in the box for each product in the dropdown list. I know this sounds confusing, and I hope you understand what I am asking. Thanks, William.
Guest Posted July 8, 2008 Posted July 8, 2008 No, I don't have QT Pro installed. Should I install version 4.3, and will it work ok with OSC 2.2RC1? I would like to mention Coopco that when I installed this version, it came with over 250 products already in the catalog and zip files in the download folder, also with the images of the products in the images folder. When I go into the products attributes section (under catalog), here are the settings: Thanks, William. Now you are getting to questions that are outside of the boundaries of this forum. Since you have a turnkey solution, you would need to ask the turnkey provider.
William F Posted July 8, 2008 Author Posted July 8, 2008 Now you are getting to questions that are outside of the boundaries of this forum. Since you have a turnkey solution, you would need to ask the turnkey provider. I have. The provider says the solution was tested and working fine. I think the prblem is with something that I am doing wrong, which is why i came here.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.