Jump to content
Sign in to follow this  
rngeer

(Contribution) Options Types V2 Database Error

Recommended Posts

Hello,

 

I am running a fresh install of Options Types V2 on a clean version of osCommerce 2.2rc2a.1.

 

The contribution works great until I add the File Upload Option. When running the cart I get this at the top of the product page:

 

-----------------------------------------------------

 

1146 - Table 'mydatabase.TABLE_FILES_UPLOADED' doesn't exist

 

select files_uploaded_name from TABLE_FILES_UPLOADED where sesskey = 'ad19a110323aa858cfe28c38412521d3' or customers_id = '0'

 

---------------------------------------------------------------

 

Has anyone seen this before? I can see the table in the DB.

 

Any info would be great.

Share this post


Link to post
Share on other sites

UPPER_CASE_ERRORS usually mean something isn't defined in a PHP file somewhere.

 

My guess is you skipped this part of the install directions:

 

***********

Open /catalog/includes/database_tables.php

 

 

*** BEFORE THE END ?> ADD ***:

 

 

define('TABLE_FILES_UPLOADED', 'files_uploaded'); //BOF - Zappo - Option Types v2 - ONE LINE - File Uploading

define('TABLE_PRODUCTS_OPTIONS_TYPES', 'products_options_types'); //BOF - Zappo - Option Types v2 - ONE LINE - Option Types

 

 

********


If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Share this post


Link to post
Share on other sites

Have you created the products_options_types and files_uploaded tables in your mysql database?


Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×