Error on line 1054

[Evil Hamsterbot]

Alright, so I installed CPB 1.00 and the patch and all that today, followed the instructions to the dot- but all of my pages don't show anything on them except for the error

1054 - Unknown column 'builder_product_flag' in 'where clause'

select products_id, products_status, products_quantity from products where builder_product_flag = '1' and products_date_added < DATE_SUB(now(), INTERVAL 2 HOUR)

[TEP STOP]

 

I've been searching the forums all day, and I'm sorry if this is an overrepetitive question for some of you, but could somebody help please? It's confusing the heck out of me.

Edited October 18, 2009 by Evil Hamsterbot

[germ]

Step 14 from the install directions:

 

##### STEP 14. ALMOST FINISHED!!

################################

 

Open your admin panel now.

 

Create two new product categories in your catalog; 'Assembly Fees' and 'Custom Products'

 

Suggestion: Create a few products under the Assembly Fees category so you can see how

they fit into the builder's frontend. There must not be any sub-categories in the Assembly

Fees category, the builder will not look inside them.

 

Click the 'Custom Products' option on the left of the page (just below Configuration).

 

Click the 'UPDATE' button to create the DB Tables (you should get an error message telling you to do this anyway).

 

FYI: The builder creates three tables for itself and then also modifies two osC tables, as follows:

builder_categories - new table, contains the builder categories you define in the builder (excluding assembly fees).

builder_dependences - new table, contains the individual product dependences you define for each builder category.

builder_options - new table, contains all the builder settings.

products - modified, new field 'builder_product_flag', allows easy identification of custom-built products.

products_options_values - modified, two new fields 'catalog_products_id' and 'catalog_products_quantity' for components.

Sounds like you haven't done that yet or it wasn't successful.

 

The contrib has a support thread look it over or post in it.

 

You might be more apt to find corrective action that way.