Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

1146 - Table doesn't exist? Help Please...


William F

Recommended Posts

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

Link to comment
Share on other sites

Does it really say 1146 - Table 'mycart.orders_products_attributes' doesn't exist?

 

What contribution were you installing?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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?

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Archived

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

×
×
  • Create New...