Missing SQL table/query?

[Guest]

Hi gang,

 

Sorry if this is an obvious fix, however after installing, modifying and also noting (and correcting) the other issues noted for this release (btw - great work and thank you!) I am having a most unique error that I have not seen mentioned yet. This is a fresh install of os commerce and the ccc contribution.

 

When I go to: Add Products Into Custom Computer Creator

 

1146 - Table 'discoveryhillside_com.ccc_temp_products' doesn't exist

select * from ccc_temp_products

 

This table was not part of the SQL query (the ccc_temp_products part) that was supplied with the release docs and creating the table "should" not be an issue, however can anyone tell me what the values are for this? Or if I did miss it, where the instructions outlining it were?

 

Thanks in advance

Lyle Macgregor

[Guest]

it means you did not run the sql query to setup ccc on your oscommerce database. if you downloaded the latest ccc open up the read.htm file, click on database, then copy the statements there, then open mysqlcc, phpmyadmin or go to mysql directly, whatever you have access to and execute the query to install the file, then you should be good to go. have to make sure you read all the instructions.

[Guest]

http://store.discoveryhillside.com/install.htm

 

Is what came with the dist (I had to modify to get end statements for each query as well) . Sorry, I just don't see the ccc_temp_products entry in the instructions.

[Guest]

looks like you are right, as i have scanned through pretty much everything in the code, where ccc_temp_products is referenced, I would assume by the name, and what it calls, that creating a table similar to products should suffice. only thing i can say is to try it, see what you come up with. did you look at one of the earlier versions and see if it may be in one of those sql queries?