Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

(Contribution) Options Types V2 Database Error


rngeer

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.

Link to comment
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 >

Link to comment
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.

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